Thursday, June 4, 2026

Administration site require SQL SERVER TCP is enabled and set to static port

Issue Reported:

While installing SCCM 1606 Getting error : Configuration Manager primary site and central administration site require SQL Server Tcp is enabled and set to Static port.

Below error in ConfigMgrPrereq.log :-

Solution:

Open SQL Server configuration Manager  and Click on Sql Server Network Configuration –  Double Click on TCP/IP

On properties tab drag down till IP all and Remove TCP Dynamic Ports all entry as below screen shoot.

After performing above  SCCM 1606 Prerequisite check get pass successfully.

Happy Learning!!!!

Thanks&regards,
Haresh Hirani
Email: [email protected], [email protected]
Facebook https://www.facebook.com/Hiraniconfigmgr-120189361980772/
Follow us: https://www.linkedin.com/in/hiraniconfigmgr 
Twitter: https://twitter.com/hiraniconfigmgr

Author

  • Hi, I’m Haresh Hirani the mind behind Hiraniconfigmgr.com. I’m a seasoned IT professional with deep expertise in Microsoft technologies, especially in Configuration Manager (ConfigMgr/SCCM). Over the years, I’ve expanded my skill set to cover a broader range of modern device management platforms like Microsoft Intune, Jamf Pro, ManageEngine Endpoint Central, and VMware AirWatch (Workspace ONE UEM), I use this blog to document real-world, tested, working fixes and walkthroughs from my daily technical experiences. The 💡idea is simple: if it helped me, it might help someone like you. My goal is to create a living repository of practical IT solutions for the community. If you find something useful, or if you want to collaborate, feel free to connect with me on LinkedIn or drop a message through the Contact page. Happy to help.

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Latest posts