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