![]() ![]() Specify the connection settings: - Database host - your SQL server host - Port - optional, - Database instance name - leave blank for the default SQL server instance. For Windows authentication (MS SQL integrated security), make sure the server is running under the user configured at this step.Ĭlick the Refresh the JDBC drivers if asked. For the 64-bit JVM used to run the TeamCity server, use the /enu/auth/ 圆4 /sqljdbc_auth.dll and place it into the TeamCity Data Directory \lib\jdbc\native\windows-amd64 directory.įor earlier versions, you need to copy the required library into a directory of your choice outside the TeamCity installation and specify the directory in the TeamCity server JVM options and maintainDB command-line tool options as "=". Since TeamCity 2017.2.4, for the default 32-bit JVM bundled with the TeamCity server, copy the /enu/auth/ x86 /sqljdbc_auth.dll file into TeamCity Data Directory \lib\jdbc\native\windows-i386. The required version of the library depends on the bitness of the Java version used by the server. IntegratedSecurityAuthAdditional settings for Windows authentication (MS SQL integrated security)įor Windows authentication (MS SQL integrated security), in addition to the JDBC driver, it is necessary to install native driver library sqljdbc_auth.dll from the JDBC driver package. Unpack the downloaded package into a temporary directory.Ĭopy the sqljdbc42.jar from the just downloaded package into the TeamCity Data Directory/lib/jdbc directory. tar.gz depending on your TeamCity server platform). For MS SQL Server 2005, use JDBC driver v4.0 (exe or. Note that Microsoft JDBC driver v6.0 has compatibility issues with Microsoft SQL Server 2005. tar.gz depending on your TeamCity server platform) from the Microsoft Download Center. Set up JDBC Driver for SQL Server databaseĭownload the Microsoft JDBC driver v6.0 (sqljdbc_6.0.x package. ![]() Now grant this user db owner permissions: select User Mapping in the left pane, in the upper right pane check the TeamCity database in the list and in the lower pane grant the user TeamCity database owner rights: check the db_owner box. ![]() In the Select user or Group dialog, specify the user account which will be used to run TeamCity. ![]() Go to the Security node, right-click Logins, select New Login and in the General window that opens provide the login name, select Windows authentication and click the search button. Click Ok.Ĭreate SQL database user with Windows authentication Next select User Mapping in the left pane, in the upper right pane check the TeamCity database in the list and in the lower pane grant the user TeamCity database owner rights: check the db_owner box. Go to the Security node, right-click Logins, select New Login and in the General window that opens provide the login name, TeamCity in the image below, select the SQL server authentication and provide the password for the user. However, it requires additional setupĬreate dedicated user for TeamCity with SQL server 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. It is recommended to start with this authentication before you try to use Windows authentication. 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 space. 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.Ĭonnect to your database server, right-click the Databases node in the Object Explorer and select New database. (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. Configure MS SQL server to be used with TeamCityĮnable TCP/IP protocol for your SQL server ![]()
0 Comments
Leave a Reply. |