- Connect to your database server, right-click the Databases node in the Object Explorer and select New database.
- On the General page, specify the database name, ‘TeamCity’ in the image below and allocate sufficient transaction log space. The recommended minimum is 1Gb (1024 Mb) in the image below. The requirements vary depending on how intensively the server will be used.
- Next we need to specify primary collation: Go to the Option node in the left pane and select a collation on the right. We recommend a case-sensitive collation (with the collation name ending with '_CS_AS') corresponding to your locale and click Ok to save the settings:
Image RemovedImage Added
- Now make sure that the "no count" setting is disabled as follows: Right-click the server instance in Object Explorer, Choose Properties, Select the Connections tab. In the Default Connection Options frame, "no count" must be unchecked. Save changes if any.
- SQL Authentication requires specifying username and a password in the database settings. It is recommended to start with this authentication before you try to use Windows authentication.
- Windows authentication (MS SQL integrated security) allows the TeamCity server running under a specific Windows user connect to the SQL server as that user, without providing a username and a password. However, it requires additional setup
Create dedicated user for TeamCity with SQL server authentication
- Start the TeamCity server.
For Windows authentication (MS SQL integrated security), make sure the server is running under the user configured at this step.
- Select MS SQL as the database.
- Click the Refresh the JDBC drivers if asked.
- Specify the connection settings:
- Database host - your SQL server host
- Port - optional,
- Database instance name - leave blank for the default SQL server instance. If a named instance is used, provide its name here.
- Database name - the name of the newly created database
- Select the required authentication type, for SQL Server authentication provide the credentials of the dedicated SQL user configured at this step.
- Continue with the setup. It’ll take some time to initialize the database schema and the components.