Forum Discussion

MegNa_12_56's avatar
MegNa_12_56
New Contributor
4 years ago

Not able to connect to the sql server database through JDBC request, getting error while connecting

Not able to connect to the sql server database through JDBC request, getting error while connecting   getting below error    com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not co...
thePantz's avatar
thePantz
Contributor
4 years ago

I had a similar issue.

They are referring to the wrong version of the .dll in the docs. At least for my needs. I did the following:

1. Download mssql-jdbc_auth-9.2.1 (note the version)

2. Place this .dll in ReadyAPI's bin directory

 

If you have ReadyAPI open while doing this the changes will not take affect until the next time you launch the application

Your connection string should look something like this: 

jdbc:sqlserver://<HOST>:<PORT>;databaseName=<DB>;integratedSecurity=true

 

  • MegNa_12_56's avatar
    MegNa_12_56
    New Contributor
    4 years ago

     I tried as you said I have downloaded mssql-jdbc_auth-9.2.1 and placed in both bin folder and \bin\ext folder and closed the ready api and relaunched 

    still getting the same error 

     

    My Java version is  "1.8.0_301"

     

    com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication. ClientConnectionId:4a709517-eff9-44e6-a76e-d187460b45aa