locked
could not connect or execute sql query... RRS feed

  • Question

  • hi,

    after starting install of sccm 2012 (valid checking and connecting to remote sql 2012) i receive error like in topic and in log file i see one error:

    "Failed to connect to registry to determine if Configuration Manager console is installed"

    do you know what is causing error?

    thx for any tip.


    Voytas

    Friday, May 4, 2012 11:26 AM

Answers

  • name of installation folder was the issue. i had name:

    SW_DVD5_Sys_Ctr_ConfigMgrClt_ML_2012_MultiLang_Client_SCEP_MLF_X17-95285

    and changed to:

    CM2012

    It helps

    .. so it is better install from media then filesystem.


    Voytas


    • Marked as answer by Voytass Tuesday, May 15, 2012 11:32 AM
    • Edited by Voytass Tuesday, May 15, 2012 11:58 AM
    Tuesday, May 15, 2012 11:32 AM

All replies

  • after starting install of sccm 2012 (valid checking and connecting to remote sql 2012)

    SQL 2012 is not yet supported. Just use a supported version of SQL server (according to the official docs): http://technet.microsoft.com/en-us/library/gg682077.aspx#BKMK_SupConfigSQLDBconfig

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

    • Proposed as answer by TorstenMMVP Monday, May 7, 2012 6:47 AM
    Friday, May 4, 2012 11:51 AM
  • ok. i installed 2008 r2 + sp2 and required fixes and i have same error.

    Voytas

    Friday, May 4, 2012 1:16 PM
  • I've seen the same error http://myitforum.com/cs2/blogs/bgharbi/archive/2011/10/17/configmgr-2012-could-not-connect-or-execute-sql-query.aspx

    You have to configure SQL Server to listen on TCP (1433) http://msdn.microsoft.com/en-us/library/ms177440(v=sql.105).aspx


    Bechir Gharbi | My blog: @myITforum.com | Twitter: @Bechir_Gharbi | Linkedin: Bechir Gharbi | Time zone: GMT + 1

    Sunday, May 6, 2012 3:32 PM
  • hi Bechir Gharbi,

    not the same error. in log i have

    "Failed to connect to registry to determine if Configuration Manager console is installed"

    but thx anyway - i saw the article already.


    Voytas

    Monday, May 7, 2012 6:13 AM
  • hi FlowMaN,

    point 1 i had configured but 2 is strange - i do not have db file because i did not start installing due the error :)


    Voytas

    Monday, May 7, 2012 6:49 AM
  • "Failed to connect to registry to determine if Configuration Manager console is installed"

    Is the remote registry service started at all? Is the traffic allowed by the firewall?

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

    Monday, May 7, 2012 7:35 AM
  • yeap, service OK and servers (CM and SQL) are in the same subnet.

    Voytas


    • Edited by Voytass Monday, May 7, 2012 9:30 AM
    Monday, May 7, 2012 9:09 AM
  • i can add that server fo SCOM and SQL server are new 2008 r2 so maybe there is something i am missing installing and scom 2012 does not check.

    Voytas

    Thursday, May 10, 2012 1:04 PM
  • What does the logfile (C:\ConfigMgrSetup.log) tell exactly? Please post more than just a single line.


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

    Thursday, May 10, 2012 1:07 PM
  • There is no SP2 for 2008 R2.  You should install SP1 and Cumulative Update 6.

    Microsoft MVP - ConfigMgr

    Thursday, May 10, 2012 3:18 PM
  • I have the same issue, below is a snippet from my log. thanks!


    ~===================== << Starting Configuration Manager 2012 Setup >> =====================	Configuration Manager Setup	1/1/1601 12:00:00 AM	808 (0x0328)
    INFO: ConfigMgr2012 Setup was started by H5TECHNOLOGIES\s_sccm.	Configuration Manager Setup	1/1/1601 12:00:00 AM	808 (0x0328)
    INFO: Command line specified was: "E:\sc2012\sc12sccm\SMSSETUP\BIN\X64\SetupWpf.exe"	Configuration Manager Setup	1/1/1601 12:00:00 AM	808 (0x0328)
    FQDN for server SF-CORP-IT-12 is SF-CORP-IT-12.h5technologies.com	Configuration Manager Setup	1/1/1601 12:00:00 AM	808 (0x0328)
    INFO: Target computer is a 64 bit operating system.	Configuration Manager Setup	1/1/1601 12:00:00 AM	808 (0x0328)
    INFO: Checking for existing setup information.	Configuration Manager Setup	1/1/1601 12:00:00 AM	808 (0x0328)
    INFO: Checking for existing SQL information.	Configuration Manager Setup	1/1/1601 12:00:00 AM	808 (0x0328)
    INFO: Verifying the registry entry for Asset Intelligence installation	Configuration Manager Setup	1/1/1601 12:00:00 AM	808 (0x0328)
    INFO: Setting the default CSV folder path	Configuration Manager Setup	1/1/1601 12:00:00 AM	808 (0x0328)
    INFO: No language packs detected.	Configuration Manager Setup	1/1/1601 12:00:00 AM	808 (0x0328)
    INFO: Configuration Manager Build Number = 7711	Configuration Manager Setup	1/1/1601 12:00:00 AM	808 (0x0328)
    INFO: Configuration Manager Version = 5.0	Configuration Manager Setup	1/1/1601 12:00:00 AM	808 (0x0328)
    INFO: Configuration Manager Minimum Build Number = 800	Configuration Manager Setup	1/1/1601 12:00:00 AM	808 (0x0328)
    INFO: Verifying Configuration Manager Active Directory Schema Extensions.	Configuration Manager Setup	1/1/1601 12:00:00 AM	808 (0x0328)
    INFO: Found DS Root:CN=Schema,CN=Configuration,DC=h5technologies,DC=com	Configuration Manager Setup	1/1/1601 12:00:00 AM	808 (0x0328)
    INFO: Verifying Configuration Manager Active Directory Schema Extensions.	Configuration Manager Setup	1/1/1601 12:00:00 AM	808 (0x0328)
    INFO: Found DS Root:CN=Schema,CN=Configuration,DC=h5technologies,DC=com	Configuration Manager Setup	1/1/1601 12:00:00 AM	808 (0x0328)
    INFO: Validating characters in path from Program Files\Microsoft Configuration Manager	Configuration Manager Setup	1/1/1601 12:00:00 AM	808 (0x0328)
    INFO: VL or OEM Product Key was specified.	Configuration Manager Setup	1/1/1601 12:00:00 AM	808 (0x0328)
    INFO: Installing Full version.	Configuration Manager Setup	1/1/1601 12:00:00 AM	808 (0x0328)
    INFO: 'SF-CORP-IT-12.h5technologies.com' is a valid FQDN.	Configuration Manager Setup	1/1/1601 12:00:00 AM	808 (0x0328)
    INFO: 'SF-CORP-IT-12.h5technologies.com' is a valid FQDN.	Configuration Manager Setup	1/1/1601 12:00:00 AM	808 (0x0328)
    ERROR: Failed to connect to registry to determine if Configuration Manager console is installed.	Configuration Manager Setup	1/1/1601 12:00:00 AM	808 (0x0328)
    INFO: 'SF-CORP-IT-12.h5technologies.com' is a valid FQDN.	Configuration Manager Setup	1/1/1601 12:00:00 AM	808 (0x0328)
    INFO: This is a named instance SQL Server.	Configuration Manager Setup	1/1/1601 12:00:00 AM	808 (0x0328)
    INFO: SQL Server instance name (pSetupInf->SqlInstName): SC2012	Configuration Manager Setup	1/1/1601 12:00:00 AM	808 (0x0328)
    INFO: SQL Server master database (pSetupInf->SqlMasterDB): SC2012\master	Configuration Manager Setup	1/1/1601 12:00:00 AM	808 (0x0328)
    INFO: Site SQL Server database name (pSetupInf->SqlDatabaseName): SC2012\CM_H52	Configuration Manager Setup	1/1/1601 12:00:00 AM	808 (0x0328)
    INFO: Site SQL Server computer name (pSetupInf->SqlServer): SF-CORP-IT-12.h5technologies.com	Configuration Manager Setup	1/1/1601 12:00:00 AM	808 (0x0328)
    ~===================== Failed Configuration Manager 2012 Server Setup =====================	Configuration Manager Setup	1/1/1601 12:00:00 AM	808 (0x0328)
    



    Thursday, May 10, 2012 6:40 PM
  • "ERROR: Failed to connect to registry to determine if Configuration Manager console is installed."
    What have you checked so far?

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

    Thursday, May 10, 2012 7:42 PM
  • The entry to verify the Condigration manager console is "expected" if you are installing on a clean server.

    At what point in the process is this happening? Is this a popup during the installation wizard? What is the exact error message?

    Jason

    Thursday, May 10, 2012 7:46 PM
  • the error is: could not connect or execute sql query. View log for more info

    I didn't try much as I have no idea where to start looking, in the logs besides the registry mention, there is no other pointer

    Thursday, May 10, 2012 7:50 PM
  • When I click the Begin Install button immediately after the Prereqs are all successfully passed, then I get this

    Thursday, May 10, 2012 7:57 PM
  • If you haven't yet - try FlowMaN's link. The console message you are getting is not an error, it is the designed behavior if there is no console installed on the system. Most of the time when I've seen this its the Dynamic ports issue.

    Thursday, May 10, 2012 8:53 PM
  • It looks like if you're using a Named SQL instance instead of Default SQL instance, then port 1433 won't work, even static. So now I moved my named instance to listen to port 4022, and it passed the above error. Not intuitive, but there you have it...
    • Edited by h5tech Thursday, May 10, 2012 9:51 PM update
    Thursday, May 10, 2012 9:49 PM
  • after install only om concole on OM server and then start normal installation i have the same error (h5tech put screen) but in log file line with

    "ERROR: Failed to connect to registry to determine if Configuration Manager console is installed. Configuration Manager Setup"

    disappeard

    in other log (ConfigMgrSetupWizard) i have:

    5/11/2012 8:33:37 AM: ConfigMgrSetupWizard Information: 1 : Cancelling asynchronous threads...
    5/11/2012 8:33:37 AM: ConfigMgrSetupWizard Information: 1 : Notified monitoring threads to exit.
    5/11/2012 8:33:37 AM: ConfigMgrSetupWizard Information: 1 : All monitoring threads have completed.
    5/11/2012 8:33:37 AM: ConfigMgrSetupWizard Verbose: 1 : Exiting SetupWPF.exe.
    5/11/2012 8:33:39 AM: ConfigMgrSetupWizard Verbose: 1 : Cannot not connect to SMS provider on local machine. Either it is not installed or access is denied.
    5/11/2012 8:33:44 AM: ConfigMgrSetupWizard Information: 1 : Cannot detect SMS Type because either SiteServer, SqlServer or SiteServerName is empty.
    5/11/2012 8:35:20 AM: ConfigMgrSetupWizard Information: 1 : Creating SQL connection to database scenter\master on server sql01.UDT.local.
    5/11/2012 8:35:20 AM: ConfigMgrSetupWizard Information: 1 : Sql connection is established.
    5/11/2012 8:35:20 AM: ConfigMgrSetupWizard Information: 1 : Creating SQL connection to database scenter\master on server sql01.UDT.local.
    5/11/2012 8:35:20 AM: ConfigMgrSetupWizard Information: 1 : Sql connection is established.
    5/11/2012 8:35:22 AM: ConfigMgrSetupWizard Information: 1 : Creating SQL connection to database scenter\master on server sql01.UDT.local.
    5/11/2012 8:35:22 AM: ConfigMgrSetupWizard Information: 1 : Sql connection is established.
    5/11/2012 8:36:10 AM: ConfigMgrSetupWizard Verbose: 1 : Report progress callback. Progress stage: 50, Progress state: 0.
    5/11/2012 8:36:10 AM: ConfigMgrSetupWizard Verbose: 1 : Received setup progress [Evaluating setup environment] from native code.
    5/11/2012 8:36:12 AM: ConfigMgrSetupWizard Verbose: 1 : Report failure callback. Failure: 103.
    5/11/2012 8:36:12 AM: ConfigMgrSetupWizard Information: 1 : Cancelling asynchronous threads...
    5/11/2012 8:36:12 AM: ConfigMgrSetupWizard Information: 1 : Notified monitoring threads to exit.
    5/11/2012 8:36:12 AM: ConfigMgrSetupWizard Information: 1 : All monitoring threads have completed.
    5/11/2012 8:36:12 AM: ConfigMgrSetupWizard Information: 1 : Released callback GC handle
    5/11/2012 8:36:12 AM: ConfigMgrSetupWizard Verbose: 1 : Received error [Could not connect or execute SQL query.] from native code.
    5/11/2012 8:36:12 AM: ConfigMgrSetupWizard Verbose: 1 : Completed the site installation thread.
    5/11/2012 8:36:12 AM: ConfigMgrSetupWizard Information: 1 : Removed Product Key from SetupScriptFile
    5/11/2012 8:37:17 AM: ConfigMgrSetupWizard Information: 1 : Cancelling asynchronous threads...
    5/11/2012 8:37:17 AM: ConfigMgrSetupWizard Information: 1 : Notified monitoring threads to exit.
    5/11/2012 8:37:17 AM: ConfigMgrSetupWizard Information: 1 : All monitoring threads have completed.
    5/11/2012 8:37:17 AM: ConfigMgrSetupWizard Verbose: 1 : Exiting SetupWPF.exe.
    5/11/2012 8:37:38 AM: ConfigMgrSetupWizard Verbose: 1 : Cannot not connect to SMS provider on local machine. Either it is not installed or access is denied.
    5/11/2012 8:37:42 AM: ConfigMgrSetupWizard Information: 1 : Cannot detect SMS Type because either SiteServer, SqlServer or SiteServerName is empty.
    5/11/2012 8:41:37 AM: ConfigMgrSetupWizard Information: 1 : Creating SQL connection to database scenter\master on server sql01.UDT.local.
    5/11/2012 8:41:38 AM: ConfigMgrSetupWizard Information: 1 : Sql connection is established.
    5/11/2012 8:41:38 AM: ConfigMgrSetupWizard Information: 1 : Creating SQL connection to database scenter\master on server sql01.UDT.local.
    5/11/2012 8:41:38 AM: ConfigMgrSetupWizard Information: 1 : Sql connection is established.
    5/11/2012 8:41:39 AM: ConfigMgrSetupWizard Information: 1 : Creating SQL connection to database scenter\master on server sql01.UDT.local.
    5/11/2012 8:41:39 AM: ConfigMgrSetupWizard Information: 1 : Sql connection is established.
    5/11/2012 8:42:49 AM: ConfigMgrSetupWizard Verbose: 1 : Report progress callback. Progress stage: 50, Progress state: 0.
    5/11/2012 8:42:49 AM: ConfigMgrSetupWizard Verbose: 1 : Received setup progress [Evaluating setup environment] from native code.
    5/11/2012 8:42:50 AM: ConfigMgrSetupWizard Verbose: 1 : Report failure callback. Failure: 103.
    5/11/2012 8:42:50 AM: ConfigMgrSetupWizard Information: 1 : Cancelling asynchronous threads...
    5/11/2012 8:42:50 AM: ConfigMgrSetupWizard Information: 1 : Notified monitoring threads to exit.
    5/11/2012 8:42:50 AM: ConfigMgrSetupWizard Information: 1 : All monitoring threads have completed.
    5/11/2012 8:42:50 AM: ConfigMgrSetupWizard Information: 1 : Released callback GC handle
    5/11/2012 8:42:50 AM: ConfigMgrSetupWizard Verbose: 1 : Received error [Could not connect or execute SQL query.] from native code.
    5/11/2012 8:42:50 AM: ConfigMgrSetupWizard Verbose: 1 : Completed the site installation thread.
    5/11/2012 8:42:50 AM: ConfigMgrSetupWizard Information: 1 : Removed Product Key from SetupScriptFile
    5/11/2012 8:48:45 AM: ConfigMgrSetupWizard Information: 1 : Cancelling asynchronous threads...
    5/11/2012 8:48:45 AM: ConfigMgrSetupWizard Information: 1 : Notified monitoring threads to exit.
    5/11/2012 8:48:45 AM: ConfigMgrSetupWizard Information: 1 : All monitoring threads have completed.
    5/11/2012 8:48:45 AM: ConfigMgrSetupWizard Verbose: 1 : Exiting SetupWPF.exe.


    Voytas


    • Edited by Voytass Friday, May 11, 2012 6:59 AM
    Friday, May 11, 2012 6:58 AM
  • changeing listening port did not help in my env.


    Voytas


    • Edited by Voytass Friday, May 11, 2012 7:00 AM
    Friday, May 11, 2012 6:59 AM
  • Voytas,

    I made the change to set the static port for both the IP address and under IPAll:TCP Port in order to get past this error.  In my enviroment I had the latter value blank and once I put in the port I was using for the SCCM SQL Instance things started to hum along as expected.


    Your Welcome

    • Proposed as answer by Ryan A. Hunt Friday, August 24, 2012 12:30 AM
    Tuesday, May 15, 2012 4:51 AM
  • name of installation folder was the issue. i had name:

    SW_DVD5_Sys_Ctr_ConfigMgrClt_ML_2012_MultiLang_Client_SCEP_MLF_X17-95285

    and changed to:

    CM2012

    It helps

    .. so it is better install from media then filesystem.


    Voytas


    • Marked as answer by Voytass Tuesday, May 15, 2012 11:32 AM
    • Edited by Voytass Tuesday, May 15, 2012 11:58 AM
    Tuesday, May 15, 2012 11:32 AM
  • Awesome, thanks dude!
    Wednesday, August 21, 2013 11:26 PM