I'm having no luck getting TeamCity running on SQL Server 2005 Express. I followed the steps described in Setting up an External Database and the "Switch to Another Database" section of Migrating to an External Database. This is what my database.properties file looks like:
The SQL Server 2005 Express database is the default installation, the TeamCity database is using the SQL_Latin1_General_CI_AI collation, and the JDBC driver is jTDS 1.2.2. The user, teamcity, has login permissions to the database and I can log in with this user and run CREATE TABLE statements.
When I start the TeamCity service, it prompts me to accept the EULA and set up an Administrator password. However, when I log in and switch to the Administration menu the following message appears at the top of the page:
"The server currently uses the internal storage engine. For production purposes it is highly recommended to use a standalone database which provides better stability as the storage engine. Please refer to TeamCity online documentation for migration instructions."
This message appears no matter what combination of port or no port or connectionProperties.instance= or ;instance= provided.
Frustratingly, there is no indication that the software even tried to connect to the SQL Server 2005 Express database. There are no logging messages that I've found.
JetBrains claims that this configuration is supported, so what am I doing wrong?
Frustrated in Frankfort