prajwaldesai.co m http://prajwaldesai.com/installing-sql-server-for-sccm-2012-sp1-sccm-2012-sp1/

Installing SQL Server For SCCM 2012 SP1 - SCCM 2012 SP1

Installing SQL Server For SCCM 2012 SP1 – In this post we will see the steps to install SQL server f orSCCM 2012 SP1. Conf iguration Manager 2012 uses Microsof t SQL Server as a distributed changemanagement database and integrates with SQL Server Reporting Services (SSRS) to produce reports tomonitor and track the management activit ies. When you use SQL Server Enterprise or Datacenter f or thesite database at the central administration site, the shared database and hierarchy supports up to 400,000clients. When you use SQL Server Standard f or the site database at the central administration site, theshared database and hierarchy supports up to 50,000 clients. A child primary site that uses SQL Serverinstalled on the same computer as the site server can support up to 50,000 clients. When you useSQL Server that is installed on a computer that is remote f rom the site server, the child primary site cansupport up to 100,000 clients.

Bef ore you start installing SQL server f or SCCM 2012 SP1, please check Supported SQL Configurationsfor Configuration Manager. Most of the times I have seen that users encounter the SQL server errorduring the conf iguration manager setup either because the installed SQL server version is not supported bySCCM or cumulative updates are not installed. Conf iguration Manager 2012 SP1 supports SQL Server2008, SQL Server 2008 R2, SQL Server 2012, SQL Server Express 2008 R2, SQL Server 2012Express edit ions. In this post we will be installing SQL server 2008 Standard Edit ion, SQL serverservice pack 2 and Cumulative update 9.

Installing SQL Server 2008 Standard

Insert the SQL server 2008 DVD and right click on setup.exe, click on Run as administrator.

Select Installation and Click on New SQL server standalone installation.

Click on OK once the Setup support rules are run and verif ied.

Enter the product key and click on Next .

Click on Install.

We see there are 2 warnings. Windows Firewall is currently turned on and we have not yet opened the SQLports on Firewall. We will do this in the next post. Click on Next .

On the Feature Selection page, choose all the f eatures by clicking Select All and click on Next .

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

Note – If you are creating a Named Instance , then during the SCCM 2012 SP1 setup you might comeacross this error “The specif ied SQL Server instance is not configured to use dynamic ports” unlessyou have not conf igured dynamic ports f or SQL server instance. To f ix this error launch the SQL ServerConfiguration Manager, expand SQL Server Network Configuration. Click on Protocols f or Instance(Instance is your Named Instance). On the right side pane, right click on the TCP/IP and click onProperties. Click on IP Addresses tab and scroll down to the bottom and under the IPALL, set TCP Portvalue to 1433. Click on Apply and af ter this change you must restart SQL Server Service.

Click on Use the same account for all the SQL Server Services. Click on Browse. If you have a createda separate user account f or SQL server services specif y it here, in this post we will be using user accountnamed “sccmadmin”. Specif y the account name and password. Click on OK.

Click on Next.

On the Database Engine Configuration window, click on Add Current User. Click on Next.

On the Analysis Services Configuration window, click on Add Current User and click on Next.

Choose Install the native mode default configuration and click on Next .

You should see the status of all the rules as Passed. Click on Next.

Click on Install to start the SQL server 2008 installation.

Af ter f ew minutes, we see that the SQL Server 2008 installation has been completed successf ully. Click onClose.

Installing SQL Server 2008 Service Pack 2

We have installed the SQL server 2008 Standard edit ion. Our next step is to install the SQL server 2008Service Pack 2. You can download the SQL server 2008 Service pack 2 f rom here. Once the download iscomplete, right click on the setup f ile and click on Run as Administrator . On the Welcome page, click onNext .

The instance is automatically selected, click on Next.

Click on Update .

The installation of SQL Server 2008 Service Pack 2 is complete. Click on Next and on the next page clickClose to close the setup wizard.

Installing SQL Server 2008 SP2 Cumulative update 9

In the above steps we have installed SQL Server 2008 Standard edit ion, next we have installed SQLServer 2008 service pack 2. Now we will be installing SQL Server 2008 SP2 Cumulative Update 9. Youcan download the SQL Server 2008 SP2 Cumulative Update 9 here. Right the setup.exe and click on Runas Administrator. On the Welcome page click on Next . Read the license terms and check the box Iaccept the license terms and click on Next.

The instance is automatically picked, click on Next.

Click on Update to install the cumulative update.

The Cumulative update has been installed successf ully. Click on Close .

During the installation of Conf iguration Manager 2012 SP1, the conf iguration manager checks if the SQLserver memory limit is limited. If the memory is not limited, then a warning is displayed. To avoid that lets limitour server with a memory limit. Click on Start , click on All Programs, click on Microsoft SQL Server 2008,click on SQL Server Management Studio. Login to the server by specif ying the server name. Since theSQL server is installed on the same machine I am using localhost as the server name. Click on Connect.

Right click the Server and click on Properties.

Click on Memory, set Minimum server memory value to 4096 MB and set Maximum server memory as8192 MB. Click on OK and close the SQL management studio.

We have completed the installation of SQL server 2008, service pack and cumulative update. In the nextpost we will see installing WSUS, conf iguring f irewall exceptions and opening ports f or SQL replication f orSCCM 2012.

Written by Prajwal Desai

I am Prajwal Desai and I have been working in the IT f or over 5 years with a strong f ocus onMicrosof t Server Technologies. For the last f ive years, as a System Administrator I have beenworking on Lync, SCCM, Vmware, VDI, Exchange, Windows Servers etc. I’m currently veryinterested in everything related to Conf iguration Manager 2012, Lync, Windows Server and Exchange.