Instalando o SQL Server 2016 para implantação do Configuration Manager

Guia passo a passo: Instalando o SQL Server 2016 para implantação do Configuration Manager.

Some Preparation:

• Instalar .Net 3.5 Recurso (with Server Manager or with PowerShell, eu escolho 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;

• Também, I create (adicionar) two disks (1 for SCCM DATA DBs and 1 for Temp DBs);
• Create some folders in SCCM-DATA;

• Instalar SQL Management Studio (Management Studio doesn’t include in SQL Server 2016 instalação).

Instalação

1. Mount *.iso or insert DVD with SQL Server distributive. Go to the SQL folder and run the setup.exe with Run as administrator;

2. Para Instalação click on New SQL server standalone installation or add features to an existing installation;

3. Para Product Key enter your product key and click Próximo (or you may choose Evaluation versão);

4. Para License Terms read and accept (by settings check mark I accept the license terms) the license terms, clique Próximo;

5. Para Global Rules rule check begin;

6. Para Microsoft Update, if you have an internet connection, set the checkmark Use Microsoft Update to check for updates (recommended) e clique Próximo;

7. In my case, it finds some updates, I select it and click Próximo;

8. Wait to check Install Setup Files;

9. Para Install Rules Firewall do Windows Warning state normal, clique Próximo;

10. For Feature Selection selecione Database Engine Services, Full-Text and Semantic Extractions for Search e Serviços de relatórios;

11. Também, as you see, there are no Management Tools. Clique Próximo;

12. Para Instance Configuration, you may use Default Instance ou (like I do) create a new Named Instance. Clique Próximo;

13. Para Server Configuration digitar Services Accounts with passwords. Go to the Collation tab;

14. You must use SQL_Latin1_General_CP1_CI_AS. Clique Próximo;

15. Para Database Engine Configuration em the Server Configuration tab selecione Windows authentication mode and add Current User, e Local Administrators Group;

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

17. Para TempDB you also may change Directories and make some configurations. When complete, clique Próximo;

18. Para Reporting Services Configuration choose to Install only, we configure it later. Clique Próximo;

19. Para Ready to Install check yourself and click Instalar;

20. Installation begins;

21. Para Complete clique Fechar and reboot the system;