Home > SCCM 2007 / 2012 > SCCM 2012: Setup is unable to connect to SQL Server

SCCM 2012: Setup is unable to connect to SQL Server

There is a big change that you catch the underneath error during your SCCM 2012 deployment:

 Setup is unable to connect to SQL Server with the connection information provided. Verify the following:

– The SQL Server and instance names are entered correctly
– The specified SQL Server instance is not configured to use dynamic ports
– If a firewall is enabled on the SQL Server, inbout rules exist to allow connections to the correct ports
– The account used to run Setup has permissions to connect to the specified SQL server instance

Open the “SQL Server Configuration manager” and Naviagte to The Protocols of your SQL Instance in the “SQL Server Network Configuration”

Enable “Named Pipes” and “TCP/IP”

Restart the SQL Service Instance within the SQL Server Services:

This seems to be a common issue during the SCCM 2012 setup:  Windows-Noobs

Verify also that you are running the one of the supported  SQL versions:

– SQL Server 2008 SP2 with Cumulative Update 9
– SQL Server 2008 SP3 with Cumulative Update 4
– SQL Server 2008 R2 with SP1 and Cumulative Update 4


Categories: SCCM 2007 / 2012
  1. a
    April 4, 2012 at 8:30 pm

    thanks you, your work around works

  2. April 23, 2012 at 10:04 am

    – Named Pipes Turned On
    – Firewall off
    – SQL inst restarted

    but i see the same error, any ideas?

  3. April 23, 2012 at 11:39 am

    Forget to say, that i`ve installed CU 4 for SQL 2008 R2 SP1

  4. Joris
    April 25, 2012 at 2:46 pm

    check the log file c:\ConfigMgrSetup.txt
    Mention the error in the log file?

    • April 26, 2012 at 4:18 am

      Thank you for you reply. The problem was in incorrect setup of TCP ports (not dynamic), after i setup it everything works fine. Thank you

  5. theNugget2010
    June 2, 2012 at 6:02 pm

    Thanks, I was tempted to switch off the firewall but read that ConfigMgr does require component to be active this to report a healthy state.

  6. July 17, 2012 at 11:12 am

    Perfect! Solved my problem, should have known it would be that! Thanks very much! 🙂

  7. Darwood
    July 17, 2012 at 10:42 pm

    I have the same issue. I have tried to install System Center 2012 but cannot get past the problem of SQL version in the log it shows version detected 10.50.2500.0. I have download service pack 1 CU 6 and installed but still no change. \

  8. osama
    September 25, 2012 at 10:09 am

    sql 2008 r2 , sp1 then eu6 , user should be local admin and added to the database securty

  9. February 8, 2013 at 4:30 am

    Reblogged this on demagnum.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: