JDBC driver for MS SQL

I'm following the steps found in the documentation with regards to setting up an MS SQL database (SQL Express 2008 R2) to work with TeamCity. This has been successful before now.

The AMI (I'm hosting in AWS) has been taken from a working instance which is on v8.0.4.

Upon making all the neccessary changes and applying what appears to be the correct driver, I'm getting the error that starts 'No suitable JDBC driver found for databse type: MS SQL'. I'm using the same driver as on a test instance which this worked on (MS provided one) and I've also tested v1.2.8 of the jTDS driver available on Sourceforge.

Can anyone advise where I should look to troubleshoot, and fix, this?

Comment actions Permalink

Have a potential solution to get into TeamCity.

jTDS 1.2.5, maintainDB command when migrating away from the HSQLDB and that allowed me to get to the log in screen. Server didn't enjoy that, so currently restarting it to make sure I can still get in...

Comment actions Permalink

make sure you have uipdated database.properties file. The syntax differs depend on used driver.


Please sign in to leave a comment.