SCCM SQL Server 2016 配置管理器.
1. Log in to your system with SQL Server;
2. 去 All programs, find and start SQL服务器 2016 配置管理器;
3. 在打开的控制台中转到 SQL Server Network Configuration\Protocols for <your instance name> (作为例子 Protocols for SCCM);
4. 鼠标右键 点击 TCP/IP 然后单击 特性;
5. 去 IP Addresses For all 知识产权(X) 和 IPAll, where you have IP Address, clear TCP Dynamic Ports and enter to TCP Port you’re <SCCM SQL Port> (就我而言 14331). 点击 好的;
6. 在弹出的窗口中点击 好的;
7. For changes to apply we need to restart services. Go to SQL Server Services, select SQL Server (<your instance name>) and click the button (看截图);
8. Restarting begins.
When complete – close the console. 就这样!