SCCM Erro Checking the site SQL Server TCP is enabled. When trying to install KB for Gerenciador de configuração I get this erro:
[Failed]:Checking the site SQL Server Tcp is enabled and set to Static port.
SQL Servidor Tcp Port
Solução
1. Open SQL Server Gerenciador de configuração. 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.