Installing SQL Server For SCCM 2012 SP1

Prajwal Desai
Posted by Prajwal Desai

Installing SQL Server For SCCM 2012 SP1 – In this post we will see the steps to install SQL server for SCCM 2012 SP1. 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. 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. 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. 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 that is installed on a computer that is remote from the site server, the child primary site can support up to 100,000 clients.

Before you start installing SQL server for SCCM 2012 SP1, please check Supported SQL Configurations for Configuration ManagerMost 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. Configuration Manager 2012 SP1 supports SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server Express 2008 R2, SQL Server 2012 Express editionsIn this post we will be installing SQL server 2008 Standard Edition, SQL server service pack 2 and Cumulative update 9.

Installing SQL Server For SCCM 2012 SP1 Snap 1

 Installing SQL Server 2008 Standard

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

Installing SQL Server For SCCM 2012 SP1 Snap 2

Select Installation and Click on New SQL server standalone installation.

Installing SQL Server For SCCM 2012 SP1 Snap 3

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

Installing SQL Server For SCCM 2012 SP1 Snap 4

Enter the product key and click on Next.

Installing SQL Server For SCCM 2012 SP1 Snap 5

Click on Install.

Installing SQL Server For SCCM 2012 SP1 Snap 6

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

Installing SQL Server For SCCM 2012 SP1 Snap 7

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

 https://www.prajwaldesai.com/wp-content/uploads/2013/05/Deploying-SCCM-2012-Part-4-%E2%80%93-Installing-SQL-Server-Snap-6.jpg

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 come across this error “The specified SQL Server instance is not configured to use dynamic ports” unless you have not configured dynamic ports for SQL server instance. To fix this error launch the SQL Server Configuration Manager, expand SQL Server Network Configuration. Click on Protocols for Instance (Instance is your Named Instance). On the right side pane, right click on the TCP/IP and click on Properties. Click on IP Addresses tab and scroll down to the bottom and under the IPALL, set TCP Port value to 1433. Click on Apply and after this change you must restart SQL Server Service.

Installing SQL Server For SCCM 2012 SP1 Snap 8

Click on Use the same account for all the SQL Server Services. Click on Browse. 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”. Specify the account name and password. Click on OK.

Installing SQL Server For SCCM 2012 SP1 Snap 9

Click on Next.

Installing SQL Server For SCCM 2012 SP1 Snap 10

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

Installing SQL Server For SCCM 2012 SP1 Snap 11

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

Installing SQL Server For SCCM 2012 SP1 Snap 12

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

Installing SQL Server For SCCM 2012 SP1 Snap 13

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

Installing SQL Server For SCCM 2012 SP1 Snap 14

Click on Install to start the SQL server 2008 installation.

Installing SQL Server For SCCM 2012 SP1 Snap 15

After few minutes, we see that the SQL Server 2008 installation has been completed successfully. Click on Close.

Installing SQL Server For SCCM 2012 SP1 Snap 16

Installing SQL Server 2008 Service Pack 2

We have installed the SQL server 2008 Standard edition. Our next step is to install the SQL server 2008 Service Pack 2. You can download the SQL server 2008 Service pack 2 from here. Once the download is complete, right click on the setup file and click on Run as Administrator. On the Welcome page, click on Next.

Installing SQL Server For SCCM 2012 SP1 Snap 17

The instance is automatically selected, click on Next.

Installing SQL Server For SCCM 2012 SP1 Snap 18

Click on Update.

Installing SQL Server For SCCM 2012 SP1 Snap 19

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

Installing SQL Server For SCCM 2012 SP1 Snap 20

 Installing SQL Server 2008 SP2 Cumulative update 9

In the above steps we have installed SQL Server 2008 Standard edition, next we have installed SQL Server 2008 service pack 2. Now we will be installing SQL Server 2008 SP2 Cumulative Update 9. You can download the SQL Server 2008 SP2 Cumulative Update 9 here. Right the setup.exe and click on Run as Administrator. On the Welcome page click on Next. Read the license terms and check the box I accept the license terms and click on Next.

Installing SQL Server For SCCM 2012 SP1 Snap 21

The instance is automatically picked, click on Next.

Installing SQL Server For SCCM 2012 SP1 Snap 22

Click on Update to install the cumulative update.

Installing SQL Server For SCCM 2012 SP1 Snap 23

The Cumulative update has been installed successfully. Click on Close.

Installing SQL Server For SCCM 2012 SP1 Snap 24

During the installation of Configuration Manager 2012 SP1, the configuration manager checks if the SQL server memory limit is limited. If the memory is not limited, then a warning is displayed. To avoid that lets limit our 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 specifying the server name. Since the SQL server is installed on the same machine I am using localhost as the server name. Click on Connect.

Installing SQL Server For SCCM 2012 SP1 Snap 25

Right click the Server and click on Properties.

Installing SQL Server For SCCM 2012 SP1 Snap 26

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

Installing SQL Server For SCCM 2012 SP1 Snap 27

We have completed the installation of SQL server 2008, service pack and cumulative update. In the next post we will see installing WSUS, configuring firewall exceptions and opening ports for SQL replication for SCCM 2012.

Share This Article
Prajwal Desai
Posted by Prajwal Desai
Follow:
Prajwal Desai is a Microsoft MVP in Intune and SCCM. He writes articles on SCCM, Intune, Windows 365, Windows Server, Windows 11, WordPress and other topics, with the goal of providing people with useful information.
Leave a comment