로그인
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

  • 2009년 1월 7일 수요일 오후 2: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";
    };
     

답변

모든 응답

  • 2009년 1월 7일 수요일 오후 6: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?

     
  • 2009년 1월 7일 수요일 오후 8: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;
    };

     
  • 2009년 1월 7일 수요일 오후 8: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
     
  • 2009년 1월 8일 목요일 오후 12:15Joshua6 사용자 메달사용자 메달사용자 메달사용자 메달사용자 메달
     답변됨
    로그인하여 투표
    0
    로그인하여 투표
    Sounds good, I will give them a call.

    Thanks for your help anyway.

    Josh
    • 답변으로 표시됨Joshua6 2009년 1월 8일 목요일 오후 12:15
    •  
     
  • 2009년 6월 25일 목요일 오전 1:05Nilanga Karunathilake 사용자 메달사용자 메달사용자 메달사용자 메달사용자 메달
     
    로그인하여 투표
    0
    로그인하여 투표

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

    Nilanga
     
  • 2009년 7월 23일 목요일 오전 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