Search code examples
database-connectionteamcityteamcity-9.0

TeamCity 9.x Setting up an External Database with unnamed(NULL) MSSQL instance

I'm evaluating TeamCity 9.0.4 and using HSQLDB. Now trying to setup MS SQL Server 2014 as External Database.I don't have a named instance(NULL).

So I tried the following connection URL

connectionUrl=jdbc:sqlserver://<host>:1433;databaseName=<database name>
connectionProperties.user=<user>
connectionProperties.password=<password>

When I trying to load the build server I'm getting this message.

TeamCity is starting

Continuing attempts to connect to the database

TeamCity server is connecting to MSSQL database. The database server is not started yet, or the connection properties are not properly set.

And also I checked the log file, this is what I got.

[2015-05-20 14:08:34,513] INFO - jetbrains.buildServer.STARTUP - Current stage: Continuing attempts to connect to the database

SQLSERVER is up,I think there is a problem with connection URL. What can I do to solve this.

TeamCity 9.x Documentation Setting up an External Database

Solution

  • Thanks DevOps.

    My mistake, I was testing TeamCity locally. Problem was with the SQL Server Network Connection. TCP/IP was disabled for SQLEXPRESS

    Enable TCP/IP for SQLEXPRESS

    1. Open SQL Server Configuration Manager
    2. Go to Protocols for SQLEXPRESS under SQL Server Network Configuration.

    3. Right-click on TCP/IP and choose Properties. Set Enabled = YES.

    4. Better check this too, click on IP Addresses tab and find the section IP All. Set TCP Port to 1433.