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.
Ensure all the setup support rules show Passed. Click Next.
Enter the SQL server product key. Click Next.
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.
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.
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.
Click Add Current User.
Click Add Current User.
For Reporting Services Configuration select Native mode default configuration.
All rules show passed, hence you can proceed with SQL install. Click Next.
It will take few minutes for SQL server installation. Once the setup process is complete click Next and finish the setup.
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.
Select MSSQLSERVER Instance and Click Next.
The SQL 2008 SP2 has been installed successfully.
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.