SCCM SQL Server 2016 Upravitelj konfiguracije.
1. Log in to your system with SQL Server;
2. Ići All programs, find and start SQL poslužitelj 2016 Upravitelj konfiguracije;
3. In the opened console go to SQL Server Network Configuration\Protocols for <your instance name> (as example Protocols for SCCM);
4. Desna tipka miša kliknite na TCP/IP i kliknite Svojstva;
5. Ići IP adrese For all IP(x) i IPAll, where you have IP Address, clear TCP dinamički priključci and enter to TCP Port you’re <SCCM SQL Port> (u mom slučaju 14331). Klik u redu;
6. U skočnom prozoru kliknite u redu;
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 (pogledajte snimak zaslona);
8. Restarting begins.
When complete – close the console. That’s all!