Installing SQL Server 2016 for Configuration Manager Deployment

分步指南: Installing SQL 服务器 2016 为了 配置管理器 Deployment.

Some Preparation:

• 安装 .Net 3.5 特征 (with Server Manager or with 电源外壳, 我选择 电源外壳)

Install-WindowsFeature Net-Framework-Core

• Create rules in Windows 防火墙 为了 SCCM connection (I use static port 14331 for DB and 8080 for reporting, also, I’m added standard TCP and UDP ports);
• Create an 活动目录 3 service accounts:

sqlsccmagent – sql agent

sqlsccmsvc – sql 服务

sqlsccmrep – sql reporting services

• Add all 3 accounts to Local Group Administrators 在 SQL 系统;

• 还, I create (添加) two disks (1 为了 SCCM DATA DBs and 1 for Temp DBs);
• Create some folders in SCCM-DATA;

• 安装 SQL Management Studio (管理工作室 doesn’t include in SQL 服务器 2016 安装).

安装

1. 山 *.异 or insert DVD 和 SQL Server distributive. Go to the SQL folder and run the setup.exe with 以管理员身份运行;

2. 为了 安装 点击 新的 SQL server standalone installation or add features to an existing installation;

3. 为了 Product Key enter your product key and click 下一个 (or you may choose Evaluation 版本);

4. 为了 License Terms read and accept (by settings check mark 我接受许可条款) the license terms, 点击 下一个;

5. 为了 Global Rules rule check begin;

6. 为了 Microsoft Update, if you have an internet connection, set the checkmark Use Microsoft Update to check for updates (recommended) 然后单击 下一个;

7. 就我而言, it finds some updates, I select it and click 下一个;

8. Wait to check Install Setup Files;

9. 为了 Install Rules Windows 防火墙 Warning state normal, 点击 下一个;

10. For Feature Selection 选择 Database Engine Services, Full-Text and Semantic Extractions for Search 和 Reporting Services;

11. 还, as you see, there are no Management Tools. 点击 下一个;

12. 为了 Instance Configuration, you may use Default Instance 或者 (like I do) create a new Named Instance. 点击 下一个;

13. 为了 Server Configuration 进入 Services Accounts with passwords. 前往 the Collation tab;

14. You must use SQL_Latin1_General_CP1_CI_AS. 点击 下一个;

15. 为了 Database Engine Configuration 在 the Server Configuration tab 选择 视窗 authentication mode and add Current User, 和 Local Administrators Group;

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

17. 为了 TempDB you also may change Directories and make some configurations. 完成后, 点击 下一个;

18. 为了 Reporting Services Configuration choose to Install only, we configure it later. 点击 下一个;

19. 为了 Ready to Install check yourself and click 安装;

20. Installation begins;

21. 为了 Complete 点击 关闭 and reboot the system;