#Teamcity login driver
#Teamcity login password
#Teamcity login windows

SQL Authentication requires specifying username and a password in the database settings.

SQL Server supports two ways of authentication: SQL Server authentication and Windows authentication mode.

In the Default Connection Options frame, 'no count' must be unchecked. 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.

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:

Next we need to specify primary collation: Go to the Option node in the left pane and select a collation on the right.

The requirements vary depending on how intensively the server will be used. The recommended minimum is 1Gb (1024 Mb) in the image below.

On the General page, specify the database name, ‘TeamCity’ in the image below and allocate sufficient transaction log space.

Connect to your database server, right-click the Databases node in the Object Explorer and select New database.

You need to restart your MSSQL server for the changes to take effect: in the left pane, click SQL Server Services, in the right pane, right-click SQL Server, and then click Restart.Ĭheck that SQL Server Browser is running. (MS SQL comes with TCP/IP disabled by default.) Click OK. In the right pane, right-click TCP/IP, and then click Enable and select Yes. Open SQL Server Configuration Manager and do the following:Įxpand SQL Server Network Configuration, click Protocols for MS SQL.

Additional settings for Windows authentication (MS SQL integrated security)Ĭonfigure MS SQL server to be used with TeamCity Enable TCP/IP protocol for your SQL server.

Set up JDBC Driver for SQL Server database.Create SQL database user with Windows authentication.

Create dedicated user for TeamCity with SQL server authentication.

Enable TCP/IP protocol for your SQL server.

Configure MS SQL server to be used with TeamCity.

ERROR - Unexpected exception: SQL error when doing 'DML query' while performing SQL query: SQL DML: insert into single_row values ('X'): : The table does not comply with the requirements by an external plugin. INFO - Connected to the database successfully INFO - Database system version: 8.0.15 (MySQL) INFO - JDBC driver version: 8.0 (MySQL Connector/J) INFO - Database client character set: utf8mb4 INFO - Database connection character set and collation: utf8mb4.utf8mb4_0900_ai_ci INFO - Database server character set and collation: utf8mb4.utf8mb4_0900_ai_ci INFO - Database server time zone: GMT Daylight Time INFO - Current stage: Creating a new database INFO - Generated JDBC connection string: jdbc:mysql://localhost:3310/TeamCity_DB?user=TeamCity&password=******** Log file: INFO - Current stage: Setting up database connection (administrator login is required to proceed) When i try to connect to the database i get the error: Unexpected exception: SQL error when doing 'DML query' while performing SQL query: SQL DML: insert into single_row values ('X'): : The table does not comply with the requirements by an external plugin I'm installing from an Admin account, and i've followed the guide I'm currently trailing TeamCity and i'd like to connect to a MySQL database, but i'm having no luck with it at the moment.

#Teamcity login password

#Teamcity login windows

#Teamcity login driver