Ask a Question

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

MegNa_12_56
New Contributor

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 configured for integrated authentication.

 

I have copied both sqljdbc42.jar and mssql-jdbc_auth-9.4.0.x64.dll on both 

 

C:\Program Files\SmartBear\ReadyAPI-3.10.0\bin\ext

C:\Program Files\SmartBear\ReadyAPI-3.10.0\bin

 

and here is the configuration 

 

com.microsoft.sqlserver.jdbc.SQLServerDriver

jdbc:sqlserver://Server;databaseName=Test;integratedSecurity=true;user=username;password=PASS_VALUE

3 REPLIES 3
richie
Community Hero

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

Hey @MegNa_12_56 

 

I always find connecting SQLServer fiddly myself - especially windows auth or mixed mode

 

have you confirmed the following?

 

correct version of jdbc drivers for the version of SQLServer you are trying to connect to?

correct version of Java to support the version of jdbc drivers you are using?

are you using x86 (32bit) or 64bit - you need to ensure you have the correct version of Java installed (so if processor architecture is 64bit, then you need 64bit Java)

 

Cheers,

 

Rich

if this helped answer the post, could you please mark it as 'solved'? Also if you consider whether the title of your post is relevant? Perhaps if the post is solved, it might make sense to update the Subject header field of the post to something more descriptive? This will help people when searching for problems. Ta
thePantz
Contributor

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

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
New Contributor

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

 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

cancel
Showing results for 
Search instead for 
Did you mean: