It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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
Posted in Jira Core

How to manage many similar workflows?

I have multiple projects that use variations of the same base workflow. The variations depend on the requirements of the project or issue type. The variations mostly come in the form of new statuses ...

3,709 views 11 5
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you