Not able to connect MSSQL database server from the command line

1

I am unable to connect to the database server instance from the windows command command line to connect MSSQL remote server Database.

Command line command is :

liquibase --changelog-file=“liquibase\dbchangelog.xml” --driver=com.microsoft.sqlserver.jdbc.SQLServerDriver --url=jdbc:sqlserver://DBASTG001\DBASTG;databaseName=Positional_Data; --username=liquibase --password=liquibase update

I enabled inbound port also in the server UDP 1433, 1434

But I am getting below error:

Unexpected error running Liquibase: Connection could not be created to jdbc:sqlserver://DBASTG001\DBASTG;databaseName=Positional_Data; with driver com.microsoft.sqlserver.jdbc.SQLServerDriver. The connection to the host DBASTG001, named instance \dbastg failed. Error: “java.net.SocketTimeoutException: Receive timed out”. Verify the server and instance names and check that no firewall is blocking UDP traffic to port 1434. For SQL Server 2005 or later, verify that the SQL Server Browser Service is running on the host.

Apprecitate the help :-

2

Hey there @vijay413 ! Welcome to the Liquibase Community.

This error is usually caused by the quotes used in the command.
It could also be that the Java Version you’re using doesn’t match the supported Java versions in the driver you’re linking to.

The quoted section of the error is what I searched for to find these results. None came up when I searched the entire error, so you may need to trim off the specific-to-your-configuration parts to get better results when looking for a solution online.

If neither of these resolves this issue for you, please reply and include the versions of Java and Liquibase that you’re using.
Reference: