SCCM 2016 Installation – Installing SQL Server for ConfigMgr 2016

For this SCCM installation, we’ll use the latest and greatest version of SQL Server. SQL Server 2016 will be installed and configured in the NYC-SQL1 server which a standalone server joined to contoso.local domain. For this we’ll start by creating the services account in Active Directory that will be use by the SQL Server services. This is not mandatory,  but is, for sure, more secure and more easy to manage and troubleshoot any failure with regards to the database and all its related services. Also, we’ll need to enable .NET Framework 3.5 as it is a prerequsite for SQL Server 2016. So this post will look this:

•Create the SQL services account in AD
•Enable .NET Framework 3.5
•Download SQL Server 2016 binaries
•Installing SQL Server 2016
•Installing SQL Server 2016 Management Tools

SQL_Svc_Accounts

  • Enable .NET Framework 3.5

    You may enable .NET Framework by using Server Manager GUI, Windows PowerShell, or through CMD using Dism command. Let’s do it with Dism, assuming that Windows Server 2016 ISO was mounted in D: drive.

dism /online /enable-feature /featurename:NetFx3 /source:d:\sources\sxs

dism-netinstall

  • Download SQL Server 2016 binaries

You can get the binaries from here. and you’ll be propmted to download a SQLServer2016-SSEI-Eval.exe file. After running it, you’ll be guided either to install the SQL Server locally or to download the binaries if you wish to installit later on an offline device, and this what we’ll choose.

SCCM-SQL-Install-3

SCCM-SQL-Install-2

SCCM-SQL-Install

Our ISO file is now ready to be installed on NYC-SQL1.

  • Install SQL Server 2016

    OK. Everything is done with regard to the prerequisites. We’re good to go to install SQL Server 2016.

Run the setup as Administrator

SQLServerSetup

On the Installation Windows, click on Installation

SQLServerSetupClick on New SQL Server stand-alone installation or add features to an existing installation

SQLServerSetupEnter a license keyIf you don’t have one, just choose the Evaluation edition

SQLServerSetup

Accept the license terms

SQLServerSetup Have a look at on the Global Rules, and click Next

SQLServerSetup Not mandatory, but it is absolutely recommended to install any update before going through the actual installation.

SQLServerSetup Click Next to install the available updates

SQLServerSetupThe installation window will display any error encountered during the prerequisites checking. There is one Warining related to firewall. In our case, the firewall is disabled, but you need to make sure that any ports used by SQL Server is open in your environment. To get more information about this, have a look on this MSDN article.SQLServerSetup

Choose the SQL Instance Features to install. A default installation with Database Engine Service, Reporting Sertvces and Management Tools – Basic will be sufficient. So check the following:

-Database Engine Service

Full-Text and Semantic Extractions for Search

-Reporting Services – Native

SQLServerSetup

 

As you might notice, there is no more from SQL Server Management Studio from the main installation of SQL Server. The goal behind this is that Microsoft is pushing DB admins not to use the DB server to manage the database. You should, instead, manage your servers remotely. In addition, separating SSMS from the main installer helps Microsoft to update the tools on a faster way. Having said that, you’ll not be surprised now not to see the Management Studio at the end of the installation. No worries, we’ll install it on our management station NYC-WKS1, just after finishing the installation of SQL Server.

On the Server Configuration window, map the Service Accounts previously created to each SQL Server service. Do not click “Next”, as you need to choose the right collation from the Collation tab on the same window. Not doing so will result to failed SCCM installation.

Click on Colation tab and choose SQL_Latin1_General_CP1_CI_AS

SQLServerSetup SQLServerSetup

SQLServerSetup

SQLServerSetup

For a safer configuration, Choose the Windows authentication mode. You may specify some users that will have the admin privilege on the instance, by clicking on Add then choosing the privileged users.

SQLServerSetup

On Reporting Services Configuration window, no need to any configuration so we’ll install only and click on Next

 

SQLServerSetup

Looks fine. Click on Next then Install

SQLServerSetup

SQLServerSetup

SQLServerSetup

OK, We’ll go ahead and restart our NYC-SQL1 server. After the restart, it will be ready!

SQLServerSetup

Once the server is restarted, we need to open up SSMS (SQL Server Manegement Studio) and limit the amount of RAM SQL can use to 50{52ac628948805575fbf86bfc01ab08df891abc993ffc55505884be7242371b08} of total RAM. Set the value for both max and min. For this, just remember that you do not have any way to administer your freshly SQL instance, this is wahy you’ll need to have SSMS installed either on this server or any other workstation that access to it.

  • Installing SQL Server 2016 Management Tools

 

Let’s do install SSMS on our Windows 10 workstation named NYC-WKS1.

Launch the SQL Server Installer, click on Installation, then on Install SQL Server Management Tools

SQLServerSSMSSetup

This will take you to the MSDN web page to download SQL Server Management Studio (SSMS).

SQLServerSSMSDownloadPage

After the download is completed you can run the installation on another device without a connection to Internet. The rest of the steps is pretty easy. The installation process will install the .NET Framework 4.6.1 as well as the Visual Studio 2015 Shell, as shown below.

 

SQLServerSSMSSetup SQLServerSSMSSetup

SQLServerSSMSSetup

Once the SSMS installation is finished, the last step to do is to limit the amount of RAM SQL can use to 50{52ac628948805575fbf86bfc01ab08df891abc993ffc55505884be7242371b08} of total RAM.

SQLServerMemConfig

SQLServerMemConfig

SQLServerMemConfig

Our NYC-SQL1 server has 8GB of RAM, so we’ll limit the memory to 4GB.

SQLServerMemConfig

 

SQL Server is installed now, a default instance is now ready to host the SCCM database that will be populated during the installation of ConfigMgr 2016.

 

 

Previous: System Center Configuration Manager 2016 Installation Guide Next: Preparing the Prerequisites to Install Configuration Manager 2016

 

 

Find this post interesting. Share it!