The Configuration Manager console cannot connect to the Configuration Manager site database

Question

The Configuration Manager console cannot connect to the Configuration Manager site database

David Howard 41

Hey Guys

I'm having trouble connecting to my site on our main server

At this point, I believe I try every fix online any help would greatly appreciated

Screenshot 2023-03-22 at 3.11.21 PM

Below is one of the error messages

David Howard 41

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__75.MoveNext()\r\nManagementException details:
instance of __ExtendedStatus
{
	Operation = "ExecQuery";
	ParameterInfo = "SELECT * FROM SMS_Site WHERE SiteCode = '100'";
	ProviderName = "WinMgmt";
};
\r\n
[2, PID:5188][11/17/2022 15:04:04] :System.Management.ManagementException\r\nProvider load failure \r\n   at System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode)
   at System.Management.ManagementObject.InvokeMethod(String methodName, ManagementBaseObject inParameters, InvokeMethodOptions options)
   at Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlConnectionManager.ExecuteMethod(String methodClass, String methodName, Dictionary`2 methodParameters, Boolean traceParameters)\r\nManagementException details:
[2, PID:5188][11/17/2022 15:04:04] :System.Management.ManagementException\r\nProvider load failure \r\n   at System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode)
   at System.Management.ManagementObject.InvokeMethod(String methodName, ManagementBaseObject inParameters, InvokeMethodOptions options)
   at Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlConnectionManager.ExecuteMethod(String methodClass, String methodName, Dictionary`2 methodParameters, Boolean traceParameters)\r\nManagementException details:
[2, PID:5188][11/17/2022 15:04:04] :System.Management.ManagementException\r\nProvider load failure \r\n   at System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode)
   at System.Management.ManagementObject.InvokeMethod(String methodName, ManagementBaseObject inParameters, InvokeMethodOptions options)

2 answers

Your answer

Answer 1

Garth 881

Did you try all of the suggestion listed in the screenshot?

Answer 2

AllenLiu-MSFT 49,436 Microsoft External Staff

Hi, @David Howard

Thank you for posting in Microsoft Q&A forum.

Have we checked if the "C:\Program Files\Microsoft Configuration Manager\Logs" missing the administrators group and the system account?

Here is the similar thread:

https://learn.microsoft.com/en-us/answers/questions/326448/configmgr-unable-to-connect-to-site-database

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Add comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

David Howard 41 Reputation points

2023-03-23T13:11:00.5166667+00:00

Hey @AllenLiu-MSFT

I saw this fix on another thread I have removed and re-added Administrators still no luck

Is there another Log file I should be looking at?
AllenLiu-MSFT 49,436 Reputation points Microsoft External Staff

2023-03-24T09:23:51.9966667+00:00
Hi, @David Howard

You may try to enable verbose SCCM Console logging:

From an administrator command prompt, open the following with Notepad:"C:\Program Files (x86)\Microsoft Configuration Manager\AdminConsole\bin\Microsoft.ConfigurationManagement.exe.config"

Search for switchValue="Error", and change to switchValue="Verbose" (as shown below), and save changes.

Restart the admin console for debug logging to take effect, then try to open console and check SmsAdminUI.log.

After troubleshooting the log, change the "Verbose" to "Error" as before.

Share via

The Configuration Manager console cannot connect to the Configuration Manager site database

2 answers

Your answer