Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,360,197
Community Members
 
Community Events
168
Community Groups

JIRA 8.11.0 Error = Database: JIRA couldn't connect to your database.

Hi,

We have received the following error(below) during 8.11.0 setup. The JIRA configurator tool did not successfully connect us to the MS SQL Server 2016. The schema has been created and domain service account setup for the authentication. The MS SQL DB has been setup for SSL where the dbconfig.xml file has been specified with connection string encrypt=true;trustServerCertificate=true.

From our DBA, the problem is due to how we configure the login. We followed the connection string settings for the dbconfig.xml. The firewall between the JIRA server to the db server has been cleared and verified with telnet.

 

MS SQL Server Error = attempt to login using sql authentication failed

JIRA Error = Database: JIRA couldn't connect to your database.

 

image002 (1).jpg

1 answer

Whenever I have problem connecting to a database from an Atlassian application like Jira, I use DBeaver to figure out the connectivity problem. 

DBeaver is written in Java and uses a similar connection string methodology as Jira/Confluence/etc. If it works there, it will work on Jira. DBeaver is a desktop GUI and is more interactive than Jira so it is easier to debug these problem. It also has a wizard to guide you through your first connection that then you can apply the result be to Jira:

https://dbeaver.com/

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira

Online AMA this week: Your project management questions answered by Jira Design Lead James Rotanson

We know that great teams require amazing project management chops. It's no surprise that great teams who use Jira have strong project managers, effective workflows, and secrets that bring planning ...

189 views 1 6
Read article

Atlassian Community Events