teamcity-server.log reports that the unsupported "NOCOUNT" option is enabled on the MS SQL database server. The enabled "no count" setting on the MS SQL server prevents TeamCity from starting queued builds. Since TeamCity 10, TeamCity detects the presence of this unsupported option on the server startup and tries to unset it for the current connection. It is strongly recommended to disable the setting in the database defaults. C Contact your DBA to disable the setting as follows:
- In MS SQL Server Management Studio, connect to your database server.
- 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.
Database character set/collation-related problems