March 29, 2017

System Center 16 Labs - Install and Configure SQL Server 2016

After finished Configure Active directory on Windows server 2016, next step is installing SQL Server 2016 for System Center Configuration Manager 16. SQL Server 2016 for back end or Database server stores a data user, computer, software and  etc.

This is step-by-step SQL Server 2016 installation :

1. Add .Net Framework 3.5

.Net Framework 3.5

2.  Create ConfigMgr Group using Active Directory Users and Computer

Group for System Center ConfigMgr 16

Create group ConfigMgr to manage database server and SCCM 16 administrator.

3. Open SQL Server 2016 and run Setup.exe

SQL Server 2016

launching setup.exe for sql server, we used Softawre evaluation from Microsoft.

4. Menu Feature Selection

Select Database Engine Service and Reporting Service - Native in menu Feature Selection.

5. Server Configuration

SQL Service User

In Server Configuration Menu, put an SQL User. In this step, we need create user dedicated for SQL Server, sql_svc. Next, running step by step until Press button install release. For Detail SQL Server Configuration 

Previous Post
Next Post

post written by: