Installing a TeamCity server on Windows.

installing-teamcity-on-windows.md

Installing TeamCity on Windows

http://confluence.jetbrains.com/display/TCD8/Installing+and+Configuring+the+TeamCity+Server

Create a user for the service

net user tcservice * /add /expires:never /passwordchg:no

User permissions

http://support.microsoft.com/kb/315276

ntrights -u tcservice +r SeServiceLogonRight
ntrights -u tcservice +r SeDenyInteractiveLogonRight

Add write permission to TeamCity Data Directory.

Add write permission to TeamCity installation directory.

Configure MS SQL Server database

http://confluence.jetbrains.com/display/TCD8/Setting+up+an+External+Database#SettingupanExternalDatabase-MicrosoftSQLServer

1. Create a new database. Use case sensitive collation (collation name ending with '_CS_AS').

2. Create TeamCity user and ensure that this user is the owner of the database (grant the user db_owner rights).

3. Set up JDBC driver

   http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774

   Use x86 sqljdbc_auth.dll for integrated security (since TeamCity runs as a 32-bit process), this needs to be in PATH.

    copy sqljdbc_4.0\enu\sqljdbc4.jar <TeamCity Data Directory>\lib\jdbc
    copy sqljdbc_4.0\enu\auth\x86\sqljdbc_auth.dll %SystemRoot%
   

4. Set up <TeamCity Data Directory>\config\database.properties

    connectionUrl=jdbc:sqlserver://localhost\\sqlexpress;databaseName=TeamCity;integratedSecurity=true