Confluence 6 SQL Server creates a database and database user

Source: Internet
Author: User
Tags rollback

Once you have successfully installed the SQL Server server, create the database users and databases for your confluence as follows:

  1. Use your SQL administrator permissions to create a new database (for example confluence ).
  2. The
  3. sets the default character set for the database to sql_latin1_general_cp1_cs_as (case sensitive).
    a Lter DATABASE <database-name> COLLATE sql_latin1_general_cp1_cs_as

    If you see The ' database could not being exclusively locked to perform the operation ' error, you need to prohibit other users from connecting to the database by setting the database schema to single user mode.

    a Lter DATABASE <database-name> SET single_user with ROLLBACK IMMEDIATE; <your ALTER DATABASE query> alter DATABASE <database-name> SET multi_user;
  4. Check the isolation level of the database Read_committed_snapshot set to ON.
    s Elect is_read_committed_snapshot_on from sys.databases WHERE name= ' database-name '

    If the query returns a 1 , then read_committed _snapshot set to ON, you have completed the setup correctly.

    If the result returned by the query is   0 and the  read_committed_snapshot option is OFF, you need to run the following command to complete the setup:

    alter DATABASE <d Atabase-name> &NBSP;&NBSP;&NBSP; set Read_ Committed_snapshot on &NBSP;&NBSP;&NBSP; with ROLLBACK IMMEDIATE;
  5. Using your SQL Administrator privileges, create a new SQL user account for confluence (for example confluenceuser ).
  6. For database tables, assign, create, read, and write permissions to this user. Confluence must be able to create its own schema. Refer to the SQL Server documentation to learn how to do this.

Https://www.cwiki.us/display/CONFLUENCEWIKI/Database+Setup+for+SQL+Server

Confluence 6 SQL Server creates a database and database user

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.