Installing SQL Server 2016 for Configuration Manager Deployment

Покрокова інструкція: Installing SQL Сервер 2016 для Менеджер конфігурації Deployment.

Some Preparation:

• встановити .Net 3.5 Feature (with Server Manager or with PowerShell, I choose PowerShell)

Install-WindowsFeature Net-Framework-Core

• Create rules in Windows Firewall для 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 (додати) two disks (1 для SCCM DATA DBs and 1 for Temp DBs);
• Create some folders in SCCM-DATA;

• встановити SQL Management Studio (Management Studio doesn’t include in SQL Сервер 2016 installation).

Installation

1. Mount *.iso or insert DVD з 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 Далі (or you may choose Evaluation version);

4. для License Terms read and accept (by settings check mark I accept the license terms) the license terms, натисніть Далі;

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) і натисніть Далі;

7. In my case, it finds some updates, I select it and click Далі;

8. Wait to check Install Setup Files;

9. для Install Rules Windows Firewall Warning state normal, натисніть Далі;

10. For Feature Selection вибрати Database Engine Services, Full-Text and Semantic Extractions for Search і Reporting Services;

11. Також, as you see, there are no Management Tools. Натисніть Далі;

12. для Instance Configuration, you may use Default Instance або (like I do) create a new Named Instance. Натисніть Далі;

13. для Server Configuration введіть Services Accounts with passwords. Go to the Collation tab;

14. You must use SQL_Latin1_General_CP1_CI_AS. Натисніть Далі;

15. для Database Engine Configuration у the Server Configuration tab вибрати вікна authentication mode and add Current User, і Local Administrators Group;

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

17. для TempDB you also may change Directories and make some configurations. When complete, натисніть Далі;

18. для Reporting Services Configuration choose to Install only, we configure it later. Натисніть Далі;

19. для Ready to Install check yourself and click встановити;

20. Installation begins;

21. для Complete натисніть Закрити and reboot the system;