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

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

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.

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 dbo rights).

3. Download, unpack the driver, copy libraries

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

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

   Use x86 sqljdbc_auth.dll for integrated security (since TeamCity runs as a 32-bit process). Copy to location in PATH. Note: C:\Windows\System32\ in a 64-bit Explorer contains 64-bit libraries and it's not what 32-bit process like TeamCity sees.

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

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