Setting Up SQL Server Accounts and Permissions (2007 R2 Beta)

  • Article

[This is preliminary documentation and is subject to change. Blank topics are included as placeholders.]

After you successfully create and enable Group Chat server accounts, you need set up the accounts in SQL Server Management Studio and add them to the database owners group. Use the following procedures to add accounts and configure database owner permissions for the following:

  • Channel Server account (if you are installing multiple Chat Servers, each Channel Server has an account).
  • Lookup Server account (if you are installing multiple Chat Servers, all Lookup Servers share a single account).
  • Web Service account.
  • Compliance Server account.
  • Server installation account

To add server accounts to SQL Server

  1. Open SQL Server Management Studio by clicking Start, pointing to All Programs, pointing to Microsoft SQL Server 2005, and then clicking SQL Server Management Studio.

  2. In the console tree, under Security, right-click Login name, and then click New Login.

  3. In the New Login dialog box, in the User Login box, specify the account you created for the server, and then click OK.

  4. Repeat steps 1 through 3 for each Lookup Server, Channel Server, and Compliance Server account to be added.

To add server accounts to the database owners group

  1. In SQL Server Management Studio, in the tree, right-click the name of the server account, and then click Properties.

  2. On the User Mapping tab, select the check box next to the database that you created for Group Chat.

  3. In Database Role Membership, select the db_owner check box, and then click OK.

  4. Repeat steps 1 through 3 for each Group Chat Functionality server account to be added.