Guide to Install SQL Server for SCCM 2012

This post covers the steps to install SQL server for SCCM 2012. The Configuration Manager site database is a SQL Server database that contains data about your SCCM infrastructure and objects. It also contains the information about client systems you manage, and other discovered resources. Before installing SQL server, find out the supported SQL server version for SCCM 2012 here.

This post is a part of SCCM 2012 installation. If you need to know what else is required before you install SQL, check the below helpful posts.

  • Install Active Directory for SCCM 2012 – Link
  • SCCM 2012 Prerequisites – Link
  • Create System Management container and Extend AD Schema – Link

Note – The most common question that most of the admins have is, where should i install SQL server ?. Should it be local or installed remotely. Most of the SCCM admins believe that the SQL should be installed local. Running SCCM and SQL server on same server will give you good performance. Remote SQL installations often do not perform much better. Most of all with a remote database, you are adding an extra server and extra complexity into the project.

Install SQL Server for SCCM 2012

We will now go through the steps of installing SQL server. We are currently installing for SCCM 2012. Ensure that you are using compatible version of SQL server. Mount the SQL server ISO and open the SQL server folder. Run the setup as administrator. Select Installation and click New SQL server standalone installation.

Deploying SCCM 2012 Part 4 – Installing SQL Server Snap 2

Ensure all the setup support rules show Passed. Click Next.

Deploying SCCM 2012 Part 4 – Installing SQL Server Snap 3

Enter the SQL server product key. Click Next.

Deploying SCCM 2012 Part 4 – Installing SQL Server Snap 4

We see the Windows Firewall warning. You can fix this by creating firewall rules to open the SQL ports used by SCCM. I will be covering that in my next post. Click Next.

Deploying SCCM 2012 Part 4 – Installing SQL Server Snap 5

Since I am installing SQL server for SCCM in my lab setup, I am selecting all the features. Ideally you need to select only 3 features :

  • Database Engine Services
  • Reporting Services
  • Management Tools – Basic and Management Tools – Complete.

Click Next.

Deploying SCCM 2012 Part 4 – Installing SQL Server Snap 6

You can either choose default instance or Named instance. I will go with Default Instance. Click Next.
Deploying SCCM 2012 Part 4 – Installing SQL Server Snap 7

You can create and specify multiple service accounts for each server. However for lab purpose, I am using a single account. 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.

SQL service accounts

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

All rules show passed, hence you can proceed with SQL install. 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

Install SQL Server Service Pack 2

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

Install Latest Cumulative Update

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 Close.

Deploying SCCM 2012 Part 4 – Installing SQL Server Snap 20

You might also like

4
Leave a Reply

2 Comment threads
2 Thread replies
0 Followers
 
Most reacted comment
Hottest comment thread
newest oldest most voted
steoleary

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

Prajwal Desai

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

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.

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. AcceptRead More