Setting up jira service desk 3.9.1 and it uses jira 7.6.1
The problem is that we need to authenticate with "Windows-based" (Active Directory) authentication with SQL Server".
Cant get it to work, this is my string im editing in dbconfig.xml>>
I have made different variations of the string but cant get it to log in, if I create a sql user it works without problem.
Links I have read
There is a problem with that documentation. It was originally created for older versions of Jira and since that time Jira changed the database driver it is using in 7.5 and higher versions. Previous to these Jira was using the opensource jtds driver, where you could use that 'useNTLMv2' parameter as a means to do this.
However since Jira changed to use the Microsoft driver, you can't use that syntax to do this. Instead I would recommend checking out Using Integrated Security with MsSQL for Jira. There are a number of other steps that have to happen to make this work in these more recent versions of Jira.
Even the Microsoft documentation on Building the Connection URL helps to explain how that driver is expecting the syntax of a jdbc url string to be.
Both the MS documentation and our own KB above mention that you need to also use the sqljdbc_auth.dll file in order to make sure that the application (Jira) can authenticate in this fashion.
The other major difference between these drivers is that the Microsoft one only support Windows environments if I recall correctly, whereas the jtds would work on linux environments.
I hope this helps, I will also look to update that KB to indicate this version difference.
Well, it still might work with these newer versions of Jira, but you would have to manually install the jTDS driver by copying that .jar file into the $JIRAINSTALL/lib/ folder and then update the dbconfig.xml to tell Jira to use that database driver instead of the MS one.
You can do that by changing the driver-class parameter of
After you install this .jar file, and make this change to the dbconfig.xml, both changes require you to restart Jira before they become effective.
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG