You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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.
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:
Then specify your AD userid as the username and your AD password as the password.
Hopefully this helps someone else in the future.