Changing the DB user from a local sql account to an AD account

[Micke S.]

Hi,

Because we dont want to use local sql accounts in our environment i would like to see if anyone can help me find out why i cant get an AD user to be the DB user instead of a local sql account. I have double and triple checked, the accounts in SQL looks exactly the same.

But when i run the Jira Config till (config.bat) and specify the AD user i get:

Attempting to connect to the SQL Server database server...
"Could not connect to the DB: Login failed for user 'SVC-JIRA_DBuser_Prod'"

I am running Jira Core 7.4.2 on Windows Sever 2016 with Java 1.8 and SQL Server 2014.

Anyone..

[somethingblue · Accepted solution]

Hi Micke,

In general, this user should be a SQL user and not a Windows user nor an Active Directory ID, however, there is a Suggestion to incorporate this into JIRA that you can find at JRASERVER-42220.   Please vote on it and add your use case to the notes to add impact.

One of the commenters in JRASERVER-42220 posted a workaround that worked for them:

Example URL: <url>jdbc:jtds:sqlserver://serverName:port/databaseName;Instance=instanceName;useNTLMv2=True;Domain=domainName</url>

Try this workaround to see if it works for you as well.

Cheers,

Branden

[Micke S.]

Thanks, see now that its not supported. I voted for this