Gateway Tek: ConfigMgr 2012 / SCCM 2012 SP1 Step by Step Guide Part 2: SQL 2012

ConfigMgr 2012 / SCCM 2012 SP1 Step by Step Guide Part 2: SQL 2012

Part 2 describes the installation of SQL 2012 (do not use SP1 - no support for WSUS)

(Edit 21st November 2013: SQL 2012 SP1 fully supported for SCCM 2012 SP1 or R2)

This installation was carried out on a small site (approx 300 users) so the SQL deployment did not have to be as carefully designed. For larger Config Mgr deployments it is essential to design SQL and carefully locate database, log files and tempdb on seperate drives.

My colleague, System Centre MVP Paul Keely, has prepared a good guide for SQL design in relation to System Centre deployments.

http://gallery.technet.microsoft.com/SQL-Server-guide-for-8584c403

1. SQL Pre-Requisite

You must add the .Net Framework 3.5 feature. However, in Windows Server 2012, this cannot be done through the GUI

First mount the Windows Sever 2012 media and open PowerShell as Administrator

Run the following PowerShell command

Install-WindowsFeature Net-Framework-Core -Source G:\Sources\sxs (G: is my DVD drive)

Restart the server

Shutdown -r

2. Install SQL 2012

Start Setup

Select Installation

Select New SQL Server stand-alone installation

Accept the License terms

Select SQL Server Feature installation so that you can choose which components to install

We require the following components for an SCCM deployment

Database Engine Services
Reporting Services - Native
Management Tools - Complete

Choose Default Instance and SQL Program Files location

Choose Service Accounts - I have chosen Local System Accounts but it is generally best practice to use domain service accounts (must have rights to create SPN in Active Directory)