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

This widget could not be displayed.

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.

This widget could not be displayed.
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
Community showcase
Published Apr 22, 2018 in Jira Software

How-to setup a secured Jira Software 7.9.0 on Ubuntu 16.04.4 in less than 30 minutes

...PermissionsStartOnly=true User=www-data Group=www-data ExecStart=/opt/jira/bin/startup.sh ExecStop=/opt/jira/bin/shutdown.sh TimeoutStartSec=120 TimeoutStopSec=600 PrivateTmp=true [Install] WantedBy...

1,499 views 10 12
Read article

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