JIRA connectivity with SQL 2008 R2

[Simon Genet]

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 ;-)

[Theinvisibleman]

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

[Simon Genet]

Hi Joe,

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

[Nic Brough -Adaptavist-]

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?

[Simon Genet]

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.

[Nic Brough -Adaptavist-]

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.