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 Logindialog box, in the Login namebox, 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 Mappingtab, select the check box next to the database that you created for Group Chat.
-
In Database Role Membership, select the db_ownercheck box, and then click OK.
-
Repeat steps 1 through 3 for each Group Chat service account that you want to add.