ArturDorochowicz/installing-teamcity-on-windows.md

Last active December 20, 2016 23:06

Star (1) You must be signed in to star a gist
Fork (1) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/ArturDorochowicz/9923556.js"></script>
Save ArturDorochowicz/9923556 to your computer and use it in GitHub Desktop.

Download ZIP

Installing a TeamCity server on Windows.

Raw

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

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 dbo rights).
Download and unpack the driver

http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774
Copy sqljdbc4.jar to <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 <TeamCity Data Directory>\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