How to use defaultschema in MSSQL

I am new to Liquibase and I have a MSSQL database with multiple schemas and I set the defaultSchemaName in my property file but when I run an liquibase update I am getting the following error. Is defaultSchemaName supported for MSSQL? If yes, how can I resolve this issue? Thanks

Caused by: liquibase.exception.DatabaseException: java.lang.RuntimeException: Cannot use default schema name user on Microsoft SQL Server because the login schema of the current user (dbo) is different and MSSQL does not support setting the default schema per session.
at liquibase.integration.commandline.CommandLineUtils.createDatabaseObject(
at liquibase.integration.commandline.Main.doMigration(
at liquibase.integration.commandline.Main$1.lambda$run$0(
at liquibase.Scope.lambda$child$0(
at liquibase.Scope.child(
at liquibase.Scope.child(
at liquibase.Scope.child(
at liquibase.integration.commandline.Main$

Try to create a property file like this one:

changeLogFile: …/path/to/file/dbchangelog.xml
driver: oracle.jdbc.OracleDriver
url: jdbc:oracle:thin:@
username: PRO
password: password
classpath: …/path/to/file/ojdbc6-
defaultSchemaName: your schema name

Thanks for your response. I am using SQL Server but I do have the defaultSchemaName in my property file and the error posted was what I got when I run the update.

Hi @twleo

Could you please share below details:

  1. Your file
  2. Liquibase version you are using

Rakhi Agrawal

Below is my property file. Liquibase version is 4.4.0. Thanks

classpath=C:\Program Files\liquibase\lib\sqljdbc_9.2\enu\mssql-jdbc-9.2.1.jre15.jar