JIRA connectivity with SQL 2008 R2

We are trying to migrate from to an SQL2008R2 database.

I have created the DB, User and Schema however the config utility fails with 'unable to connect'.

The driver is in place and I have followed all the other steps multiple times without success...

Also tested windows odbc connection to BD from app server and it worked....

Please help ;-)

2 answers

0 vote

What does the application logs say? They'll have more detail about the specific error.

Do you have another tool that tries to connect using a jdbc connection? What connection strings are you using?

Hi Nic,

Not really sure what to look for in the logs. Tried searching for both SQL & JTDS but neither were mentioned.

At present we are not using any other jdbc connections... ODBC is connecting correctly however.

You really do need to read the logs - they will have connection errors in them.

ODBC is not JDBC - you may well have the right settings for ODBC, but that doesn't matter - you need to get the right settings for JDBC and test with those.

0 vote
Joe Wai Tye Atlassian Team Mar 14, 2013

Hi Simon,

Have you checked out the documentation for this process here? Please check it out, especially the parts about TCP/IP as well as the ports.



Hi Joe,

That is the documentation I was using. Our SQL box is fairly vanilla and ports are default.

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,183 views 13 19
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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot