Jira 7.6.2 SQL DB Login failure Edited

Jira 7.6.2
Microsoft SQL Server 2016

I upgraded Jira server from 7.4.2 to 7.6.2 and now I cannot connect to the associated SQL database. I have reviewed the changes for the jdbc connection string and have made the changes accordingly with no luck.

This instance of Jira has been running with no issues for months, no changes to the DB server prior to the upgrade, tested and verified the AD account used to log in has full access to the DB. 

Original connection:

<url>jdbc:jtds:sqlserver://[myserver]:1433/Jira;domain=[mydomain]:1433/Jira</url>
<driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>

Change to:

<url>jdbc:sqlserver://[myserver]:1433;databaseName=Jira</url>
<driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>

No changes were made to the existing account info for username and password, however I get the error:
Attempting to connect to the SQL Server database server...
Could not connect to the DB: Login failed for user 'jira'. ClientConnectionId:7ca565fe-4ed7-4350-9d4b-529583eef8b1

Any ideas on what I can try to resolve this?

2 answers

1 accepted

The answer to this issue is that 7.6.2 does not allow for a domain account to be used to connect to MS SQL Server, at least not as far as I can gather from any documentation I was able to find. This is unfortunate as version 7.4.2 did allow for a domain account to be used, making this a breaking change which seems to gravitate backwards in terms of functionality provided by Atlassian. 

You must instead use a local SQL account only to access the DB.

0 vote
Daniel Eads Community Champion Dec 22, 2017

Hi Tony,

Are you able to copy/paste the password from the password tag in dbconfig.xml (same file) into a SQL client (preferably something Java-based if you can like DataGrip) and see if you can connect with the same connection parameters there?

I don't use MS SQL for Atlassian tools but have found generally confirming the password is still working as expected in another client is a good place to start before digging in further.

Cheers,
Daniel

Hi Daniel, 

I downloaded DataGrip and setup a SQL Server (jTds) connection. On the first try it had the same error as in Jira, but I added a value for DOMAIN in the advanced tab for the Data Sources and Drivers and the connection began to work fine. 

I am thinking it's something simple like getting the connection string format to take the domain, or maybe I need to provide a fully qualified name? Not sure..

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Sarah Schuster
Posted Mar 28, 2018 in Jira Software

Can a company’s culture make or break agile adoption?

Can a new-to-agile team survive and thrive in a non-agile culture? If so, what advice would you give to those trying to be agile in a non-agile culture? What's the key(s) to success? Share your thoug...

12,750 views 15 13
Join discussion

Atlassian User Groups

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!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you