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 votes

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 votes
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 Sign up to answer
Community showcase
Published Feb 13, 2019 in Jira

Make your Atlassian Cloud products more secure: our NEW admin security guide

Hey admins! I’m Dave, Principal Product Manager here at Atlassian working on our cloud platform and security products. Cloud security is a moving target. As you adopt more products, employees consta...

697 views 0 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