SOLVED SCCM Admin console doesn't work,SCCM reset error and etc

[Ali_Pashayev]

Hi everyone,
Sccm stopped for several days.When i open admin console i get error.Firewalls are turned off on both servers(Sccm and SccmSql).
I also get an error when I do sccm reset to fix the problem.I've looked at almost all the forums, but it didn't work.
Thanks in advance for your support and valuable ideas.

When I open admin console error Event ID:
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__75.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 = 'BBB'";
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__75.MoveNext()\r\nManagementException details:
instance of __ExtendedStatus
{
Operation = "ExecQuery";
ParameterInfo = "SELECT * FROM SMS_Site WHERE SiteCode = 'BBB'";
ProviderName = "WinMgmt";
};
\r\n

Sccm Reset error:
*** Failed to connect to the SQL Server, connection type: servername.domain.com MASTER.

 

[Prajwal Desai]

The ConfigMgr has lost connectivity to SQL server. Is the ConfigMgr database hosted on SQL server that exists on local machine or remote server?.

 

[Ali_Pashayev]

Thank you for your answer Prajwal.I solved the problem.A few days ago security update installed to dc1 and dc2.I uninstalled this updates.Working