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.
-
Create a new database. Using case sensitive collation (collation name ending with '_CS_AS') is recommended and and is mandatory for the certain functionality (like using non-Windows build agents).
-
Create TeamCity user and ensure that this user is the owner of the database (grant the user dbo rights). This requirement is necessary because the user needs to have ability to modify the database schema.
-
Download and unpack http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774
-
Copy
sqljdbc4.jarto<TeamCity Data Directory>/lib/jdbc -
For integrated security support copy
auth/x86/sqljdbc_auth.dll(since TeamCity runs as a 32-bit process) to location in PATH, e.g.C:\Windows\. Note:C:\Windows\System32\in a 64-bit Explorer contains 64-bit libraries and it's not what 32-bit process like TeamCity sees. -
Set up \config\database.properties
connectionUrl=jdbc:sqlserver://localhost\sqlexpress;databaseName=TeamCity;integratedSecurity=true