• Article

Setting Up SQL Server Accounts, Rights, and Permissions

 

Topic Last Modified: 2012-03-05

After you successfully create and enable Microsoft Lync Server 2010, Group Chat service accounts, you need set up the accounts in Microsoft SQL Server Management Studio and add them to the database owners group. Use the following procedures to add accounts and configure database user rights and 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

  1. Ensure the account you’re creating for the Server installation has serveradmin rights as system messages need to written to the master database. The Web service account does not need any permission in SQL Server. For Channel and Lookup Service accounts, permission to the database owners group is sufficient.

  2. 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.

  3. In the console tree, under Security, right-click Logins, and then click New Login.

  4. In the New Login dialog box, in the Login name box, specify the service account you created, and then click OK.

  5. Repeat steps 1 through 4 for each Lookup, Channel, and Compliance service account that you want to add.

To add service accounts to the database owners group

  1. In SQL Server Management Studio, under Security, and Logins, right-click the name of the service 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 Server.

  3. In Database Role Membership, select the db_owner check box.

  4. In Default database, select Group Chat from the drop-down menu, and then click OK.

  5. Repeat steps 1 through 4 for each Group Chat Server account that you want to add.