SCCM SQL Server 2016 Configuratiemanager.
1. Log in to your system with SQL Server;
2. Gaan naar All programs, find and start SQL-server 2016 Configuratiemanager;
3. In the opened console go to SQL Server Network Configuration\Protocols for <your instance name> (as example Protocols for SCCM);
4. Rechtermuisknop klik op TCP/IP en klik Eigenschappen;
5. Gaan naar IP Addresses For all IP(X) En IPAll, where you have IP Address, clear TCP Dynamic Ports and enter to TCP Port you’re <SCCM SQL Port> (in my case 14331). Klik OK;
6. In the pop-up window click OK;
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 (see screenshot);
8. Restarting begins.
When complete – close the console. That’s all!
