SQL 服务器 2016 配置 配置管理器 为了 SCCM. For successful SCCM 安装, we need to reconfigure the “SCCM SQL 实例” to use another port for communication (从 dynamic set to 14331). You can do it in another way and use dynamic ports, as you wish.
1. Left Mouse Button click on the “Start” button and find in the apps list “SQL 服务器 2016 配置管理器“. Run it;
2. 转到“Protocols for <Instance Name>” (in my case “SCCM“). Double-click on “TCP/IP“;
3. Select “IP Addresses“;
4. Set in “IP1“ 和 ”IP2“:
- TCP Dynamic Ports – blank;
- TCP Port – your port (in my case 14331).
5. Set “IPAll”. 单击“好的“ 按钮;
6. In the pop-up window click the “好的“ 按钮;
7. 转到“SQL Server Services“;
8. Select “SQL 服务器 (<your instance name>)” and restart services;
