MaAtToOs: Installing SQL 2016 with SP1 for System Center 2016 (Standalone SQL Server + Reporting Services)

Installing SQL 2016 with SP1 for System Center 2016 (Standalone SQL Server + Reporting Services)

In this guide, I will go through the installation of SQL Server 2016 with SP1. This can be a separate standalone server or could be collocated with the System Center product for smaller installations or Dev/Test/POC environments.

For example:

This guide is suitable for:

System Center Operations Manager 2016
System Center Configuration Manager 2016
System Center Virtual Machine Manager 2016
System Center Orchestrator Manager 2016
System Center Service Manager 2016

Prerequisites

Create a Service Account in Active Directory, it doesn’t need any special permissions. In this article it will be called Srv-SQL

I have a Server 2016 machine joined to the domain with a static IP Address called CC-HO-SQL1. We will be installing SQL Server 2016 Standard Edition with SP1.

The Installation

Insert the SQL Server Media.

Click Install and then click New SQL Server stand-alone installation or add features to an existing installation

Enter your Product Key or click Specify a free edition for a 180 free trial

Click I accept the licence terms and click Next

Select Microsoft Update if you wish and click Next

Acknowledge the prerequisites and click Next.

(Note: You may need to open up the SQL ports in the Windows Firewall depending on your environment. Use this guide if necessary https://technet.microsoft.com/en-GB/library/ms175043(v=sql.110).aspx)

Select the following features:

Database Engine Services
Full-Text and Semantic Extractions…..
Report Services – Native

Then click Next

On the Instance Configuration screen you may change the Instance Name if you wish to something like SCOM but MSSQLSERVER is more than suitable. Click Next

Now enter your SQL Service Account details

They should look like this, note set the SQL Server Agent to Automatic. Once complete click the Collation tab.

Click Customize

Click the SQL collation, used for backwards compatibility radio button and select SQL_Latiin1_General_CP1_CI_AS Collation and click OK

Click Next

On the Database Engine Configuration screen click Add Current User and then click Add… and enter your SQL Service Account from AD.

You can also change the Database and Log file locations by clicking the Data Directories Tab if you wish. Once done click Next

On the Reporting Services Configuration Screen ensure Install and configure is selected and click Next

Click Install on the summary screen

Once the installation has completed successfully click Close

For those of you who are “Eagle Eyed” you may of noticed we didn’t install the SQL Server Management Studio. This is because its now a separate download and installer for SQL Server 2016. Open your favourite browser and navigate to https://msdn.microsoft.com/en-us/library/mt238290.aspx. Download the latest version that is in GA (General Availability) and run the setup file.

Click Install and the installation will start