Share via

SQL Server named instances

Vira Dual 20 Reputation points
2025-02-25T15:52:24.2166667+00:00

I want to use a named instances of SQL Server for SCCM configuration, how should I configure the port to ensure the communication between SQL Server and SCCM? Is there any guidance I can follow?

Microsoft Security | Intune | Configuration Manager | Deployment
0 comments

Answer accepted by question author

AllenLiu-MSFT 49,441 Reputation points Microsoft External Staff
2025-02-26T02:06:16.76+00:00

Hi, @Vira Dual

Thank you for posting in Microsoft Q&A forum.

By default, SQL Server named instances use dynamic ports for connections to the database engine. Configuration Manager doesn't support dynamic ports. So when you use a named instance, manually configure the static port for intrasite communication.

How to configure SQL Server to use a specific port, see Configure a server to listen on a specific TCP port.

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Add comment".

Was this answer helpful?

0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.