Sql Server 2016 config Configuratiemanager voor SCCM. For successful SCCM installatie, we need to reconfigure the “SCCM Sql Instance” to use another port for communication (from dynamic set to 14331). You can do it in another way and use dynamic ports, as you wish.
1. Left Mouse Button click on the “Start” button and find in the apps list “Sql Server 2016 Configuratiemanager'. Run it;
2. Ga naar "Protocols for <Instance Name>” (in my case “SCCM'). Double-click on “TCP/IP';
3. Select “IP Addresses';
4. Set in “IP1" En "IP2':
- TCP Dynamic Ports – blank;
- TCP Port – your port (in my case 14331).
5. Set “IPAll”. Click the “OK” button;
6. In the pop-up window click the “OK” button;
7. Ga naar "Sql Server Services';
8. Select “Sql Server (<your instance name>)” and restart services;