MS SQL Server

Connecting Crowd to a Database

このページの内容

お困りですか?

アトラシアン コミュニティをご利用ください。

コミュニティに質問

サポート対象バージョン

Crowd supports the versions of MS SQL Server listed on the Supported Platforms page.

When you run the Crowd Setup Wizard, you will be asked to choose a database and provide configuration settings for that database. It will make things easier if you have created the database and deployed the database driver before you start the Setup Wizard.

Follow the instructions below to set up MS SQL Server for Crowd.

1. Configure SQL Server

  1. Create a database user which Crowd will connect as (e.g. crowduser).

    In SQL Server, the database user (crowduser above) should not be the database owner, but should be in the db_owner role.
    Additionally, you should create the database with case sensitive collation.

  2. Create a database for Crowd to store data in (e.g. crowddb).
  3. Ensure that the user has permission to connect to the database, and create and populate tables
  4. Ensure that the new database was set to use Read Committed with Row Versioning as its isolation level.
    You can apply the new isolation by executing the following query:

    ALTER DATABASE <database name>
       SET READ_COMMITTED_SNAPSHOT ON
       WITH ROLLBACK IMMEDIATE;
    

    To verify the changes, use this query which should result in '1':

    SELECT sd.is_read_committed_snapshot_on
    FROM sys.databases AS sd
    WHERE sd.[name] = '<database name>';

次のステップ

Complete the Crowd installation, then start Crowd and run the Setup Wizard as described in the Installation Guide.

Configuring Unicode Support in MS SQL Server

To configure Crowd to support Unicode in MS SQL Server, enter the following in the 'Hibernate Dialect' field on the Crowd Setup Wizard's Database Configuration screen:
com.atlassian.crowd.util.persistence.hibernate.SQLServerIntlDialect
最終更新日 2023 年 9 月 29 日

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.