Forum Discussion
Hi Julio,
Thanks for your reply.
However my server name is = "(localdb)\mssqllocaldb" and as its Microsoft sql server 2014 local db its not running on any port. Please correct me if I'm wrong. Right now I'm not able to find out my local db port number on which it is running so, I taken another way which is of instance name.
Could you please give me clear idea how I can create my connection string using my server name , instance name and windows authentication?
I tried with the port number 1433 and even with other port numbers it giving me below exception -
Can't get the Connection for specified properties; com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host mssqllocaldb, port 1434 has failed. Error: "null. 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.".
I checked the TCP/IP connection all the things are working fine however still I'm not able to connect to my database.
Can you find the port number that your instance is running from one of the following?
http://stackoverflow.com/questions/12297475/how-to-find-sql-server-running-port
then configure your server in SoapUI to use the IP address and port.
Related Content
- 12 years ago
- 10 years ago
Recent Discussions
- 15 years ago