This page provides instructions for configuring Confluence to use the Microsoft SQL Server database.
단계 1. 준비사항 체크
Check the following before you start:
- Check that your version of SQL Server is supported. See Database Setup for SQL Server. If your version is not supported, please upgrade to a supported version of SQL Server before installing Confluence.
- If you have been evaluating Confluence and wish to transfer your data to a new database, consult the following guide first: Database Setup for SQL Server.
- If you are migrating from another database, consult the following guide first: Database Setup for SQL Server.
단계 2. SQL Server 설치If you do not already have an operational SQL Server database, download the installation package from the Microsoft SQL Server download page and follow the instructions on MSDN.
단계 3. SQL Server database 와 사용자 설정
In this step you will create a database within SQL Server to hold your Confluence data, and a database user with authority to access that database.
- Identify which character encoding to use. To do this, check the encoding currently used by your application server and Confluence. All three must use compatible encoding. For example, the default SQL Server encoding of UCS-2 is compatible with UTF-8.
- Using your SQL administrator permissions, create a new database in SQL Server.
- If you set your application server and Confluence to use an encoding incompatible with UCS-2, specify that character encoding for the database.
Set the default collation for the database to be 'SQL_Latin1_General_CP1_CS_AS' (case sensitive). You can do this by issuing the following SQL query:
Note: if you receive an error stating 'The database could not be exclusively locked to perform the operation', you may need to prevent other connections by setting the mode to single user for the transaction:
Configure the database to use the isolation level, 'Read Committed with Row Versioning'. You can do this by issuing the following SQL query:
1 = READ_COMMITTED_SNAPSHOT option is ON. Read operations under the read-committed isolation level are based on snapshot scans and do not acquire locks.
0 = READ_COMMITTED_SNAPSHOT option is OFF (default). Read operations under the read-committed isolation level use share locks.
- Using your SQL administrator permissions, create a new SQL user account for Confluence (for example,
confluenceuser). Give this user full create, read and write permissions for the database tables. Note that Confluence must be able to create its own schema.
단계 4. Confluence 와 SQL Server 데이터베이스 드라이버 설치
- If you plan to set up a direct JDBC connection to SQL Server, you can run the Confluence installation and move directly on to the Confluence Setup Wizard, as described below. The SQL Server JDBC driver is bundled with Confluence, as documented on this page: Database Setup for SQL Server.
- If you plan to set up a datasource connection to SQL Server:
- Stop immediately after the Confluence installation, before opening the Confluence Setup Wizard in your browser. If you have already got part-way through the Confluence Setup Wizard, stop at the database setup step. You will be able to restart the setup wizard at the same step later.
- Follow the steps described in Database Setup for SQL Server.
단계 5. Confluence 셋업 마법사에서 데이터베이스 연결 설정하기
Start Confluence, and go to the Confluence Setup Wizard in your browser. Follow these steps to set up the new configuration:
- Follow the initial steps in the Database Setup for SQL Server.
- When prompted to choose an evaluation or production installation, choose production installation.
- When prompted to choose an embedded or external database, select Microsoft SQL Server from the dropdown list and choose External Database.
- Choose either the direct JDBC or the datasource connection, to suit the choice you made earlier when setting up the SQL Server database driver.
- For the JDBC connection:
When prompted for a Driver Class Name, enter the following:
When prompted for the Database URL, use this format:
If MS SQL is clustered, use this format:
- Enter the username (for example,
confluenceuser) and password you chose earlier.
- For a datasource connection: Set the Datasource Name to
Congratulations! Confluence is now using your SQL Server database to store its data.
If you get the following error message
,verify that you have given the
confluenceuseruser all the required database permissions when connecting from
- If Confluence complains that it is missing a class file, you may have placed the JDBC driver in the wrong folder.
- If none of the above describes your issue, please create a support ticket at http://support.atlassian.com and be sure to include your logs (found in