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.

Cheers,

Joe

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
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Jun 14, 2018 in Jira Service Desk

How the Telegram Integration for Jira helps Sergey's team take their support efficiency to the bank

...+ reading Fantasy). The same is true for him at the bank he works for: Efficiency is key when time literally equals money. Read on to learn how Sergey makes most of the time he has by...

522 views 3 5
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