JIRA connectivity with SQL 2008 R2

Question

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

Nic Brough -Adaptavist- · Answer

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.

Simon Genet · Answer

Hi Joe,

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

Simon Genet · Answer

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.