Deploying SQL Server 2016 for System Center Configuration Manager 2016

Before performing System Center Configuration Manager 2016 installation, you have to first of all install SQL 2016.

To install SQL 2016, mount the SQL Server 2016 ISO and run Setup.exe

SQL Server Installation Center page will open.

101418_1848_DeployingSQ1.png

101418_1848_DeployingSQ2.png

101418_1848_DeployingSQ3.png

Click on Installation option.

Click the New SQL Server stand-alone installation or add features to an existing installation link.

101418_1848_DeployingSQ4.png

Enter the product key or use evaluation edition and click Next to continue.

101418_1848_DeployingSQ5.png

Click I accept the license terms and click Next.

101418_1848_DeployingSQ6.png

Select Microsoft Update if you wish and click Next.

101418_1848_DeployingSQ8.png

For Global Rules rule check begin;

Acknowledge the prerequisites and click Next.

101418_1848_DeployingSQ9.png

Select the following features:

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

 

Then click Next

101418_1848_DeployingSQ10.png

101418_1848_DeployingSQ11.png

For Instance, Configuration, you may use Default Instance or create new Named Instance. Click Next;

101418_1848_DeployingSQ12.png

For Server Configuration enter Services Accounts with passwords. Go to Collation tab;

101418_1848_DeployingSQ13.png

You must use SQL_Latin1_General_CP1_CI_AS. Click Next;

101418_1848_DeployingSQ14.png

For Database Engine Configuration in Server Configuration tab select Windows authentication mode and add Current User, and Local Administrators Group;

101418_1848_DeployingSQ15.png

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

101418_1848_DeployingSQ16.png

Click Install on the summary screen.

101418_1848_DeployingSQ17.png

Installation begin…

101418_1848_DeployingSQ17.png

Once the installation has completed successfully click Close.

101418_1848_DeployingSQ18.png

Download the latest version that is in GA (General Availability) and run the setup file

Click Install and the installation will start.

101418_1848_DeployingSQ20.png

101418_1848_DeployingSQ21.png

Once the installation is complete click Restart.

101418_1848_DeployingSQ22.png

Now click Start > SQL Server 2016 > SQL Server Management Studio and ensure it opens correctly and can connect to your SQL Instance.

 On the Connect to Server screen click Connect.

101418_1848_DeployingSQ23.png

You can see here everything is fine.

101418_1848_DeployingSQ24.png

You can now use this SQL Server to install your System Center products.

 

One thought on “Deploying SQL Server 2016 for System Center Configuration Manager 2016

  1. I loved as much as you’ll receive carried out right here. The sketch is tasteful, your authored subject matter stylish. nonetheless, you command get got an shakiness over that you wish be delivering the following. unwell unquestionably come further formerly again as exactly the same nearly very often inside case you shield this increase.

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s