SCCM Erro 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
Solução
1. Open SQL Server Configuration Manager. Clique em 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.