Skip to content

Instantly share code, notes, and snippets.

@ArturDorochowicz

ArturDorochowicz/installing-teamcity-on-windows.md

Last active December 20, 2016 23:06
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save ArturDorochowicz/9923556 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save ArturDorochowicz/9923556 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. ArturDorochowicz revised this gist Apr 2, 2014. 1 changed file with 3 additions and 3 deletions.
    6 changes: 3 additions & 3 deletions installing-teamcity-on-windows.md
    View file
    Original file line number Diff line number Diff line change
    @@ -27,8 +27,8 @@ http://confluence.jetbrains.com/display/TCD8/Setting+up+an+External+Database#Set


    1. Create a new database. Use case sensitive collation (collation name ending with '_CS_AS').
    1. Create TeamCity user and ensure that this user is the owner of the database (grant the user db_owner rights).
    1. Set up JDBC driver
    2. Create TeamCity user and ensure that this user is the owner of the database (grant the user db_owner rights).
    3. Set up JDBC driver

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

    @@ -37,7 +37,7 @@ http://confluence.jetbrains.com/display/TCD8/Setting+up+an+External+Database#Set
    copy sqljdbc_4.0\enu\sqljdbc4.jar <TeamCity Data Directory>\lib\jdbc
    copy sqljdbc_4.0\enu\auth\x86\sqljdbc_auth.dll %SystemRoot%

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

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

  2. ArturDorochowicz revised this gist Apr 2, 2014. 1 changed file with 3 additions and 3 deletions.
    6 changes: 3 additions & 3 deletions installing-teamcity-on-windows.md
    View file
    Original file line number Diff line number Diff line change
    @@ -27,8 +27,8 @@ http://confluence.jetbrains.com/display/TCD8/Setting+up+an+External+Database#Set


    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 db_owner rights).
    3. Set up JDBC driver
    1. Create TeamCity user and ensure that this user is the owner of the database (grant the user db_owner rights).
    1. Set up JDBC driver

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

    @@ -37,7 +37,7 @@ http://confluence.jetbrains.com/display/TCD8/Setting+up+an+External+Database#Set
    copy sqljdbc_4.0\enu\sqljdbc4.jar <TeamCity Data Directory>\lib\jdbc
    copy sqljdbc_4.0\enu\auth\x86\sqljdbc_auth.dll %SystemRoot%

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

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

  3. ArturDorochowicz revised this gist Apr 2, 2014. 1 changed file with 3 additions and 4 deletions.
    7 changes: 3 additions & 4 deletions installing-teamcity-on-windows.md
    View file
    Original file line number Diff line number Diff line change
    @@ -27,18 +27,17 @@ http://confluence.jetbrains.com/display/TCD8/Setting+up+an+External+Database#Set


    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).
    2. Create TeamCity user and ensure that this user is the owner of the database (grant the user db_owner rights).
    3. Set up JDBC driver

    http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774
    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 in ```PATH```.
    Use x86 ```sqljdbc_auth.dll``` for integrated security (since TeamCity runs as a 32-bit process), this needs to be in ```PATH```.

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

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


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

  4. ArturDorochowicz revised this gist Apr 2, 2014. 1 changed file with 2 additions and 1 deletion.
    3 changes: 2 additions & 1 deletion installing-teamcity-on-windows.md
    View file
    Original file line number Diff line number Diff line change
    @@ -31,11 +31,12 @@ http://confluence.jetbrains.com/display/TCD8/Setting+up+an+External+Database#Set
    3. 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 in ```PATH```.

    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), this needs to be in ```PATH```.
    4. Set up ```<TeamCity Data Directory>\config\database.properties```


  5. ArturDorochowicz revised this gist Apr 2, 2014. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion installing-teamcity-on-windows.md
    View file
    Original file line number Diff line number Diff line change
    @@ -39,5 +39,5 @@ http://confluence.jetbrains.com/display/TCD8/Setting+up+an+External+Database#Set
    4. Set up ```<TeamCity Data Directory>\config\database.properties```


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

  6. ArturDorochowicz revised this gist Apr 2, 2014. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion installing-teamcity-on-windows.md
    View file
    Original file line number Diff line number Diff line change
    @@ -39,5 +39,5 @@ http://confluence.jetbrains.com/display/TCD8/Setting+up+an+External+Database#Set
    4. Set up ```<TeamCity Data Directory>\config\database.properties```


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

  7. ArturDorochowicz revised this gist Apr 2, 2014. 1 changed file with 3 additions and 3 deletions.
    6 changes: 3 additions & 3 deletions installing-teamcity-on-windows.md
    View file
    Original file line number Diff line number Diff line change
    @@ -32,12 +32,12 @@ http://confluence.jetbrains.com/display/TCD8/Setting+up+an+External+Database#Set

    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%
    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), this needs to be in ```PATH```.
    4. Set up ```<TeamCity Data Directory>\config\database.properties```


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

  8. ArturDorochowicz revised this gist Apr 2, 2014. 1 changed file with 3 additions and 3 deletions.
    6 changes: 3 additions & 3 deletions installing-teamcity-on-windows.md
    View file
    Original file line number Diff line number Diff line change
    @@ -32,12 +32,12 @@ http://confluence.jetbrains.com/display/TCD8/Setting+up+an+External+Database#Set

    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%
    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), this needs to be in ```PATH```.
    4. Set up ```<TeamCity Data Directory>\config\database.properties```


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

  9. ArturDorochowicz revised this gist Apr 2, 2014. 1 changed file with 4 additions and 4 deletions.
    8 changes: 4 additions & 4 deletions installing-teamcity-on-windows.md
    View file
    Original file line number Diff line number Diff line change
    @@ -32,12 +32,12 @@ http://confluence.jetbrains.com/display/TCD8/Setting+up+an+External+Database#Set

    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%
    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), this needs to be in PATH.
    Use x86 ```sqljdbc_auth.dll``` for integrated security (since TeamCity runs as a 32-bit process), this needs to be in ```PATH```.
    4. Set up ```<TeamCity Data Directory>\config\database.properties```


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

  10. ArturDorochowicz revised this gist Apr 2, 2014. 1 changed file with 5 additions and 5 deletions.
    10 changes: 5 additions & 5 deletions installing-teamcity-on-windows.md
    View file
    Original file line number Diff line number Diff line change
    @@ -28,16 +28,16 @@ http://confluence.jetbrains.com/display/TCD8/Setting+up+an+External+Database#Set

    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
    3. Set up JDBC driver

    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%
    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.
    Use x86 ```sqljdbc_auth.dll``` for integrated security (since TeamCity runs as a 32-bit process), this needs to be in PATH.
    4. Set up ```<TeamCity Data Directory>\config\database.properties```


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

  11. ArturDorochowicz revised this gist Apr 2, 2014. 1 changed file with 6 additions and 4 deletions.
    10 changes: 6 additions & 4 deletions installing-teamcity-on-windows.md
    View file
    Original file line number Diff line number Diff line change
    @@ -28,13 +28,15 @@ http://confluence.jetbrains.com/display/TCD8/Setting+up+an+External+Database#Set

    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 and unpack the driver
    3. Download, unpack the driver, copy libraries

    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 ```<TeamCity Data Directory>\config\database.properties```
    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
  12. ArturDorochowicz revised this gist Apr 1, 2014. 1 changed file with 2 additions and 0 deletions.
    2 changes: 2 additions & 0 deletions installing-teamcity-on-windows.md
    View file
    Original file line number Diff line number Diff line change
    @@ -29,7 +29,9 @@ http://confluence.jetbrains.com/display/TCD8/Setting+up+an+External+Database#Set
    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 and unpack the driver

    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 ```<TeamCity Data Directory>\config\database.properties```
  13. ArturDorochowicz revised this gist Apr 1, 2014. 1 changed file with 5 additions and 7 deletions.
    12 changes: 5 additions & 7 deletions installing-teamcity-on-windows.md
    View file
    Original file line number Diff line number Diff line change
    @@ -26,15 +26,13 @@ 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

    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 and unpack the driver
    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 <TeamCity Data Directory>\config\database.properties
    6. Set up ```<TeamCity Data Directory>\config\database.properties```


    connectionUrl=jdbc:sqlserver://localhost\\sqlexpress;databaseName=TeamCity;integratedSecurity=true
  14. ArturDorochowicz revised this gist Apr 1, 2014. 1 changed file with 17 additions and 0 deletions.
    17 changes: 17 additions & 0 deletions installing-teamcity-on-windows.md
    View file
    Original file line number Diff line number Diff line change
    @@ -22,3 +22,20 @@ 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 <TeamCity Data Directory>\config\database.properties


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

  15. ArturDorochowicz created this gist Apr 1, 2014.
    24 changes: 24 additions & 0 deletions installing-teamcity-on-windows.md
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,24 @@
    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
    --------------------------------