Installing SQL Server 2016 for Configuration Manager Deployment

Step-by-Step Guide: Installing SQL Server 2016 for Configuration Manager Deployment.

Some Preparation:

• 설치하다 .Net 3.5 Feature (with Server Manager or with PowerShell, I choose 파워셸)

Install-WindowsFeature Net-Framework-Core

• Create rules in Windows Firewall for SCCM connection (I use static port 14331 for DB and 8080 for reporting, also, I’m added standard TCP and UDP ports);
• Create an Active Directory 3 service accounts:

sqlsccmagent – sql agent

sqlsccmsvc – sql service

sqlsccmrep – sql reporting services

• Add all 3 accounts to Local Group Administrators on SQL system;

• 또한, I create (add) two disks (1 for SCCM DATA DBs and 1 for Temp DBs);
• Create some folders in SCCM-DATA;

• 설치하다 SQL Management Studio (Management Studio doesn’t include in SQL Server 2016 installation).

Installation

1. Mount *.ISO or insert DVD with SQL Server distributive. Go to the SQL folder and run the setup.exe with 관리자로 실행;

2. 을 위한 Installation click on New SQL server standalone installation or add features to an existing installation;

3. 을 위한 Product Key enter your product key and click Next (or you may choose Evaluation 버전);

4. 을 위한 License Terms read and accept (by settings check mark I accept the license terms) the license terms, click Next;

5. 을 위한 Global Rules rule check begin;

6. 을 위한 Microsoft Update, if you have an internet connection, set the checkmark Use Microsoft Update to check for updates (recommended) 그리고 클릭 Next;

7. 제 경우에는, it finds some updates, I select it and click Next;

8. Wait to check Install Setup Files;

9. 을 위한 Install Rules Windows Firewall Warning state normal, click Next;

10. For Feature Selection select Database Engine Services, Full-Text and Semantic Extractions for Search 그리고 Reporting Services;

11. 또한, as you see, there are no Management Tools. Click Next;

12. 을 위한 Instance Configuration, you may use Default Instance or (like I do) create a new Named Instance. Click Next;

13. 을 위한 Server Configuration enter Services Accounts with passwords. 가십시오 the Collation tab;

14. You must use SQL_Latin1_General_CP1_CI_AS. Click Next;

15. 을 위한 Database Engine Configuration in the Server Configuration tab select Windows authentication mode and add Current User, 그리고 Local Administrators Group;

16. ~ 안에 Data Directories, you may change the directories path (like I do);

17. 을 위한 TempDB you also may change Directories and make some configurations. When complete, click Next;

18. 을 위한 Reporting Services Configuration choose to Install only, we configure it later. Click Next;

19. 을 위한 Ready to Install check yourself and click 설치하다;

20. Installation begins;

21. 을 위한 Complete click 닫다 and reboot the system;