Configure SQL Server for Lync Server 2010
Topic Last Modified: 2011-05-13
The Microsoft Lync Server 2010 Central Management store holds user data for all Enterprise Edition servers within a pool, and is designed to be located on a SQL Server-based Back End Server or a SQL Server cluster. As a centralized repository, the Central Management store cannot be installed on the same computer as any other Lync Server 2010 role. The Central Management store cannot reside on an Enterprise Edition server in the pool. The Central Management store is created automatically when you publish the topology and select to create the databases. The computer that you designate as the Back End Server must already be running Microsoft SQL Server database software in order for the installation to succeed. Before you deploy Enterprise Edition server, install SQL Server 2008 with Service Pack (SP) 1 (required) or latest service pack (recommended), SQL Server 2008 R2, or SQL Server 2005 with SP3 (required) or latest service pack (recommended) on a dedicated computer that meets the hardware requirements. For details about hardware requirements, see Server Hardware Platforms in the Supportability documentation. Before you create the Front End pool, you must also configure Windows Firewall to allow Lync Server 2010 access to SQL Server 2005 and SQL Server 2008 over specific ports by defining ports for the server using SQL Server Configuration Manager and opening ports in Windows Firewall with Advanced Security.