Forum Discussion

rvandenbosch's avatar
rvandenbosch
Occasional Contributor
3 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:sqlserver://serverName:1433;databaseName=myDB;user=xx\myusername;password=PASS_VALUE;integratedSecurity=true

 

Any suggestions?

7 Replies

Sort By
  • nmrao's avatar
    nmrao
    Champion Level 3
    3 years ago
    What is the error? Have you checked log files?
    • rvandenbosch's avatar
      rvandenbosch
      Occasional Contributor
      3 years ago

      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's avatar
      rvandenbosch
      Occasional Contributor
      3 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
        3 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