ad integrate with sql

[Leo Fraterman]

Hello all,

When i use the manual as posted below i can not get ad integration running. When i try the setup.bat tool i get the message the user doesnt have access.

When i look on the sql server i get the message "An attempt to login using sql authentication failed. Server is configured for windows authentication only. i have the  integratedsecurity=true in my dbconfig.

When i look at the atlassian-jira.log i get the message:

could not succesfully test your database: com.microsoft.sqlserver.jdbc.sqlserverexception: this driver is not configured for integrated authentication

https://confluence.atlassian.com/jirakb/use-integrated-authentication-with-sql-server-in-jira-server-939494383.html

anyone able to help me or point me the right direction?

[Leo Fraterman · Accepted solution]

after downgrading to an older version of the sql jdbc driver it is working

[Alex Skobelev]

could you please elaborate on how you downgraded the driver and to which specifically?

Thanks!