分步指南: Installing SQL 服务器 2017 for System Center Orchestrator 2016.
笔记: This is a LAB installation, don’t repeat it in production!
Some preparation:
- I create 2 service accounts for SQL 服务器 (sql01svc 和 sql01agent) 在 活动目录, 添加 sql01svc to Administrators security group;
- Create a separate logical disk for SQL Server databases.
Installation process
- 开始 SQL 2017 安装;
2. 导航至 安装并选择新的 SQL Server stand-alone installation…;
3. Choose edition and click 下一个;
4. Read and accept license terms, 点击 下一个;
5. In my case and don’t select Update check, click N分机;
6. There is now Internet on this machine so the 错误 is normal, 点击 下一个;
7. As you may see there is now no .Net 3.5 requirement 再过了, 点击 下一个;
8. Select the feature that you need, 点击 下一个;
9. 选择 Default instance or create Named, 点击 下一个;
10. Enter your service accounts for services and navigate to the Collation 选项卡;
11. Ensure that the collation is SQL_Latin1_General_CP1_CI_AS, 然后单击 下一个;
12. 添加 SQL Server administrators 并导航至 the Data Directories 选项卡;
13. You can change paths (like I) or leave by default, 导航到 the TempDB 选项卡;
14. 改变 Directories or leave by default and click N分机;
15. When ready, 点击 安装;
16. When the installation completes, 点击 关闭;
笔记: Don’t forget to change the SQL port from dynamic to static and open it on Windows 防火墙, 并安装 SQL 管理工作室 on some machines.
