Skip to content

Instantly share code, notes, and snippets.

@ArturDorochowicz
Last active December 20, 2016 23:06
Show Gist options
  • Select an option

  • Save ArturDorochowicz/9923556 to your computer and use it in GitHub Desktop.

Select an option

Save ArturDorochowicz/9923556 to your computer and use it in GitHub Desktop.
Installing a TeamCity server on Windows.

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

  2. 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.

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

  4. Copy sqljdbc4.jar to <TeamCity Data Directory>/lib/jdbc

  5. 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.

  6. Set up \config\database.properties

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment