- Install microsoft jdbc driver 6.0 for sql server install#
- Install microsoft jdbc driver 6.0 for sql server drivers#
- Install microsoft jdbc driver 6.0 for sql server password#
- Install microsoft jdbc driver 6.0 for sql server download#
If a named instance is used, provide its name here.ĭatabase name - the name of the newly created database
Install microsoft jdbc driver 6.0 for sql server drivers#
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.ĭatabase instance name - leave blank for the default SQL server instance. For the 64-bit JVM used to run the TeamCity server, use the /enu/auth/圆4/sqljdbc_auth.dll and place it into the /lib/jdbc/native/windows-amd64 directory. The required version of the library depends on the bitness of the Java version used by the server.įor the default 32-bit JVM bundled with the TeamCity server, copy the /enu/auth/x86/sqljdbc_auth.dll file into /lib/jdbc/native/windows-i386.
Install microsoft jdbc driver 6.0 for sql server install#
tar.gz depending on your TeamCity server platform).Īdditional 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. For MS SQL Server 2005, use JDBC driver v4.x ( exe or. Note that Microsoft JDBC driver v6.0+ has compatibility issues with Microsoft SQL Server 2005. Unpack the downloaded package into a temporary directory.Ĭopy the sqljdbc42.jar (or in versions above 6.0) package from the just downloaded package into the /lib/jdbc directory.
Install microsoft jdbc driver 6.0 for sql server download#
tar.gz depending on your TeamCity server platform) from the Microsoft Download Center. Set up JDBC Driver for SQL Server databaseĭownload a Microsoft JDBC driver version 6.0 or later (pick. Grant this user the 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.
Install microsoft jdbc driver 6.0 for sql server password#
Go to the Security node, right-click Logins, select New Login, and in the General window that opens provide the login name ("TeamCity" on 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 turned off. Now make sure the " no count" setting is disabled as follows: right-click the server instance in Object Explorer, go to Properties | Connections. 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: 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. 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 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, then click Enabled and select Yes. Open SQL Server Configuration Manager and do the following:Įxpand SQL Server Network Configuration, click Protocols for MS SQL. Setting up TeamCity with MS SQL Server PrerequisitesĬonfigure MS SQL server to be used with TeamCity Enable TCP/IP protocol for your SQL server
0 kommentar(er)
