Forum Discussion

rvandenbosch's avatar
rvandenbosch
Occasional Contributor
4 years ago

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

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:sqlse...
rvandenbosch's avatar
rvandenbosch
Occasional Contributor
4 years ago

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.

richie's avatar
richie
Community Hero
4 years ago
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.

Ta

Rich