Deployment permissions for SQL Server in Lync Server 2013

  • Article

 

Topic Last Modified: 2012-10-01

Microsoft SQL Server 2012 has specific requirements when installing and deploying Lync Server 2013. 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 2013 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 2013 role Role-Typical SQL Server permissions and group membership Role-typical Lync Server 2013 permissions and group membership Permissions outcome

Lync Server 2013 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 2013 administrator has the proper permissions to install both Lync Server 2013 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 2013 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 2013 administrator is member of RTCUniversalServerAdmins

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