Topic Last Modified: 2011-05-11

SQL Server 2005 with Service Pack 3 (SP3) (required) or latest service pack (recommended), SQL Server 2008 with Service Pack 1 (SP1) (required) or latest service pack (recommended), and SQL Server 2008 R2 are supported for the Central Management store. For each database that you deploy, you can use a single SQL Server instance for all databases for your Microsoft Lync Server 2010 deployment that can be collocated on a database server, or you can use a dedicated SQL Server instance for each of these databases. For details about database collocation, see Supported Server Collocation in the Supportability documentation.

Note:
Lync Server 2010 automatically installs SQL Server 2008 Express on each Standard Edition server and each Lync Server 2010 server on which the local configuration store is located. After deploying the servers, you can upgrade the RTC database on the Standard Edition server and the RTCLocal databases on other server roles to SQL Server 2008 R2 Express by running the SQL Server 2008 R2 Express setup wizard and selecting the upgrade option. Repeat this process for each RTC and RTCLocal database.

Additionally, each SQL Server instance must be installed and available prior to completing the steps in Topology Builder that set up the databases, or manually creating the databases with Windows PowerShell cmdlets. If you intend to provide high availability for Microsoft Lync Server 2010, Enterprise Edition by using SQL Server failover clustering, see Configure SQL Server Clustering. For details about SQL Server supportability, see Set Up Hardware and the System Infrastructure.

To install SQL Server 2008 SP1

  1. See the SQL Server 2008 SP1 documentation at: http://go.microsoft.com/fwlink/?LinkId=202921.

  2. Download SQL Server 2008 SP1 from the Microsoft Download Center at: http://go.microsoft.com/fwlink/?LinkID=202743.

To install SQL Server 2008 R2

  1. See the SQL Server 2008 R2 documentation at: http://go.microsoft.com/fwlink/?LinkId=218015.

To install SQL Server 2005 SP3

  1. See the SQL Server 2005 SP3 documentation at: http://go.microsoft.com/fwlink/?LinkId=202922.

  2. Download SQL Server 2005 SP3 from the Microsoft Download Center at: http://go.microsoft.com/fwlink/?LinkID=202744.