登入
Microsoft.com
 
Resources for IT Professionals
 
 
 
Resources for IT Professionals > 論壇首頁 > Configuration Manager Admin Console > SCCM Console not connecting to SMS Provider
發問發問
搜查論壇：
 

已答覆SCCM Console not connecting to SMS Provider

  • Wednesday, 7 January, 2009 14:29Joshua6 使用者勳章使用者勳章使用者勳章使用者勳章使用者勳章
     
    登入以投票
    0
    登入以投票
    I have an issue every morning that my console on my SCCM server does not connect to the SMS database.  I have configured WMI and DCOM permissions per Microsoft.  This happens every morning on the SCCM Server and my SCCM XP console.  This is a portion of the SCCM\AdminUI\Logs\SmsAdminUI.log:

    Error Code:


    Unexpected
    \r\nSystem.Management.ManagementException\r\nUnexpected error \r\n   at System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode)
       at System.Management.ManagementObjectCollection.ManagementObjectEnumerator.MoveNext()
       at Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlQueryResultsObject.<GetEnumerator>d__0.MoveNext()\r\nManagementException details:
    instance of __ExtendedStatus
    {
     Operation = "ExecQuery";
     ParameterInfo = "SELECT * FROM SMS_Site WHERE ReportingSiteCode = ''";
     ProviderName = "WinMgmt";
    };
    \r\n
    [6][1/7/2009 8:19:03 AM] :Microsoft.ConfigurationManagement.ManagementProvider.SmsConnectionException\r\nThe ConfigMgr console could not connect to the ConfigMgr site database. Verify that this computer has network connectivity to the SMS Provider computer and that your user account has Remote Activation permissions on both the ConfigMgr site server and SMS Provider computers. For more information, see "How to Configure DCOM Permissions for Configuration Manager Console Connections" in ConfigMgr Help.\r\n   at Microsoft.ConfigurationManagement.AdminConsole.SmsSiteConnectionNode.GetConnectionManagerInstance(String connectionManagerInstance)
       at Microsoft.ConfigurationManagement.AdminConsole.SmsSiteConnectionNode.BuildTreeWorker()\r\nThe ConfigMgr Provider reported an error.
    \r\nMicrosoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlQueryException\r\nThe ConfigMgr Provider reported an error.\r\n   at Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlQueryResultsObject.<GetEnumerator>d__0.MoveNext()
       at Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlConnectionManager.Connect(String configMgrServerPath)
       at Microsoft.ConfigurationManagement.AdminConsole.SmsSiteConnectionNode.GetConnectionManagerInstance(String connectionManagerInstance)\r\nConfigMgr Error Object:
    instance of __ExtendedStatus
    {
     Operation = "ExecQuery";
     ParameterInfo = "SELECT * FROM SMS_Site WHERE ReportingSiteCode = ''";
     ProviderName = "WinMgmt";
    };
     

解答

所有回覆

  • Wednesday, 7 January, 2009 18:56Donnie Taylor 使用者勳章使用者勳章使用者勳章使用者勳章使用者勳章
     
    登入以投票
    0
    登入以投票
    You said this happens on the server itself?  Odd.  The next time it happens, try this:

    Start, Run, type "wbemtest".
    Hit connect.
    Change the Namespace field to "root\sms\site_<SITECODE>" (change the <SITECODE> to your site) and select connect.
    Select query, and paste this in the "Enter Query" field - SELECT * FROM SMS_Site
    Does it return any values when you hit apply?

    Also, is this console on the SCCM server ONLY connecting to the local server?  Are there any processes that run in the mornings - perhaps a SQL backup or something along those lines?

     
  • Wednesday, 7 January, 2009 20:16Joshua6 使用者勳章使用者勳章使用者勳章使用者勳章使用者勳章
     
    登入以投票
    0
    登入以投票

    Yes, it is only connecting to the local SCCM server.  The only fix is a reboot.  Firewall is off.  The SCCM backup runs everynight at 10 PM.  I cannot pinpoint if it is the SCCM Site Server having the issue, or the remote SQL Server. 

    When I run the command above, I receive this error in the MOF field:


    instance of SMS_ExtendedStatus
    {
     CauseInfo = "";
     Description = "Unable to get SQL connection.";
     ErrorCode = 3242263810;
     File = "e:\\nts_sms_fre\\sms\\siteserver\\sdk_provider\\smsprov\\sspobjectquery.cpp";
     Line = 1861;
     Operation = "ExecQuery";
     ParameterInfo = "SELECT * FROM SMS_Site
    \n";
     ProviderName = "WinMgmt";
     SQLMessage = "[IM005][0][Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_DBC failed";
     SQLSeverity = 0;
     SQLStatus = 0;
     StatusCode = 2147749889;
    };

     
  • Wednesday, 7 January, 2009 20:39WallyMSFT, 擁有者使用者勳章使用者勳章使用者勳章使用者勳章使用者勳章
     
    登入以投票
    0
    登入以投票
    If you can't connect and run a query from wbemtest on the site server, then you have issues (of course you already knew that by posting here). I am not sure this is something we can fix in the forums, so I'd open a case with customer support on this one.

    Good luck with it.
    Wally Mead
     
  • Thursday, 8 January, 2009 12:15Joshua6 使用者勳章使用者勳章使用者勳章使用者勳章使用者勳章
     已答覆
    登入以投票
    0
    登入以投票
    Sounds good, I will give them a call.

    Thanks for your help anyway.

    Josh
    • 已標示為解答Joshua6 Thursday, 8 January, 2009 12:15
    •  
     
  • Thursday, 25 June, 2009 1:05Nilanga Karunathilake 使用者勳章使用者勳章使用者勳章使用者勳章使用者勳章
     
    登入以投票
    0
    登入以投票

    Was there a fix to this problem? I'm experiencing intermittent errors similar on my SCCM Server.

    Nilanga
     
  • Thursday, 23 July, 2009 3:50Tronz-Omega 使用者勳章使用者勳章使用者勳章使用者勳章使用者勳章
     
    登入以投票
    0
    登入以投票
    Hi,

    I seem to have the same problem. However i realised that there is some issue with passing WQL (SQL for WMI). I restarted WMI and SMS agent host service on the site server (or the affected server) and that fixed the problem.

    Dont know why this happens but this is the solution to it.

    Thanks