How can I connect to MS SQL Server 2016 Using Windows Authentication

Question

I am running ReadyAPI 3.9.1 and am unable to configure a database connection when using Windows Authentication.

I am using the following:

com.microsoft.sqlserver.jdbc.SQLServerDriver

jdbc:sqlserver://serverName:1433;databaseName=myDB;user=xx\myusername;password=PASS_VALUE;integratedSecurity=true

Any suggestions?

nmrao · Answer

What is the error? Have you checked log files?

richie · Answer

Hey rvandenbosch,Are you using the .dll as well as the .jar file to connect?  Its been a while, but if i remember correctly you need both for windows auth for an sqlserver connection.TaRich

richie · Answer

Hey&nbsp;rvandenbosch&nbsp;
&nbsp;
Ok - I have a couple of points:
&nbsp;
Whenever I try and create a new DB connection in ReadyAPI!/SoapUI and I'm having problems.&nbsp; I stop working with ReadyAPI!/SoapUI and try setting up the connection in a DB interrogation tool like TOAD or DBVisualiser, etc., etc.&nbsp; Doing this means that you haven't got the extra layer of complication.&nbsp;
&nbsp;
Whatever works in the DB interrogation tool will work in ReadyAPI! (unless you've done something like copied the driver files to the wrong directory) - so I would suggest trying to configure your connection first in DBVisualiser - it simplifies things.
&nbsp;
Next, can you please publish the connection string/URL you're using to try and connect?
Next, can you confirm if you've tried with the JDBC driver instead of the JDTS driver?
Next, can you confirm the JRE you're running to enable the driver files to execute is the correct version for those drivers?
&nbsp;
Next, this sounds a bit of a stupid one, but it's easier than you think to make a mistake on this one, can you confirm you're Java bit type (either x86 or 32bit) matches your ReadyAPI! instance please?
&nbsp;
Cheers,
&nbsp;
Rich

rvandenbosch · Answer

I am getting:Failed to get a connection for the specified properties; com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication. ClientConnectionId:cde375f3-e2a0-485f-b2b2-424a45485f52

rvandenbosch · Answer

I changed the end of the connection string to Trusted_Connection=Yes. I now get 'Failed to get a connection for the specified properties; com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'xxx\xxxxx'. ClientConnectionId:31d9dcf4-5be7-4bbc-98a6-2d2d3006eb1d

I checked with our DBA and he is seeing no connection attempts with that user.

Forum Discussion

How can I connect to MS SQL Server 2016 Using Windows Authentication

Related Content

Git Authentication - no 'Connect' button

JDBC connectivity issue - No matching authentication protocol

Kafka topic using OAuth2 authentication

javax.net.ssl.SSLException: Connection reset error

Connection reset

Recent Discussions

Starting LoadUI Agents in ReadyAPI?

Reporting on call-to-testcase

Get Data Dialog - generated xpath not working

Differences with GIT check-ins for Windows and iOS ARM users

Cannot pass the test result to another script