locked
Не подключается консоль к SCCM 2012 RRS feed

  • Question

  • Добрый день, коллеги!

    Сегодня вдруг перестала подключаться консоль к SCCM, как удаленно, так и локально. В логах нашел следующую ошибку:

    Log Name:      Application
    Source:        Critical
    Date:          11/14/2016 5:08:06 PM
    Event ID:      1
    Task Category: None
    Level:         Error
    Keywords:      Classic
    User:          N/A
    Computer:      srv500v.incoma.ru
    Description:
    Transport error; failed to connect, message: 'The SMS Provider reported an error.'\r\nMicrosoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlQueryException\r\nThe SMS 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 SiteCode = '000'";
    ProviderName = "WinMgmt";
    };

    Error Code:
    ProviderLoadFailure
    \r\nSystem.Management.ManagementException\r\nProvider load failure \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 SiteCode = '000'";
    ProviderName = "WinMgmt";
    };
    \r\n
    Event Xml:
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
      <System>
        <Provider Name="Critical" />
        <EventID Qualifiers="0">1</EventID>
        <Level>2</Level>
        <Task>0</Task>
        <Keywords>0x80000000000000</Keywords>
        <TimeCreated SystemTime="2016-11-14T14:08:06.000000000Z" />
        <EventRecordID>208440</EventRecordID>
        <Channel>Application</Channel>
        <Computer>srv500v.incoma.ru</Computer>
        <Security />
      </System>
      <EventData>
        <Data>Transport error; failed to connect, message: 'The SMS Provider reported an error.'\r\nMicrosoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlQueryException\r\nThe SMS Provider reported an error.\r\n   at Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlQueryResultsObject.&lt;GetEnumerator&gt;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 SiteCode = '000'";
    ProviderName = "WinMgmt";
    };

    Error Code:
    ProviderLoadFailure
    \r\nSystem.Management.ManagementException\r\nProvider load failure \r\n   at System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode)
       at System.Management.ManagementObjectCollection.ManagementObjectEnumerator.MoveNext()
       at Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlQueryResultsObject.&lt;GetEnumerator&gt;d__0.MoveNext()\r\nManagementException details:
    instance of __ExtendedStatus
    {
    Operation = "ExecQuery";
    ParameterInfo = "SELECT * FROM SMS_Site WHERE SiteCode = '000'";
    ProviderName = "WinMgmt";
    };
    \r\n</Data>
      </EventData>
    </Event>

    В интернете нашел, что такое бывает когда пропадают права WMI, проверил у  SMS Admins права есть. Также такое бывает после установки обновлений, проверил ничего не ставилось. Может кто сталкивался с подобной проблемой, буду признателен за любую помощь. 

    UPD1: Сервер перезагружал, проблема осталась.



    • Edited by EFIMOVDI Monday, November 14, 2016 2:38 PM
    Monday, November 14, 2016 2:17 PM

Answers

  • Проблема решена, проблема была на стороне SQL сервера.
    • Marked as answer by EFIMOVDI Tuesday, November 15, 2016 9:32 AM
    Tuesday, November 15, 2016 9:32 AM

All replies

  • Even though I can use Google Translate, please post in English so everyone can read it.

    You mentioned an Update Installation? Was the Console actually updated after the Installation of this Update?


    Simon Dettling | msitproblog.com | @SimonDettling

    Monday, November 14, 2016 3:07 PM
  • Even though I can use Google Translate, please post in English so everyone can read it.

    You mentioned an Update Installation? Was the Console actually updated after the Installation of this Update?


    Simon Dettling | msitproblog.com | @SimonDettling

    The server we have not updated the year, it is certainly not an update.

    Diagnosis is made on this article:

    https://social.technet.microsoft.com/Forums/en-US/3f5f82a4-8ca1-492f-8ca0-44c94dbe547f/unable-to-open-sccm-admin-console?forum=configmgrgeneral

    Monday, November 14, 2016 3:29 PM
  • Dear Sir,

    Please be sure that the site database you're connecting to is up and running normally. Then try to open other console to see if they work or not. If it only this console which gets the problem, you can try to uninstall and re-install console.

    Best regards

    Frank


    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    • Proposed as answer by Frank Dong Wednesday, November 16, 2016 1:18 AM
    Tuesday, November 15, 2016 4:07 AM
  • Проблема решена, проблема была на стороне SQL сервера.
    • Marked as answer by EFIMOVDI Tuesday, November 15, 2016 9:32 AM
    Tuesday, November 15, 2016 9:32 AM