Hi All,
I checked all the forum questions regarding my issue. But did not found any solution.
liquibase version
** Starting Liquibase at 15:59:19 (version 4.19.0 #6648 built at 2023-01-17 15:02+0000)
** My command line
liquibase --url=“jdbc:sqlserver://finiq668\sql_2019:1433;DatabaseName=DEV;integratedSecurity=false;encrypt=false” --username=“#####” --password=“#####” --changeLogFile=dbchangelog.mssql.sql status
** Gives following error
Unexpected error running Liquibase: Connection could not be created to jdbc:sqlserver://finiq668/sql_2019:1433;DatabaseName=DEV;integratedSecurity=false;encrypt=false with driver com.microsoft.sqlserver.jdbc.SQLServerDriver. The TCP/IP connection to the host finiq668/sql_2019, port 1433 has failed. Error: “finiq668/sql_2019. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.”.
** For this regard i set 1433 port in SQL configuration manager and windows firewall inbound and outbound rules , but did not solved the issue. Then i set log level to fine and found out following error
[2023-02-22 14:17:12] FINE [liquibase.database] Connecting to the URL:‘jdbc:sqlserver://finiq668,1433/sql_2019;DatabaseName=DEV;integratedSecurity=false;encrypt=false’ using driver:‘com.microsoft.sqlserver.jdbc.SQLServerDriver’
[2023-02-22 14:17:12] FINE [liquibase.servicelocator] Loaded liquibase.database.DatabaseConnection instance liquibase.database.jvm.JdbcConnection
[2023-02-22 14:17:12] FINE [liquibase.servicelocator] Loaded liquibase.database.DatabaseConnection instance com.datical.liquibase.ext.database.jvm.ProJdbcConnection
[2023-02-22 14:17:42] SEVERE [liquibase.integration] Connection could not be created to jdbc:sqlserver://finiq668,1433/sql_2019;DatabaseName=DEV;integratedSecurity=false;encrypt=false with driver com.microsoft.sqlserver.jdbc.SQLServerDriver. The TCP/IP connection to the host finiq668,1433/sql_2019, port 1433 has failed. Error: “finiq668,1433/sql_2019. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.”.
liquibase.exception.CommandExecutionException: liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: Connection could not be created to jdbc:sqlserver://finiq668,1433/sql_2019;DatabaseName=DEV;integratedSecurity=false;encrypt=false with driver com.microsoft.sqlserver.jdbc.SQLServerDriver. The TCP/IP connection to the host finiq668,1433/sql_2019, port 1433 has failed. Error: “finiq668,1433/sql_2019. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.”.
at liquibase.command.CommandScope.execute(CommandScope.java:186)
at liquibase.integration.commandline.CommandRunner.call(CommandRunner.java:55)
at liquibase.integration.commandline.CommandRunner.call(CommandRunner.java:24)
at picocli.CommandLine.executeUserObject(CommandLine.java:2041)
at picocli.CommandLine.access$1500(CommandLine.java:148)
at picocli.CommandLine$RunLast.executeUserObjectOfLastSubcommandWithSameParent(CommandLine.java:2461)
at picocli.CommandLine$RunLast.handle(CommandLine.java:2453)
at picocli.CommandLine$RunLast.handle(CommandLine.java:2415)
at picocli.CommandLine$AbstractParseResultHandler.execute(CommandLine.java:2273)
at picocli.CommandLine$RunLast.execute(CommandLine.java:2417)
at picocli.CommandLine.execute(CommandLine.java:2170)
at liquibase.integration.commandline.LiquibaseCommandLine.lambda$execute$1(LiquibaseCommandLine.java:352)
at liquibase.Scope.child(Scope.java:189)
at liquibase.Scope.child(Scope.java:165)
at liquibase.integration.commandline.LiquibaseCommandLine.execute(LiquibaseCommandLine.java:317)
at liquibase.integration.commandline.LiquibaseCommandLine.main(LiquibaseCommandLine.java:84)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at liquibase.integration.commandline.LiquibaseLauncher.main(LiquibaseLauncher.java:107)
Caused by: liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: Connection could not be created to jdbc:sqlserver://finiq668,1433/sql_2019;DatabaseName=DEV;integratedSecurity=false;encrypt=false with driver com.microsoft.sqlserver.jdbc.SQLServerDriver. The TCP/IP connection to the host finiq668,1433/sql_2019, port 1433 has failed. Error: “finiq668,1433/sql_2019. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.”.
at liquibase.integration.commandline.CommandLineUtils.createDatabaseObject(CommandLineUtils.java:140)
at liquibase.integration.commandline.Main.doMigration(Main.java:1482)
at liquibase.integration.commandline.Main$1.lambda$run$0(Main.java:396)
at liquibase.Scope.lambda$child$0(Scope.java:180)
at liquibase.Scope.child(Scope.java:189)
at liquibase.Scope.child(Scope.java:179)
at liquibase.Scope.child(Scope.java:158)
at liquibase.integration.commandline.Main$1.run(Main.java:395)
at liquibase.integration.commandline.Main$1.run(Main.java:217)
at liquibase.Scope.child(Scope.java:189)
at liquibase.Scope.child(Scope.java:165)
at liquibase.integration.commandline.Main.run(Main.java:217)
at liquibase.command.AbstractCliWrapperCommandStep.run(AbstractCliWrapperCommandStep.java:32)
at liquibase.command.CommandScope.execute(CommandScope.java:172)
… 20 more
** And if i create liquibase properties file and add those properties and run
liquibase --changeLogFile=dbchangelog.mssql.sql status
** i get valid message
Liquibase command ‘status’ was executed successfully.
thanks,
parikshit p
I have seen this happen where there is a character in the password that is not interpreted properly on the command line. Is the issue that you don’t want to use liquibase.properties file? I’d suggest using it, since it really should be used to hide username and password anyway.
1 Like
** thanks for your reply, as per your suggestion , i tried below command.
liquibase --url=‘jdbc:sqlserver://FinIQ668\SQL_2019;databaseName=DEV;encrypt=false;integratedSecurity=false’ --changeLogFile=dbchangelog.mssql.sql status --log-level=fine
** still got error, sharing output for your reference.
[2023-02-23 09:39:33] FINE [liquibase.resource] Creating resourceAccessor for directory G:\liquibase_groovy
[2023-02-23 09:39:33] FINE [liquibase.configuration] No configuration value for liquibase.searchPath found
[2023-02-23 09:39:33] FINE [liquibase.resource] Creating resourceAccessor for file C:\liquibase\internal\lib\mssql-jdbc.jar
[2023-02-23 09:39:33] FINE [liquibase.resource] Creating resourceAccessor for file C:\liquibase\internal\lib\liquibase-core.jar
[2023-02-23 09:39:33] FINE [liquibase.resource] Creating resourceAccessor for directory C:\liquibase\lib
[2023-02-23 09:39:33] FINE [liquibase.resource] Creating resourceAccessor for file C:\liquibase\internal\lib\commons-collections4.jar
[2023-02-23 09:39:33] FINE [liquibase.resource] Creating resourceAccessor for file C:\liquibase\internal\lib\commons-lang3.jar
[2023-02-23 09:39:33] FINE [liquibase.resource] Creating resourceAccessor for file C:\liquibase\internal\lib\commons-text.jar
[2023-02-23 09:39:33] FINE [liquibase.resource] Creating resourceAccessor for file C:\liquibase\internal\lib\connector-api.jar
[2023-02-23 09:39:33] FINE [liquibase.resource] Creating resourceAccessor for file C:\liquibase\internal\lib\h2.jar
[2023-02-23 09:39:33] FINE [liquibase.resource] Creating resourceAccessor for file C:\liquibase\internal\lib\hsqldb.jar
[2023-02-23 09:39:33] FINE [liquibase.resource] Creating resourceAccessor for file C:\liquibase\internal\lib\jaxb-api.jar
[2023-02-23 09:39:33] FINE [liquibase.resource] Creating resourceAccessor for file C:\liquibase\internal\lib\jaxb-core.jar
[2023-02-23 09:39:33] FINE [liquibase.resource] Creating resourceAccessor for file C:\liquibase\internal\lib\jaxb-runtime.jar
[2023-02-23 09:39:33] FINE [liquibase.resource] Creating resourceAccessor for file C:\liquibase\internal\lib\jaybird.jar
[2023-02-23 09:39:33] FINE [liquibase.resource] Creating resourceAccessor for file C:\liquibase\internal\lib\jcc.jar
[2023-02-23 09:39:33] FINE [liquibase.resource] Creating resourceAccessor for file C:\liquibase\internal\lib\liquibase-commercial.jar
[2023-02-23 09:39:33] FINE [liquibase.resource] Creating resourceAccessor for file C:\liquibase\internal\lib\mariadb-java-client.jar
[2023-02-23 09:39:33] FINE [liquibase.resource] Creating resourceAccessor for file C:\liquibase\internal\lib\mssql-jdbc.jar
[2023-02-23 09:39:33] FINE [liquibase.resource] Creating resourceAccessor for file C:\liquibase\internal\lib\ojdbc8.jar
[2023-02-23 09:39:34] FINE [liquibase.resource] Creating resourceAccessor for file C:\liquibase\internal\lib\opencsv.jar
[2023-02-23 09:39:34] FINE [liquibase.resource] Creating resourceAccessor for file C:\liquibase\internal\lib\picocli.jar
[2023-02-23 09:39:34] FINE [liquibase.resource] Creating resourceAccessor for file C:\liquibase\internal\lib\postgresql.jar
[2023-02-23 09:39:34] FINE [liquibase.resource] Creating resourceAccessor for file C:\liquibase\internal\lib\snakeyaml.jar
[2023-02-23 09:39:34] FINE [liquibase.resource] Creating resourceAccessor for file C:\liquibase\internal\lib\snowflake-jdbc.jar
[2023-02-23 09:39:34] FINE [liquibase.resource] Creating resourceAccessor for file C:\liquibase\internal\lib\sqlite-jdbc.jar
[2023-02-23 09:39:34] FINE [liquibase.resource] Creating resourceAccessor for directory C:\liquibase\internal\lib
[2023-02-23 09:39:34] FINE [liquibase.resource] Overall search path:
- G:\liquibase_groovy
- C:\liquibase\internal\lib\mssql-jdbc.jar
- C:\liquibase\internal\lib\liquibase-core.jar
- C:\liquibase\lib
- C:\liquibase\internal\lib\commons-collections4.jar
- C:\liquibase\internal\lib\commons-lang3.jar
- C:\liquibase\internal\lib\commons-text.jar
- C:\liquibase\internal\lib\connector-api.jar
- C:\liquibase\internal\lib\h2.jar
- C:\liquibase\internal\lib\hsqldb.jar
- C:\liquibase\internal\lib\jaxb-api.jar
- C:\liquibase\internal\lib\jaxb-core.jar
- C:\liquibase\internal\lib\jaxb-runtime.jar
- C:\liquibase\internal\lib\jaybird.jar
- C:\liquibase\internal\lib\jcc.jar
- C:\liquibase\internal\lib\liquibase-commercial.jar
- C:\liquibase\internal\lib\mariadb-java-client.jar
- C:\liquibase\internal\lib\ojdbc8.jar
- C:\liquibase\internal\lib\opencsv.jar
- C:\liquibase\internal\lib\picocli.jar
- C:\liquibase\internal\lib\postgresql.jar
- C:\liquibase\internal\lib\snakeyaml.jar
- C:\liquibase\internal\lib\snowflake-jdbc.jar
- C:\liquibase\internal\lib\sqlite-jdbc.jar
- C:\liquibase\internal\lib
[2023-02-23 09:39:34] FINE [liquibase.configuration] No configuration value for liquibase.shouldRun aka should.run found
[2023-02-23 09:39:34] FINE [liquibase.configuration] Configuration liquibase.shouldRun is using the default value of true
[2023-02-23 09:39:34] FINE [liquibase.configuration] No configuration value for liquibase.showBanner found
[2023-02-23 09:39:34] FINE [liquibase.configuration] Configuration liquibase.showBanner is using the default value of true
[2023-02-23 09:39:34] FINE [liquibase.configuration] No configuration value for liquibase.licenseKey found
[2023-02-23 09:39:34] FINE [liquibase.configuration] No configuration value for liquibase.pro.licenseKey found
[2023-02-23 09:39:34] FINE [liquibase.configuration] No configuration value for liquibase.monitorPerformance found
[2023-02-23 09:39:34] FINE [liquibase.configuration] Configuration liquibase.monitorPerformance is using the default value of false
[2023-02-23 09:39:34] FINE [liquibase.integration] Performance monitoring disabled
[2023-02-23 09:39:34] FINE [liquibase.configuration] No configuration value for liquibase.outputFile found
[2023-02-23 09:39:34] FINE [liquibase.configuration] No configuration value for liquibase.strict found
[2023-02-23 09:39:34] FINE [liquibase.configuration] Configuration liquibase.strict is using the default value of false
[2023-02-23 09:39:34] FINE [liquibase.configuration] No configuration value for liquibase.command.status.changelogFile found
[2023-02-23 09:39:34] FINE [liquibase.configuration] Found ‘liquibase.command.changelogFile’ configuration of ‘dbchangelog.mssql.sql’
command argument ‘–changelogFile’ of ‘dbchangelog.mssql.sql’
[2023-02-23 09:39:34] FINE [liquibase.configuration] No configuration value for liquibase.command.status.contexts found
[2023-02-23 09:39:34] FINE [liquibase.configuration] No configuration value for liquibase.command.contexts found
[2023-02-23 09:39:34] FINE [liquibase.configuration] No configuration value for liquibase.command.status.defaultCatalogName found
[2023-02-23 09:39:34] FINE [liquibase.configuration] No configuration value for liquibase.command.defaultCatalogName found
[2023-02-23 09:39:34] FINE [liquibase.configuration] No configuration value for liquibase.command.status.defaultSchemaName found
[2023-02-23 09:39:34] FINE [liquibase.configuration] No configuration value for liquibase.command.defaultSchemaName found
[2023-02-23 09:39:34] FINE [liquibase.configuration] No configuration value for liquibase.command.status.driver found
[2023-02-23 09:39:34] FINE [liquibase.configuration] Found ‘liquibase.command.driver’ configuration of ‘com.microsoft.sqlserver.jdbc.SQLServerDriver’
file exists at path liquibase.properties ‘driver’ of ‘com.microsoft.sqlserver.jdbc.SQLServerDriver’
[2023-02-23 09:39:34] FINE [liquibase.configuration] No configuration value for liquibase.command.status.driverPropertiesFile found
[2023-02-23 09:39:34] FINE [liquibase.configuration] No configuration value for liquibase.command.driverPropertiesFile found
[2023-02-23 09:39:34] FINE [liquibase.configuration] No configuration value for liquibase.command.status.labelFilter aka liquibase.command.status.labels found
[2023-02-23 09:39:34] FINE [liquibase.configuration] No configuration value for liquibase.command.labelFilter aka liquibase.command.labels found
[2023-02-23 09:39:34] FINE [liquibase.configuration] No configuration value for liquibase.command.status.password found
[2023-02-23 09:39:34] FINE [liquibase.configuration] Found ‘liquibase.command.password’ configuration of ‘’
file exists at path liquibase.properties ‘password’ of '’
[2023-02-23 09:39:34] FINE [liquibase.configuration] No configuration value for liquibase.command.status.url found
[2023-02-23 09:39:34] FINE [liquibase.configuration] Found ‘liquibase.command.url’ configuration of ‘jdbc:sqlserver://FinIQ668/SQL_2019;databaseName=DEV;encrypt=false;integratedSecurity=false’
command argument ‘–url’ of ‘’
Overrides file exists at path liquibase.properties ‘url’ of '’
[2023-02-23 09:39:34] FINE [liquibase.configuration] No configuration value for liquibase.command.status.username found
[2023-02-23 09:39:34] FINE [liquibase.configuration] Found ‘liquibase.command.username’ configuration of ‘sa’
file exists at path liquibase.properties ‘username’ of ‘sa’
[2023-02-23 09:39:34] FINE [liquibase.configuration] No configuration value for liquibase.command.status.verbose found
[2023-02-23 09:39:34] FINE [liquibase.configuration] No configuration value for liquibase.command.verbose found
[2023-02-23 09:39:34] FINE [liquibase.command] Pipeline for command ‘status: liquibase.command.core.StatusCommandStep
[2023-02-23 09:39:34] FINE [liquibase.configuration] No configuration value for liquibase.hub.apiKey found
[2023-02-23 09:39:34] FINE [liquibase.configuration] No configuration value for liquibase.propertyProviderClass found
[2023-02-23 09:39:34] FINE [liquibase.configuration] No configuration value for liquibase.databaseClass found
[2023-02-23 09:39:34] FINE [liquibase.configuration] No configuration value for liquibase.hub.url found
[2023-02-23 09:39:34] FINE [liquibase.configuration] Configuration liquibase.hub.url is using the default value of https://hub.liquibase.com
[2023-02-23 09:39:34] FINE [liquibase.integration] Liquibase Hub URL: https://hub.liquibase.com
[2023-02-23 09:39:34] FINE [liquibase.configuration] Found ‘liquibase.hub.mode’ configuration of ‘OFF’
file exists at path liquibase.properties ‘liquibase.hub.mode’ of ‘off’
[2023-02-23 09:39:34] FINE [liquibase.integration] Liquibase Hub Mode: OFF
[2023-02-23 09:39:34] FINE [liquibase.database] Properties:
[2023-02-23 09:39:34] FINE [liquibase.database] Key:‘password’ Value:’**********’
[2023-02-23 09:39:34] FINE [liquibase.database] Key:‘user’ Value:‘sa’
[2023-02-23 09:39:34] FINE [liquibase.database] Connecting to the URL:‘jdbc:sqlserver://FinIQ668/SQL_2019;databaseName=DEV;encrypt=false;integratedSecurity=false’ using driver:‘com.microsoft.sqlserver.jdbc.SQLServerDriver’
[2023-02-23 09:39:34] FINE [liquibase.servicelocator] Loaded liquibase.database.DatabaseConnection instance liquibase.database.jvm.JdbcConnection
[2023-02-23 09:39:34] FINE [liquibase.servicelocator] Loaded liquibase.database.DatabaseConnection instance com.datical.liquibase.ext.database.jvm.ProJdbcConnection
[2023-02-23 09:40:04] SEVERE [liquibase.integration] Connection could not be created to jdbc:sqlserver://FinIQ668/SQL_2019;databaseName=DEV;encrypt=false;integratedSecurity=false with driver com.microsoft.sqlserver.jdbc.SQLServerDriver. The TCP/IP connection to the host FinIQ668/SQL_2019, port 1433 has failed. Error: “FinIQ668/SQL_2019. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.”.
liquibase.exception.CommandExecutionException: liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: Connection could not be created to jdbc:sqlserver://FinIQ668/SQL_2019;databaseName=DEV;encrypt=false;integratedSecurity=false with driver com.microsoft.sqlserver.jdbc.SQLServerDriver. The TCP/IP connection to the host FinIQ668/SQL_2019, port 1433 has failed. Error: “FinIQ668/SQL_2019. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.”.
at liquibase.command.CommandScope.execute(CommandScope.java:186)
at liquibase.integration.commandline.CommandRunner.call(CommandRunner.java:55)
at liquibase.integration.commandline.CommandRunner.call(CommandRunner.java:24)
at picocli.CommandLine.executeUserObject(CommandLine.java:2041)
at picocli.CommandLine.access$1500(CommandLine.java:148)
at picocli.CommandLine$RunLast.executeUserObjectOfLastSubcommandWithSameParent(CommandLine.java:2461)
at picocli.CommandLine$RunLast.handle(CommandLine.java:2453)
at picocli.CommandLine$RunLast.handle(CommandLine.java:2415)
at picocli.CommandLine$AbstractParseResultHandler.execute(CommandLine.java:2273)
at picocli.CommandLine$RunLast.execute(CommandLine.java:2417)
at picocli.CommandLine.execute(CommandLine.java:2170)
at liquibase.integration.commandline.LiquibaseCommandLine.lambda$execute$1(LiquibaseCommandLine.java:352)
at liquibase.Scope.child(Scope.java:189)
at liquibase.Scope.child(Scope.java:165)
at liquibase.integration.commandline.LiquibaseCommandLine.execute(LiquibaseCommandLine.java:317)
at liquibase.integration.commandline.LiquibaseCommandLine.main(LiquibaseCommandLine.java:84)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at liquibase.integration.commandline.LiquibaseLauncher.main(LiquibaseLauncher.java:107)
Caused by: liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: Connection could not be created to jdbc:sqlserver://FinIQ668/SQL_2019;databaseName=DEV;encrypt=false;integratedSecurity=false with driver com.microsoft.sqlserver.jdbc.SQLServerDriver. The TCP/IP connection to the host FinIQ668/SQL_2019, port 1433 has failed. Error: “FinIQ668/SQL_2019. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.”.
at liquibase.integration.commandline.CommandLineUtils.createDatabaseObject(CommandLineUtils.java:140)
at liquibase.integration.commandline.Main.doMigration(Main.java:1482)
at liquibase.integration.commandline.Main$1.lambda$run$0(Main.java:396)
at liquibase.Scope.lambda$child$0(Scope.java:180)
at liquibase.Scope.child(Scope.java:189)
at liquibase.Scope.child(Scope.java:179)
at liquibase.Scope.child(Scope.java:158)
at liquibase.integration.commandline.Main$1.run(Main.java:395)
at liquibase.integration.commandline.Main$1.run(Main.java:217)
at liquibase.Scope.child(Scope.java:189)
at liquibase.Scope.child(Scope.java:165)
at liquibase.integration.commandline.Main.run(Main.java:217)
at liquibase.command.AbstractCliWrapperCommandStep.run(AbstractCliWrapperCommandStep.java:32)
at liquibase.command.CommandScope.execute(CommandScope.java:172)
… 20 more
Caused by: liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: Connection could not be created to jdbc:sqlserver://FinIQ668/SQL_2019;databaseName=DEV;encrypt=false;integratedSecurity=false with driver com.microsoft.sqlserver.jdbc.SQLServerDriver. The TCP/IP connection to the host FinIQ668/SQL_2019, port 1433 has failed. Error: “FinIQ668/SQL_2019. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.”.
at liquibase.database.DatabaseFactory.openConnection(DatabaseFactory.java:221)
at liquibase.database.DatabaseFactory.openConnection(DatabaseFactory.java:179)
at liquibase.database.DatabaseFactory.openDatabase(DatabaseFactory.java:144)
at liquibase.integration.commandline.CommandLineUtils.createDatabaseObject(CommandLineUtils.java:94)
… 33 more
Caused by: liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: Connection could not be created to jdbc:sqlserver://FinIQ668/SQL_2019;databaseName=DEV;encrypt=false;integratedSecurity=false with driver com.microsoft.sqlserver.jdbc.SQLServerDriver. The TCP/IP connection to the host FinIQ668/SQL_2019, port 1433 has failed. Error: “FinIQ668/SQL_2019. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.”.
at liquibase.database.ConnectionServiceFactory.create(ConnectionServiceFactory.java:35)
at liquibase.database.DatabaseFactory.openConnection(DatabaseFactory.java:218)
… 36 more
Caused by: liquibase.exception.DatabaseException: Connection could not be created to jdbc:sqlserver://FinIQ668/SQL_2019;databaseName=DEV;encrypt=false;integratedSecurity=false with driver com.microsoft.sqlserver.jdbc.SQLServerDriver. The TCP/IP connection to the host FinIQ668/SQL_2019, port 1433 has failed. Error: “FinIQ668/SQL_2019. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.”.
at liquibase.database.jvm.JdbcConnection.open(JdbcConnection.java:91)
at com.datical.liquibase.ext.database.jvm.ProJdbcConnection.open(Unknown Source)
at liquibase.database.ConnectionServiceFactory.create(ConnectionServiceFactory.java:32)
… 37 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host FinIQ668/SQL_2019, port 1433 has failed. Error: “FinIQ668/SQL_2019. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.”.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:237)
at com.microsoft.sqlserver.jdbc.SQLServerException.ConvertConnectExceptionToSQLServerException(SQLServerException.java:288)
at com.microsoft.sqlserver.jdbc.SocketFinder.findSocket(IOBuffer.java:2519)
at com.microsoft.sqlserver.jdbc.TDSChannel.open(IOBuffer.java:777)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:3300)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:2950)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:2790)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:1663)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1064)
at liquibase.database.jvm.JdbcConnection.open(JdbcConnection.java:83)
… 39 more
Hi,
my case is i am creating jenkins pipeline. In that with the help of choice parameter i am selecting database name, then i am creating url by concatenating and passing it to liquibase cli command and then tcpip error comes.
As per your guideline i have created properties file and set following parameters.
classpath=C:\Program Files\liquibase\internal\lib\mssql-jdbc.jar
driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
url=jdbc:sqlserver://finiq668\sql_2019;DatabaseName=DEV;integratedSecurity=false;encrypt=false
username=user1
password=user1pwd
If i execute cli cmd with url parameters cli shows error and if i execute without url parameter command executes successfully.
Even though with new 4.20 i am facing this issue.
$ liquibase --url=‘jdbc:sqlserver://FinIQ668\SQL_2019;databaseName=DEV;encrypt=false;integratedSecurity=false’ --changeLogFile=case2_changelog.sql status
####################################################
_ _ _ _
| | () () |
| | _ __ _ _ _ | |_ __ _ ___ ___
| | | |/ _ | | | | | '_ \ / _ / __|/ _ \
| || | (| | || | | |) | (| _ \ __/
_/|_, |_,||./ _,|/__|
| |
|_|
Free schema change activity reports at
####################################################
Starting Liquibase at 10:59:42 (version 4.20.0 #7837 built at 2023-03-07 16:25+0000)
Liquibase Version: 4.20.0
Liquibase Open Source 4.20.0 by Liquibase
Unexpected error running Liquibase: Connection could not be created to jdbc:sqlserver://FinIQ668/SQL_2019;databaseName=DEV;encrypt=false;integratedSecurity=false with driver com.microsoft.sqlserver.jdbc.SQLServerDriver. The TCP/IP connection to the host FinIQ668/SQL_2019, port 1433 has failed. Error: “FinIQ668/SQL_2019. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.”.
For more information, please use the --log-level flag
please guide.
hi all,
Was able to fix my issue by creating different lqiuibase properties file,
But still not able to pass url from cli. Some how able to fix it by above
route.
Now please close this issue.
thanks,
parikshit p
1 Like
