SCCM Error Checking the site SQL Server TCP is enabled. When trying to install KB for Configuration Manager I get this error:
[Failed]:Checking the site SQL Server Tcp is enabled and set to Static port.
SQL Server Tcp Port
解决方案
1. Open SQL Server Configuration Manager. 点击 SQL Server Network Configuration, Double Click on TCP/IP;
2. 上 IP Addresses tab drag down to IPAll and remove TCP Dynamic Ports all entries as below screenshot;
3. After removing TCP Dynamic Ports restart SQL Server Instance Service.
4. Try the installation again.