How do I configure Teamcity to work with SQL Server 2005 Express?
Is it possible?
I followed instructions from here ( http://www.jetbrains.net/confluence/display/TCD4/Setting+up+an+External+Database#SettingupanExternalDatabase-MicrosoftSQLServer2005 ) but I keep getting 404 error when trying to access Teamcity ...
I used the following syntax to set up jTDS: connectionUrl = jdbc: jtds: sqlserver: // [host] \ sqlexpress: 1433 / [database name]
a source to share
I got it working.
I found a link that points me to this Microsoft JDBC Driver.
I 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.
a source to share
I found that reading the JetBrains documentation and cross-referencing with this blog post worked for me:
http://www.tellingmachine.com/post/Migrating-TeamCity-database-to-Microsoft-SQL-Server-2008-R2.aspx
I had to clear all JAVA * environment variables on the command line which I used to run the DDD support tool before it crashed, otherwise it picked up the wrong JRE version or something like that and moaned that it didn't have a JVM config file - I don't know, Java completely puzzles me.
Also, I had to redesign my SQL database using case sensitive (CS) mapping documented by JetBrains as we are a cross-platform team.
And TCP / IP requires enabling and a static set of ports.
a source to share
A couple of problems with this url. Backslash first, after slashes. It shouldn't be.
Also, make sure you can ping sqlexpress from the TeamCity server. Finally, make sure your SQLExpress is configured to listen on port 1433 - this is not the default. In fact, TCPIP connections are generally disabled by default.
a source to share