Forum Discussion

NishantJadhav's avatar
NishantJadhav
Occasional Contributor
9 years ago
Solved

Getting Error at JDBC Request : Can't get the Connection for specified properties

  [ Spoiler ]  
  • NishantJadhav's avatar
    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