Setting Up SQL Server Accounts and Permissions
Topic Last Modified: 2009-01-23
After you successfully create and enable Microsoft Office Communications Server 2007 R2 Group Chat service 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 permissions for the following:
- Channel service account (If you are installing multiple Group Chat servers, each Channel service has an account.)
- Lookup service account (If you are installing multiple Group Chat servers, all Lookup services share a single account.)
- Web service account
- Compliance service account
- Server installation account
To add service accounts to SQL Server
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.
In the console tree, under Security, right-click Logins, and then click New Login.
In the New Login dialog box, in the Login name box, specify the service account you created, and then click OK.
Repeat steps 1 through 3 for each Lookup service, Channel service, and Compliance service account that you want to add.
To add service accounts to the database owners group
In SQL Server Management Studio, under Security, and Logins, right-click the name of the service account, and then click Properties.
On the User Mapping tab, select the check box next to the database that you created for Group Chat.
In Database Role Membership, select the db_owner check box, and then click OK.
Repeat steps 1 through 3 for each Group Chat service account that you want to add.