Configuration Manager 2012 setup error, Setup is unable to connect to SQL Server with the connection information provided


Configuration Manager 2012 Setup error :                                                                                                                                                                                                                                                                                                                                                                                    Setup is unable to connect to SQL Server with the connection information provided

You have already verified that all SQL and SCCM prerequisites are in place and next when you run setup you get the followng error:

The possible cause for this error can be because of the following:

  • During the SQL install, you created a named instance that you want to use for SCCM
  • You have a default SQL instance installed and you created another named instance  that you want to use for SCCM

The reason for this error is because Configuration Manager 2012, does not support dynamic ports, so you need to go to SQL Server Configuration Manager and set that named instance to use the static Port and restart the SQL Server Service.

 Here are some more details on this:

Creating a named instance is fine, and I personally  prefer using named instance as a better isolation.

When you install SQL and you create a default instance, it automatically assigns a static TCP Port 1433 for this, and if you create another named instance or you installed SQL with a named instance instead of a default instance, In this case the named instances are  configured for dynamic ports by default during installation. 

 As you can see in example below, for named instance SCCM_DB1, under “TCP/IP properties” a TCP Dynamic Port 50705”  for “IP All” and  Dynamic Port 0″ for other IP’s was assigned. You can check this configuration by going to “SQL Server Network Configuration->Protocols for Named_Instance (the sql instance name you gave)->TCP/IP->IP addresses

 

To fix this issue, do  the following changes under SQL Server Network Configuration->Protocols for Named_Instance (the sql instance name you gave)->TCP/IP->IP addresses 

  • Delete 0 or any other port number e.g 50705  from “TCP Dynamic Ports” Dialog box, Do this for all IP’s e.g for “IPAll”, “IPV6” , basically do this for each ip address listed in “IP Address” tab under  “TCP/IP Properties”
  • Next in the “TCP Port” dialog box  assign a static port for all IP’s that contain IP address of your sql server the named instance
  • Under “SQL Server Configuration manager->SQL Server Services” Restart the service “SQLServer (instance Name)” and ensure  “SQL Browser” service is running

For more details on  how to configure a SQL server to listen on a specific TCP port see  http://msdn.microsoft.com/en-us/library/ms177440.aspx

 DISCLAIMER: This posting is provided “AS IS” with no warranties and confers no rights 


Comments (13)

  1. Glenn Wilson says:

    Why not just enable the SQL Browser service and let it handle the redirection like it is designed to?

  2. From/for SCCM 2012 to connect to named instance, you need to have a static port for that named instance and SQL Browser running to find that named instance

  3. Tabish Ansari says:

    Exactly, we need

    – Dedicated SQL instance

    – Named instance mapped on static port

    – SQL Browser service should be ruuning

  4. César Alvarado says:

    Great. This procedure fix the problem. Thanks a lot.

  5. Yash says:

    Hi It works, After i remove all dynamic ports and restart the service 🙂

  6. John says:

    Thanks for this fix! Being relatively new to databases and SQL in particular, this saved me a lot of trouble.

  7. Nice tips says:

    I was trying to migrate de SQL database of SCCM 2012 to another SQL Server and I was facing this problem. SCCM doesn´t work with TCP Dynamic ports. Changing the ports manually finally solve the problem. Thanks very much.

  8. TBailey says:

    But what if that still doesn't help?

    How can I tell which of the four problems is actually holding up the install?

    I have checked everything I can think of.

  9. Rodrigo Oleriano says:

    very helpful article! good job

  10. Gman says:

    Great tip thanks

  11. Faheem Kazi says:

    Thank it resolved my problem.

  12. bruce says:

    Great Post! Solution resolve my problem! Thx

  13. Nurul says:

    After doing this step, I’m still got the same error. Please HELP!!!

    Thanks