On the Instance Configuration page, choose the Default Instance and click on Next.

On the Feature Selection page, choose all the features by clicking S elect All and click on N ext.

Windows Firewall is currently turned on and we have not yet opened the SQL ports on Firewall. Select Installation and Click on New SQL server standalone installation.Ĭlick on OK once the Setup support rules are run and verified. Insert the SQL server 2008 DVD and right click on setup.exe, click on Run as administrator. In this post we will be installing SQL server 2008 Standard Edition, SQL server service pack 2 and Cumulative update 9. Configuration Manager 2012 SP1 supports SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server Express 2008 R2, SQL Server 2012 Express editions. When you use SQL Server that is installed on a computer that is remote from the site server, the child primary site can support up to 100,000 clients.īefore you start installing SQL server for SCCM 2012 SP1, please check Supported SQL Configurations for Configuration Manager. Most of the times I have seen that users encounter the SQL server error during the configuration manager setup either because the installed SQL server version is not supported by SCCM or cumulative updates are not installed. A child primary site that uses SQL Server installed on the same computer as the site server can support up to 50,000 clients. When you use SQL Server Standard for the site database at the central administration site, the shared database and hierarchy supports up to 50,000 clients. When you use SQL Server Enterprise or Datacenter for the site database at the central administration site, the shared database and hierarchy supports up to 400,000 clients. Configuration Manager 2012 uses Microsoft SQL Server as a distributed change management database and integrates with SQL Server Reporting Services (SSRS) to produce reports to monitor and track the management activities. Installing SQL Server For SCCM 2012 SP1 – In this post we will see the steps to install SQL server for SCCM 2012 SP1.

Download sql server 2008 r2 update