In this Step-by-Step guide, we Install Sql Server 2016 for SCCM deploy. I install SQL Server 2016 Standard with latest updates.
Some Preparation:
- Install .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 in 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;
- Also, I create (add) two disks (1 for SCCM DATA DB’s and 1 for Temp DB’s);
- Create some folders in SCCM-DATA;
- Install SQL Management Studio (Management Studio doesn’t include in SQL Server 2016 installation).
Installtion:
- Mount *.iso or insert DVD with SQL Server distributive. Go to SQL folder and run the setup.exe with Run as administrator;
2. For Installation click on New SQL server standalone installation or add features to an existing installation;
3. For Product Key enter your product key and click Next (or you may choose Evaluation version);
4. For License Terms read and accept (by settings check mark I accept the license terms) the license terms, click Next;
5. For Global Rules rule check begin;
6. For Microsoft Update, if you have internet connection, set check mark Use Microsoft Update to check for updates (recommended) and click Next;
7. In my case, it finds some updates, I select it and click Next;
8. Wait for check Install Setup Files;
9. For Install Rules Windows Firewall Warning state normal, click Next;
10. For Feature Selection select Database Engine Services, Full-Text and Semantic Extractions for Search and Reporting Services;
11. Also, as you see, there is no Management Tools. Click Next;
12. For Instance Configuration, you may use Default Instance or (like I do) create new Named Instance. Click Next;
13. For Server Configuration enter Services Accounts with passwords. Go to Collation tab;
14. You must use SQL_Latin1_General_CP1_CI_AS. Click Next;
15. For Database Engine Configuration in Server Configuration tab select Windows authentication mode and add Current User, and Local Administrators Group;
16. In Data Directories, you may change directories path (like I do);
17. For TempDB you also may change Directories and make some configurations. When complete, click Next;
18. For Reporting Services Configuration choose Install only, we configure it later. Click Next;
19. For Ready to Install check yourself and click Install;
20. Installation begin;
21. For Complete click Close and reboot system;
The post SQL Server 2016 Install Step-by-Step for SCCM appeared first on Enterinit - enter in Microsoft IT world.
This post first appeared on Microsoft, IT, System Center, Infrastructure, please read the originial post: here