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

Resolution:
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

Technet

Advertisements
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: