NishantJadhav
9 years agoOccasional Contributor
Getting Error at JDBC Request : Can't get the Connection for specified properties
[ Spoiler ]
- 9 years ago
Got the answer.
If you are using sqljdbc4.jar remove sqljdbc.jar from \<sopaui>\ext folder.
Check if port specified is open with Microsoft SQL Server Configuration manager, if not open it and restart the server.
You can also remove the port number instead of opening it.
To remove port from connection string goto Project > JDBC Connections > Double click the connection string and remove the port number.
Done
Worked for me:
New conn. string :
jdbc:sqlserver://SDCQA*****\*****databaseName=****;user=user;password=PASS_VALUE
:) :D