Forum Discussion

ashishg's avatar
ashishg
Member
6 years ago

Getting connection failed on trying to connect to Azure based MS SQL database using SoapUI JDBC step

I am getting connection failed on trying to connect to Azure based MS SQL database using SoapUI JDBC step.

Following is the connection string I am using:

jdbc:sqlserver://SERVER name/DB name?user=USERNAME&password=PWD

 

Following is the error I am getting:

Can't get the Connection for specified properties; com.microsoft.sqlserver.jdbc.SQLServerException:
The TCP/IP connection to the host SERVER name/DB name?user=USERNAME&password=PWD,
port 1433 has failed. Error: "SERVER name/DB name?user=USERNAME&password=PWD.
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.".

 

Please help me understand what is going wrong here

No RepliesBe the first to reply