By using this site, you agree to the Privacy Policy.
Accept
EnterinITEnterinITEnterinIT
  • HOME
  • IT PRO
  • TECH
  • MICROSOFT
    • Azure
    • ConfigMgr/SCCM
    • DPM
    • Orchestrator
    • Hyper-V
    • Microsoft Edge Insider
    • MSI
    • Office 365
    • Office Insider
    • Power BI
    • Skype
    • SQL Server
    • Teams
  • WINDOWS
    • Windows Admin Center
    • Windows Client
    • Windows Server
  • SCCM Query Collection List
Reading: SQL Server 2016 config Configuration Manager for SCCM
Font ResizerAa
EnterinITEnterinIT
Font ResizerAa
  • HOME
  • IT PRO
  • TECH
  • MICROSOFT
  • WINDOWS
  • SCCM Query Collection List
Search
  • HOME
  • IT PRO
  • TECH
  • MICROSOFT
    • Azure
    • ConfigMgr/SCCM
    • DPM
    • Orchestrator
    • Hyper-V
    • Microsoft Edge Insider
    • MSI
    • Office 365
    • Office Insider
    • Power BI
    • Skype
    • SQL Server
    • Teams
  • WINDOWS
    • Windows Admin Center
    • Windows Client
    • Windows Server
  • SCCM Query Collection List
ConfigMgr

SQL Server 2016 config Configuration Manager for SCCM

Published: February 5, 2024
1 Min Read
SHARE

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 <Instance Name>” (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 (<your instance name>)” and restart services;

TAGGED:Microsoft SQL ServerMicrosoft Windows ServerSystem CenterSystem Center Configuration ManagerWindows
Previous Article Install SQL Server Management Studio
Next Article Configuration Manager Query Collection List Configuration Manager Technical Preview Update 1612
Leave a Comment Leave a Comment

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Translation

English中文(简体)DanskNederlandsFrançaisDeutschItaliano한국어PolskiPortuguêsRomânăEspañolУкраїнська
by Transposh - translation plugin for wordpress

Popular Posts

System Requirements for Windows Server 2016
Windows Server
Configuration Manager Query Collection List
Configuration Manager Query Collection List
ConfigMgr
Structured/Managed Navigation enabled on Modern Pages in Classic Team Sites
Tech
SCCM Failed to get DP locations as the expected version from MP
ConfigMgr

Recent Posts

Installing and Configuring Fail2ban for SSH Protection on Ubuntu 24.04
Linux
Enabling and Configuring FirewallD on AlmaLinux
Linux
User Creation and SSH Key Setup in AlmaLinux
Linux
How to reset password on AlmaLinux
Linux

© 2023 EnterinIT

Go to mobile version
Welcome Back!

Sign in to your account

Username or Email Address
Password

Lost your password?