

HOW TO SETUP SQL 2012 EXPRESS REPORTING SERVICES UPDATE
This includes any service pack version or cumulative update version of SQL Server 2008 R2. Configuration Manager with no service pack does not support the site database on any version of a SQL Server 2008 R2 cluster.For more information, see Site and Site System Role Scalability. When you use SQL Server Standard for the database at the central administration site, the hierarchy can only support up to 50,000 clients.If you use a SQL Server cluster for the site database, you must add the computer account of the site server to the Local Administrators group of each Windows Server cluster node computer. The site database site system role is the only System Center 2012 Configuration Manager site system role supported on an instance of a Windows Server cluster. When you use a remote SQL Server, the instance of SQL Server used to host the site database can also be configured as a SQL Server failover cluster in a single instance cluster, or a multiple instance configuration. The SQL Server instance can be co-located with the site system server, or on a remote computer. Here is an overview of the SQL Server configurations and requirements for supported SQL Server installations for ConfigMgr 2012.Ĭonfigurations for the SQL Server Site DatabaseĮach System Center 2012 Configuration Manager site database can be installed on either the default instance or a named instance of a SQL Server installation.
