locked
ERROR: Failed to get SQL Server connection - SCCM 2012 Installation with SQL Server 2008 Remote RRS feed

  • Question

  • Hi,

    i have problem with installation of SCCM 2012 with SQL Server 2008 installed in the remote server.

    This is my installation log file:

    CSql Error: Cannot find type data, cannot get a connection.  $$<Configuration Manager Setup><07-25-2012 10:54:56.802-120><thread=1564 (0x61C)>

    *** [08001][17][Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.  $$<Configuration Manager Setup><07-25-2012 10:55:58.564-120><thread=1564 (0x61C)>
    *** [01000][67][Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).  $$<Configuration Manager Setup><07-25-2012 10:55:58.564-120><thread=1564 (0x61C)>
    *** Failed to connect to the SQL Server.  $$<Configuration Manager Setup><07-25-2012 10:55:58.564-120><thread=1564 (0x61C)>
    *** [08001][17][Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.  $$<Configuration Manager Setup><07-25-2012 10:56:59.965-120><thread=1564 (0x61C)>
    *** [01000][67][Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).  $$<Configuration Manager Setup><07-25-2012 10:56:59.965-120><thread=1564 (0x61C)>
    *** Failed to connect to the SQL Server.  $$<Configuration Manager Setup><07-25-2012 10:56:59.965-120><thread=1564 (0x61C)>
    ERROR: The current user does not have administrative rights on computer: SQL SERVER HOST.  $$<Configuration Manager Setup><07-25-2012 10:56:59.965-120><thread=1564 (0x61C)>
    ERROR: Prerequisite checking stopped on this machine.  $$<Configuration Manager Setup><07-25-2012 10:56:59.965-120><thread=1564 (0x61C)>

    Wednesday, July 25, 2012 11:54 AM

All replies

  • Please check the following:

    1. For (SQL Server does not exist or access denied), make sure that Configuration Manager computer account member of local administrator groub for both SQL nodes.

    2. Make sure that you create a new instance for Configuration Manager 2012.

    3. Check SQL Server Requirements:
    http://technet.microsoft.com/en-us/library/gg682077.aspx#BKMK_SupConfigSQLSrvReq

    4. Configuration Manager 2012 support the following version:

    - SQL Server 2008 SP2 with a minimum of Cumulative Update 9

    - SQL Server 2008 SP3 with a minimum of Cumulative Update 4

    - SQL Server 2008 R2 with SP1 and with a minimum of Cumulative Update 6

    Notes:

    1- SQL Server database mirroring is not supported for the Configuration Manager site database.

    2- When you use a remote SQL Server computer, the instance of SQL Server used to host the site database can also be configured as a SQL Server failover cluster in an active/passive cluster, or a multiple instance configuration. The site database site system role is the only System Center 2012 Configuration Manager site system role supported on an instance of a Windows Server cluster. If you use a SQL Server cluster for the site database, you must add the computer account of the site server to the Local Administrators group of each Windows Server cluster node computer.


    Abduljalil Abolzahab


    Wednesday, July 25, 2012 12:03 PM
  • The collcation has to be SQL_Latin1_General_CP1_CI_AS.

    Torsten Meringer | http://www.mssccmfaq.de

    Wednesday, July 25, 2012 12:06 PM
  • Hi Abduljalil ,

    thanks for your responce.

    Point n°2  is a MUST? This could be a cause of my problem?

    I have create new istance, but it's a first istance created .

    Wednesday, July 25, 2012 12:14 PM
  • The collcation has to be SQL_Latin1_General_CP1_CI_AS.

    Torsten Meringer | http://www.mssccmfaq.de

    Hi Torsten,

    collaction is but  SQL_Latin1_General_CP1_CI_AS  installation failed becouse it can't connect to database, and it can't verify properties.

    E.


    Wednesday, July 25, 2012 12:26 PM
  • I have sql server 2008 sp1 with cu6

    CM Account machine is on the local admin group for both two node cluster server sql .

    My account, that make a installation of CM, is sysadmin in the database.

    E

    Wednesday, July 25, 2012 12:39 PM
  • Have you checked the following point mentioned in Windows-Noob?

    Start up the SQL Server Configuration Manager, and expand SQL Server Network Configuration on the left pane, highlight Protocols for <Instancename> and double click on TCPIP in the right pane


    Anoop C Nair - @anoopmannur :: MY Site:  www.AnoopCNair.com :: FaceBook:  ConfigMgr(SCCM) Page :: Linkedin:  Linkedin<

    Wednesday, July 25, 2012 12:40 PM
  • not work.

    other tips?

     :(

    Can i ignore prerequisites?
    Wednesday, July 25, 2012 1:03 PM
  • Have you added the accounts of the user installing ConfigMgr and the computer account (!) of the site server to the local admins on the SQL box and sysadmins in SQL?
    The prerequisites can obviously not be ignored; the "Begin Install" button is greyed out.

    Torsten Meringer | http://www.mssccmfaq.de


    • Edited by TorstenMMVP Wednesday, July 25, 2012 1:18 PM
    Wednesday, July 25, 2012 1:18 PM
  • Yes , all is done.

    Wednesday, July 25, 2012 1:27 PM
  • I have sql server 2008 sp1 with cu6

    CM Account machine is on the local admin group for both two node cluster server sql .

    My account, that make a installation of CM, is sysadmin in the database.

    E

    According to Microsoft Supported conffiguration, this is the lists the SQL Server versions that are supported by System Center 2012 Configuration Manager

    - SQL Server 2008 SP2 with a minimum of Cumulative Update 9

    - SQL Server 2008 SP3 with a minimum of Cumulative Update 4

    - SQL Server 2008 R2 with SP1 and with a minimum of Cumulative Update 6

    You have SQL Server 2008 SP1, please try to install SP2 or SP3 with supported Cumulative Update.


    Abduljalil Abolzahab

    Wednesday, July 25, 2012 3:14 PM
  • Hi ,

    I  have the same problem only I have sql 2008 R2 CU7

    I tested CU4 but that does not change.

    i Use default instance :MSSQLSERVER

    Wednesday, August 1, 2012 3:06 PM
  • Not sure if your problem still persists Tarek.

    But are you leaving the instance name field empty, when using the default instance?

    If not you won't have the server recognizing the instance. At least that was the issue for me.

    Wednesday, September 12, 2012 1:11 PM
  • The screenshot doesn't seem right.

    It indicates that the collation on the SCCM server is incorrect. In the Database information dialog of the wizard, are you entering the hostname of the SQL server or the SCCM primary? It should be the SQL server

    Second, as others have already indicated, the account that you install with should be both a local administrator (to the operating system) AND a sysadmin (to the SQL database instance). Are you installing with an account that has both privileges?

    Friday, September 14, 2012 11:14 AM
  • The screenshot doesn't seem right.

    It indicates that the collation on the SCCM server is incorrect. In the Database information dialog of the wizard, are you entering the hostname of the SQL server or the SCCM primary? It should be the SQL server

    Second, as others have already indicated, the account that you install with should be both a local administrator (to the operating system) AND a sysadmin (to the SQL database instance). Are you installing with an account that has both privileges?

    Actually the Screenshot is not that wrong I had it a few times, while I was using a SCOM Installation with a remote SQL Server. If you use the default instance of the SQL Server for the SCOM Installation and you enter the Default Instance Name when prompted in the Setup you might end up in an error message, that the collation of the Database is wrong.

    I found myself checking the collation Version on the SQL Server several times before I noticed that this was not the issue.

    Nevertheless, checking the collation verson for SQL_Latin1_General_CP1_CI_AS is always a good first guess. Not sure if in the US but in Germany this collation is not one of the default ones.

    Tuesday, October 23, 2012 12:35 PM