How do I setup Teamcity to work with SQL Server 2005 Express?

Question

Is this possible?

I've followed the instructions from here (http://www.jetbrains.net/confluence/display/TCD4/Setting+up+an+External+Database#SettingupanExternalDatabase-MicrosoftSQLServer2005) but I keep getting an 404 Error when trying to access Teamcity.

I've used the following syntax to configure jTDS: connectionUrl=jdbc:jtds:sqlserver://[host]\sqlexpress:1433/[database name]

Answer 1

A couple of problems with that URL. First is the backslash after the forward slashes. That should not be there.

Also, make sure you can ping sqlexpress from the TeamCity server. And finally, make sure that your SQLExpress is configured to listen on port 1433 - it isn't by default. In fact, TCPIP connections in general are disabled by default.

Answer 2

I've made it work.

I've found this link which point me to this JDBC driver from Microsoft.

I've put the following entries in the database.properties file:

driverName=com.microsoft.sqlserver.jdbc.SQLServerDriver connectionUrl=jdbc:sqlserver://localhost:1433;database=TeamCity; connectionProperties.user=teamcityuser connectionProperties.password=password

I haven't mentioned the SQL instance name (SQLEXPRESS) anywhere.