Installing SQL Server 2016 for Configuration Manager Deployment

Guida passo passo: Installing SQL Server 2016 for Configuration Manager Deployment.

Some Preparation:

• Installare .Net 3.5 Feature (with Server Manager or with PowerShell, I choose PowerShell)

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;

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

• Installare SQL Management Studio (Management Studio doesn’t include in SQL Server 2016 installazione).

Installazione

1. Mount *.iso or insert DVD with SQL Server distributive. Go to the SQL folder and run the setup.exe with Esegui come amministratore;

2. Per Installazione fare clic su New SQL server standalone installation or add features to an existing installation;

3. Per Product Key enter your product key and click Prossimo (or you may choose Evaluation versione);

4. Per License Terms read and accept (by settings check mark I accept the license terms) the license terms, clic Prossimo;

5. Per Global Rules rule check begin;

6. Per Microsoft Update, if you have an internet connection, set the checkmark Use Microsoft Update to check for updates (recommended) e fare clic Prossimo;

7. Nel mio caso, it finds some updates, I select it and click Prossimo;

8. Wait to check Install Setup Files;

9. Per Install Rules Windows Firewall Warning state normal, clic Prossimo;

10. For Feature Selection selezionare Database Engine Services, Full-Text and Semantic Extractions for Search E Reporting Services;

11. Anche, as you see, there are no Management Tools. Clic Prossimo;

12. Per Instance Configuration, puoi usare Default Instance O (like I do) create a new Named Instance. Clic Prossimo;

13. Per Server Configuration entrare Services Accounts with passwords. Vai a the Collation tab;

14. You must use SQL_Latin1_General_CP1_CI_AS. Clic Prossimo;

15. Per Database Engine Configuration In the Server Configuration tab selezionare Windows authentication mode and add Current User, E Local Administrators Group;

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

17. Per TempDB you also may change Directories and make some configurations. Quando completo, clic Prossimo;

18. Per Reporting Services Configuration choose to Install only, we configure it later. Clic Prossimo;

19. Per Ready to Install check yourself and click Installare;

20. Inizia l'installazione;

21. Per Complete clic Vicino and reboot the system;