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
Solution
1. Open SQL Server Configuration Manager. Click on SQL Server Network Configuration, Double Click on TCP/IP;
2. On the 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.
