Attempting to Connect to SQL Server Database through Scriptrunner Data Field using Active Directory

[Thomas DeVoe]

We are running Jira Data Center on prem (version 8.19). We have a Scriptrunner Database Picker custom field. During development, we used a SQL Server ID but would like to change the Resource to use an Active Directory account. We've referred to a # of articles and tried different JDBC drivers but have not been successful connecting to the database. 

Is it required that we use Kerberos to connect?  If Kerberos is not required, can someone provide a recommended driver and sample connection string? If Kerberos is necessary, please provide helpful links.

Thanks.
Tom

[Thomas DeVoe · Accepted solution]

In the ScriptRunner Resource, we were able to get this working by using the com.microsoft.sqlserver.jdbc.SQLServerDriver driver together with the following connection string:

jdbc:sqlserver://SQLServerName;authenticationScheme=NTLM;integratedSecurity=true;domain=DomainName;

Then specify your AD userid as the username and your AD password as the password.

Hopefully this helps someone else in the future.