Topic Last Modified: 2011-02-23

A Standard Edition server deployment automatically installs the required Microsoft SQL Server Express database software and SQL store, so all options are pre-populated and you cannot make changes to the default configuration.

The Front End pool of an Enterprise Edition server deployment requires a supported 64-bit edition of the Microsoft SQL Server database software for the back-end database. You can either select a previously defined SQL store to be used for the back-end database or define a new SQL store by specifying a fully qualified domain name (FQDN) of the server on which the SQL store is to reside, as well as the SQL Server instance you want to use for the new SQL store (which can be the default instance or a named instance that you specify).

For details about SQL Server support, see Database Software and Clustering Support in the Supportability documentation. For details about planning the back-end database, Components and Topologies for Archiving in the Planning documentation and SQL Server Data and Log File Placement in the Deployment documentation. For details about setting up SQL Server for the back-end database, see Configure SQL Server for Lync Server 2010 in the Deployment documentation.

If the account used to publish the topology has the appropriate user rights and permissions, you can create the back-end database (RTC) when you publish your topology. You can also create the database later, including as part of the installation procedure.

To install and deploy the databases on the SQL Server-based server for an Enterprise Edition deployment, you must be a member of the SQL Server sysadmins group for the SQL Server-based server where you are installing the database files. If you are not a member of the SQL Server sysadmin group, you must request that you be added to the group until the database files are deployed. If you cannot be made a member of the sysadmins group, you should provide your SQL Server database administrator with the script to configure and deploy the databases. For details about the proper user rights and permissions you need to accomplish the procedures, see Deployment Permissions for SQL Server.