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 –> 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.

tcp-ip

Happy Learning!!!!

Thanks & Regards,
Haresh Hiran




You may also like

CMinfra_13_SQL Server Configuration Manager 2012 Starting getting error

SQL Server Configuration Manager 2012 Starting getting error.

  • 29-07-2017
CMInfra_02_SCCM 2012 R2 SQL DB migration

SCCM 2012 R2 SQL DB migration.

  • 03-04-2019
CMInfra_71_SCCM Primary Site Database file rapid growth than Normal

SCCM Primary Site Database file rapid growth than Normal.

  • 01-08-2019
CMInfra_73_Failed to decrypt SQL Server machine serialized pfx certificate LastError=0

Failed to decrypt SQL Server machine serialized pfx certificate LastError=0.

  • 05-09-2019

0 Comments

    No Comments

Leave a Comment


About Author

  • Thank you for visiting ! Here is all about Microsoft technologies. More about ConfigMgr and all other tec... Read More