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. Use case sensitive collation (collation name ending with '_CS_AS').
-
Create TeamCity user and ensure that this user is the owner of the database (grant the user db_owner rights).
-
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 inPATH
.copy sqljdbc_4.0\enu\sqljdbc4.jar <TeamCity Data Directory>\lib\jdbc copy sqljdbc_4.0\enu\auth\x86\sqljdbc_auth.dll %SystemRoot%
-
Set up
<TeamCity Data Directory>\config\database.properties
connectionUrl=jdbc:sqlserver://localhost\\sqlexpress;databaseName=TeamCity;integratedSecurity=true