Hi,

I have problem to open my SCCM console and i get this message

" The 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. "

After check the SmsAdminUI.log, i get below error message

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 ReportingSiteCode = ''";
 ProviderName = "WinMgmt";
};
\r\n
[6][10/27/2009 4:55:22 PM] :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";
};

can anyone advice how to solve it? Thanks in advanced

Regards, 
Chungb



 

• Edited by chungb Friday, April 19, 2013 8:21 AM
• Changed type chungb Friday, April 19, 2013 8:22 AM
• Changed type chungb Friday, April 19, 2013 8:22 AM

Hi Chungb,

Please run Wbemtest.

Connect to root\sms --> Enum Classes-->Select recursive- -->Select SMS_ProviderLocation () Click on instances

Could you find that there was any entry for this?

Also, on your SCCM database server, is there any Failure Audit messages in Event Viewer?

Hi,

Yes, when i click on instances, it appear to have oneobjectthere " SMS ProviderLocation.SiteCode=..... ".
SCCM database server didn't show any error.

I will try toreinstall the.Net framework as i suspect itcausing problem.

Regards,
Chung Boon

Hi Eric,

I found this forum post from google as I too am affected by this same issue.

I have the same AdminUI error. Doesnt matter if if is a local console or on a remote computer, the same error appears. I have just applied SP2 however the site was functional after the upgrade.

When attempting the WBEMTEST issue above, when i clicked on instances, WBEMTEST crashed! (so assume that is bad).

We need to rebuild alot of servers soon so I am inclined to get started on reimaging and restoring this site server, but I was hoping for a quick fix if possible.


Nathan

Just a quick update. I have found some install after SP2 had cleared the PATH environment variable entries. I re-added the PATH from a working Config Manager server (Test server cofigured the same as this one). After a reboot, the server has come back good and appears to be fully operational.

• Marked as answer by Eric Zhang CHN Monday, November 09, 2009 3:59 AM

I have the issue again, this time i was not able to open SCCM console even after i restart my server.

Error message:

" The 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. "

SmsAdminUI.log :

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 ReportingSiteCode = ''";
ProviderName = "WinMgmt";
};
\r\n
[7][4/19/2013 4:10:43 PM] :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";
};

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 ReportingSiteCode = ''";
ProviderName = "WinMgmt";
};
\r\n

Does anyone know how to troubleshoot this issue or have any proper method to solve it?

Notes: first time solution when encountered this problem was reboot my server and it works, but now it doesn't .

In an entry above from 2009 from Eric Zhang, he asks you to check wbemtest; did you run that?  do you still have the single entry?

Otherwise, my only other suggestion is to contact Microsoft support.

chungb 

make sure you follow the steps in How to Configure DCOM Permissions for Configuration Manager Console Connections, also make sure the SMS Provider is part of the admin group and the SMS Admins is part of the computer Administrator group.

Yes, wbemtest.exe show that entry still have and the DCOM permission also i have check for SMS admin exist.

Any other solution that i can try for my SCCM console issue?

Regards,

Chung Boon

have anyone know how to perform this checking?

"In WMControl, under Security, insure that the SMS Admins Group has full rights to the root\SMS container and that these rights propogate down to the Root\SMS\Site_<SiteCode) Container"

regards,

Open RUN

type  WMIMGMT.MSC

Then it will open the WMIControl Wizard, Then click on properties,then navigate to above

Thanks.

When i use WMI Diagnosis tools to check my <a href="file://\\\root\sms\<site_sitecode">\\<siteserver>\root\sms\<site_sitecode> , it keep showing "Busy (4/22/2013 9.15.12am)..... "

is it showing the WMI corrupted?

Regards,

Here is some follow up for this issue,

I call up Microsoft support and they still investigate the issue, but doesn't sound good for me.

Anyway i have one finding on my SCCM server, when i run WMIdiag.exe to check WMI, the report show that my root\ccm and root\cimv2 is missing or corrupted. Anyone have idea how can i fix it?

example:

root/cim2, CCM_LogicalMemoryConfiguration, 0x80041002 -(WBEM_E_NOT_FOUND) Object cannot be found

root/ccm/Scheduler, 0x8004100E - (WBEM_E_INVALID_NAMESPACE) Namespace specified cannot be found

fix WMI:
http://eskonr.com/2012/01/how-to-fix-wmi-issues-automatically/