Install SCCM Prerequisites – SQL Server 2016 Step-by-Step Guide

Introduction

  • Personally this was my first step before the other SCCM prerequisites which required a lot of configuration, you need an SQL Database for SCCM primarily to host your site database.
  • I am using a licensed copy of Microsoft SQL Server 2016 but you can use an evaluation version if you like, don’t use the express version (comes with the ADK Tools) if you are setting up a primary site as you cannot start the Server Agent with the Express Edition.
  • For a list of Supported SQL Server Versions for Config Mgr check here https://docs.microsoft.com/en-us/sccm/core/plan-design/configs/support-for-sql-server-versions
  • An eagle eyed reader pointed out that when you use a domain account for SQL Services you need to manually register the MSSQLvc SPN to ensure SQL Clients/Site Systems can perform Kerberos Authentication, find out more here

Instruction

  • Using your downloaded version of SQL Server 2016, Run the setup Application
  • Select the option shown below as we are going to create a new SQL Server on our intended SCCM Primary Site
  • If you have a product key then enter it, if not you are fine to use the free Evaluation edition, click Next
  • Accept the terms and click Next
  • Tick the box (Optional) if you have an internet connection to check for updates and click Next
  • If you are informed of any updates then go ahead and tick the box then click Next
  • Ensure you add the features shown which are the minimum for SCCM requirements (We also need the management tools which we will add later, you can add them from this window on other versions) and click Next
  • Create your Named Instance so i have decided to use an obvious name of SCCM, this will automatically copy the field into the Instance ID Box, click Next
  • On this window you need to assign relevent accounts to each service, i used a domain admin account i created earlier on my AD DS Server for each Service. Ensure each service is set to startup Automatically too and click Next
  • Click Customize as we want to change the Database Engine type
  • Select the SQL_Latin1_General_CP1_CI_AS collation and click OK
  • Click Next
  • Under the Server Configuration Tab, Add your assigned SQL Server Administrators and ensure you have Windows Authentication mode set using the radio button, click Next
  • Select Install and Configure and click Next
  • Click Install if you happy with your assigned settings so far
  • Once complete click Close
  • We now need to install the management tools so we can change settings such the assigned memory, go back to the SQL Server 2016 installation media and run the setup. Select Install SQL Server Management Tools which will take you to a website to download the correct version
  • Once you have downloaded the tools, run the SSMS-Setup-ENU Application
  • Click Install and within 5 minutes you have the SQL Management Studio which we need very soon
  • The Next step is to run the SQL Server Configuration Manager from the Start Menu, select SQL Server Network Configuration>Protocols for SCCM>TCP/IP and this will open a new window. From here you need to add the TCP port 1433 into each IP Address field, you may also need to open the ports in powershell using the following commands
New-NetFirewallRule -Displayname "Allow SQL port 1433" -direction inbound -LocalPort 1433 -Protocol tcp -Action allow 
New-NetFirewallRule -Displayname "Allow SQL port 4022" -direction inbound -LocalPort 4022 -Protocol tcp -Action allow
  • Now you need to change the memory settings using the SQL Management Studio from the start menu. Enter your server Authentication credentials and click Connect
  • Right click on your SQL Server and click Properties
  • Click on Memory and enter the Memory Settings as shown below, click OK and you are done. (Ensure you have at least 16GB of Memory Assigned to your VM at this point or it won’t work correctly)

Please checkout my post for the next set of SCCM Prerequisites here