Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

SQL Server 2016 config Configuration Manager for SCCM

SQL Server 2016 Config Configuration Manager for SCCM. For successful SCCM installation, 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 Configuration Manager“. Run it;

2. Go to “Protocols for ” (in my case “SCCM“). Double-click on “TCP/IP“;

3. Select “IP Addresses“;

4. Set in “IP1” and “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. Go to “SQL Server Services“;

8. Select “SQL Server ()” and restart services;



This post first appeared on Microsoft, IT, System Center, Infrastructure, please read the originial post: here

Share the post

SQL Server 2016 config Configuration Manager for SCCM

×

Subscribe to Microsoft, It, System Center, Infrastructure

Get updates delivered right to your inbox!

Thank you for your subscription

×