SQL Server is a requirement for SCCM 2012 R2. In this part of the SCCM lab series, we will be installing SQL Server 2012 SP1 for SCCM. We can install SQL Server locally on the SCCM server to save cost and resources instead of installing it on a remote server. Microsoft states that SQL Server license is included with SCCM so there is no need to purchase a separate SQL license.
Before we install SQL Server, let’s create a domain service account called sccmadm in Active Directory.
Add the user to the Domain Admins group
On the SCCM server, log in as DALARIS\sccmadm. Insert the SQL Server 2012 SP1. Wait for the Installation windows to come up.
Click the Installation tab and choose New SQL Server stand-alone installation or add features to an existing installation.
Click OK once the operation completed and all 8 items are shown as “Passed.”
Choose Evaluation. Click Next. We will have 180 days to test the product.
Choose “I accept the license terms“. Click Next.
Here in this lab I choose not to include updates, but in production environments, you should choose to include updates. Click Next.
Choose SQL Server Feature Installation and click Next.
Choose the following features
Database Engine Services,
Reporting Services-Native, and
Management Tools – Complete.
Choose Default Instance with Instance ID being MSSQLSERVER.
If you choose Named instance, you might encounter an error when installing SCCM. The error indicates that the SQL Instance is not configured to use Dynamic Port.
To resolve this issue, launch SQL Server Configuration Manager, expand SQL Server network Configurations. Click Protocols for Instance. On the right side, click TCP/IP and choose Properties. Click IP Address tab and click IPALL at the end. Set TCP Port value to 1433. Restart SQL Server service to take effect.
Enter the account Dalaris\sccmadm that we created at the beginning of this lab. This is the service account for SQL Server and SCCM Server. Change startup type for all services to Automatic.
Choose Windows Authentication Mode and add Current User.
Under Report Service Native Mode, choose the radio button Install and Configure. Click Next.
Click Next on Error reporting
Click Next when all 6 operations shown as “Passed“.
SQL Server installation will begin. Configuration process also takes place. You might get an error regarding memory limit is not set. To fix this issue, launch SSMS, right-click the server, and choose Properties. Change Memory limit with MAXIMUM and MINIMUM values of 8192 MB.
Click Close when done.