Przewodnik krok po kroku: Installing SQL Server 2016 for Configuration Manager Deployment.
Some Preparation:
- Zainstalować .Net 3.5 Feature (with Server Manager or with PowerShell, wybieram 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;
- Również, I create (dodać) two disks (1 for SCCM DATA DBs and 1 for Temp DBs);
- Create some folders in SCCM-DATA;
- Zainstalować SQL Management Studio (Management Studio doesn’t include in SQL Server 2016 instalacja).
Installation
- Mount *.iso or insert płyta DVD with SQL Server distributive. Go to the SQL folder and run the setup.exe with Run as administrator;
2. Dla Installation Kliknij New SQL server standalone installation or add features to an existing installation;
3. Dla Product Key enter your product key and click Next (or you may choose Evaluation wersja);
4. Dla License Terms read and accept (by settings check mark Akceptuję warunki licencji) the license terms, trzask Next;
5. Dla Global Rules rule check begin;
6. Dla Microsoft Update, if you have an internet connection, set the checkmark Use Microsoft Update to check for updates (recommended) and click Next;
7. W moim przypadku, it finds some updates, I select it and click Next;
8. Wait to check Install Setup Files;
9. Dla Install Rules Firewall Windows Warning state normal, trzask Next;
10. For Feature Selection select Database Engine Services, Full-Text and Semantic Extractions for Search I Reporting Services;
11. Również, as you see, there are no Management Tools. Trzask Next;
12. Dla Instance Configuration, you may use Default Instance Lub (like I do) create a new Named Instance. Trzask Next;
13. Dla Server Configuration enter Services Accounts with passwords. Idź do the Collation tab;
14. You must use SQL_Latin1_General_CP1_CI_AS. Trzask Next;
15. Dla Database Engine Configuration in the Server Configuration tab select Windows authentication mode and add Current User, I Local Administrators Group;
16. In Data Directories, you may change the directories path (like I do);
17. Dla TempDB you also may change Directories and make some configurations. When complete, trzask Next;
18. Dla Reporting Services Configuration choose to Install only, we configure it later. Trzask Next;
19. Dla Ready to Install check yourself and click Zainstalować;
20. Installation begins;
21. Dla Complete trzask Zamknąć and reboot the system;
Thank you for the article. I get to the part about adding the three accounts and I do not have the services container. I am not able to find much information on it. I ran adprep again thinking it might add it but it did not. Is this container built by default in AD?
AD container “Service accounts” and sub-container “SQL” not exist by default. You can create service accounts in OU “Użytkownicy” or create some hierarchy, like I