Installing SQL Server for SCCM 2012

13446

Deploying SCCM 2012 Part 4 – Installing SQL Server -In this post we will be installing SQL Server for SCCM 2012. To know the supported configurations of SQL server for SCCM 2012 please go through this link : http://technet.microsoft.com/en-us/library/gg682077.aspx. We will be installing SQL server 2008 Standard edition 64 bit + Sql server 2008 Service pack 2 + Cumulative update 9 for SQL SP2. In Part 1 we saw the installation of Active Directory Domain Services. In Part 2 we created the AD container and delegated the permissions on it. In Part 3 we installed pre-requisites for SCCM server.

Open the SQL server folder, run the setup as administrator. Select Installation and Click on New SQL server standalone installation.

Deploying SCCM 2012 Part 4 – Installing SQL Server Snap 2

Click OK once the Setup support rules are run and verified.

Deploying SCCM 2012 Part 4 – Installing SQL Server Snap 3

Enter the product key and click next.

Deploying SCCM 2012 Part 4 – Installing SQL Server Snap 4

Click next. The windows firewall warning is shown because we have firewall turned on. In the next part of the post we will create firewall rules to open the SQL ports used by SCCM.

Deploying SCCM 2012 Part 4 – Installing SQL Server Snap 5

Choose all the features by clicking select all and click next.

Deploying SCCM 2012 Part 4 – Installing SQL Server Snap 6

Choose the default instance and click next.

Deploying SCCM 2012 Part 4 – Installing SQL Server Snap 7

Click on Use the same account for all the SQL Server Services.

Deploying SCCM 2012 Part 4 – Installing SQL Server Snap 9

If you have a created a separate user account for SQL server services specify it here, in this post we will be using user account named “sccmadmin

Deploying SCCM 2012 Part 4 – Installing SQL Server Snap 8

Click Add Current User.

Deploying SCCM 2012 Part 4 – Installing SQL Server Snap 7

Click Add Current User.

Deploying SCCM 2012 Part 4 – Installing SQL Server Snap 11

For Reporting Services Configuration select Native mode default configuration.

Deploying SCCM 2012 Part 4 – Installing SQL Server Snap 12

click Next.

Deploying SCCM 2012 Part 4 – Installing SQL Server Snap 13

It will take few minutes for SQL server installation. Once the setup process is complete click next and finish the setup.

Deploying SCCM 2012 Part 4 – Installing SQL Server Snap 14

The next task is to install the SQL server Service pack 2. The SP2 is available here : http://www.microsoft.com/en-us/download/details.aspx?id=12548. Execute the SQL Server Service Pack 2.

Deploying SCCM 2012 Part 4 – Installing SQL Server Snap 15

Select MSSQLSERVER Instance and Click Next.

Deploying SCCM 2012 Part 4 – Installing SQL Server Snap 16

Click Update.

Deploying SCCM 2012 Part 4 – Installing SQL Server Snap 17

The SQL 2008 SP2 has been installed successfully.

Deploying SCCM 2012 Part 4 – Installing SQL Server Snap 18

Next we will install Cumulative update for SQL Server SP2. The Cumulative Update is available here : http://support.microsoft.com/kb/2673382. Click next and complete the setup.

Deploying SCCM 2012 Part 4 – Installing SQL Server Snap 19

Click on Close.

Deploying SCCM 2012 Part 4 – Installing SQL Server Snap 20

  • Zak

    In the step for SQL server users. Do you recommend using a separate username for the SQL opposed to SCCMAdmin? I installed the way you mentioned above because I figured it would not matter as long as it didn’t run as a built-in service account.

    • Yes a separate username is recommended. In most of the scenarios SQL is managed by a separate user and sccm by another user.

  • steoleary

    Why on earth are you installing Analysis Services and Integration Services?!

    • @steoleary – Your question is valid, the Analysis Services and Integration Services is not required for SCCM. I had installed it for my lab purpose.