Průvodce krok za krokem: Instalace SQL Serveru 2016 pro nasazení Configuration Manager.
Some Preparation:
- Nainstalujte .Net 3.5 Vlastnosti (with Server Manager or with PowerShell, vybírám si 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, taky, 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;
- Taky, I create (add) two disks (1 for SCCM DATA DBs and 1 for Temp DBs);
- Create some folders in SCCM-DATA;
- Nainstalujte SQL Management Studio (Management Studio doesn’t include in SQL Server 2016 instalace).
Instalace
- Mount *.iso or insert DVD with SQL Server distributive. Go to the SQL folder and run the setup.exe with Spustit jako administrátor;
2. Pro Instalace klikněte na New SQL server standalone installation or add features to an existing installation;
3. Pro Product Key enter your product key and click další (or you may choose Evaluation verze);
4. Pro License Terms read and accept (by settings check mark Souhlasím s licenčními podmínkami) the license terms, klikněte další;
5. Pro Global Rules rule check begin;
6. Pro Microsoft Update, if you have an internet connection, set the checkmark Use Microsoft Update to check for updates (doporučeno) a klikněte další;
7. V mém případě, it finds some updates, I select it and click další;
8. Wait to check Install Setup Files;
9. Pro Install Rules Brána firewall systému Windows Varování state normal, klikněte další;
10. For Feature Selection vybrat Služby databázového stroje, Full-Text and Semantic Extractions for Search a Reporting Services;
11. Taky, as you see, there are no Management Tools. Klikněte další;
12. Pro Instance Configuration, you may use Default Instance nebo (like I do) create a new Named Instance. Klikněte další;
13. Pro Konfigurace serveru vstoupit Services Accounts with passwords. Jít do the Collation tab;
14. You must use SQL_Latin1_General_CP1_CI_AS. Klikněte další;
15. Pro Database Engine Configuration v the Server Configuration tab vybrat Windows authentication mode and add Current User, a Local Administrators Group;
16. v Datové adresáře, you may change the directories path (like I do);
17. Pro TempDB you also may change Directories and make some configurations. Po dokončení, klikněte další;
18. Pro Konfigurace Reporting Services choose to Pouze nainstalovat, konfigurujeme později. Klikněte další;
19. Pro Ready to Install check yourself and click Nainstalujte;
20. Instalace začíná;
21. Pro Complete klikněte Zavřít 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živatelé” or create some hierarchy, like I