Share via


Deployment Permissions for SQL Server

 

Topic Last Modified: 2010-11-03

Microsoft SQL Server 2005 and Microsoft SQL Server 2008 have specific requirements when installing and deploying Microsoft Lync Server 2010. Because Windows and SQL Server define their security differently, logging in as an administrator in the Active Directory domain does not implicitly grant permissions for SQL Server. You must also be a member of the sysadmin entity on the SQL Server-based server you are configuring.

Permissions Required for Database and Lync Server Installation

The following options detail three permissions and group membership associations for installation of Lync Server files and SQL Server databases. Choose the scenario that best meets the requirements of your organization.

Permissions and Group Membership Associations

SQL Server or Lync Server role Role-Typical SQL Server permissions and group membership Role-typical Lync Server permissions and group membership Permissions outcome

Lync Server administrator

Must be granted membership of sysadmins SQL Server security group and member of the SQL Server local Administrators group

Must be a member of the RTCUniversalServerAdmins group

Lync Server administrator has the proper permissions to install both Lync Server and SQL Server databases.

SQL Server administrator

SQL Server sysadmin group member (or equivalent) and member of the SQL Server local Administrators group

Must be a member of the RTCUniversalServerReadOnly group

SQL Server administrator has the proper permissions to install both Lync Server and SQL Server databases.

Both administrators sharing installation duties

SQL Server administrator is member of sysadmins group (or equivalent) and member of the SQL Server local Administrators group

Lync Server administrator is member of RTCUniversalServerAdmins

The Lync Server administrator can install Lync Server, but cannot install the databases. The SQL Server administrator uses the Lync Server Management Shell and Windows PowerShell cmdlets provided by the Lync Server administrator to install the databases. The Lync Server Management Shell used by the SQL Server administrator is installed on the Front End Server. This eliminates the need to install the Lync Server administrative tools on the SQL Server-based server.