Hi Everyone, I have a problem with connecting to the site in the SCCM console about two weeks ago and I don't know what the issue is, this was working perfectly and smoothly. I checked the WMI permissions required for ConfigMng SCCM console and it's ok, check NetBIOS over Tcpip, and its enabled, I checked permissions on the installation folder also and it's ok, I tried to connect to the SQL server using SQL server management studio and also ok, I try to connect using IP address to eliminate the problem with DNS, and noting changed, i got the same error. I try to uninstall/change the Configuration manager setup via Control panel but the option is blank, isn't avilible, so the option for repair isn't available. I also rebuilt WMI repository with the script:
net stop winmgmt
winmgmt /salvagerepository windir\System32\wbem
winmgmt /resetrepository windir\System32\wbem
and this also doesn't work for me. I started the SQL server agent, although I don't know if they were started before the error or not, I checked the firewall ports. they are okay, I tried to close the firewall and try it again, but that also doesn't work for me, I tried to troubleshoot SMS namespace connectivity and server connectivity, and that is okay, I also checked DCOM security settings. When I push nslookup using cmd, for the default server, it says localhost, I don't know if is that important. I'm stuck, i don't have very much experience with sccm, and this is my first time setting environment for sccm..I will attach photo from the SCCM console error and paste the UIlog.
[1, PID:6664][12/19/2023 10:46:24] : 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 = 'XXX'";
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 = 'XXX'";
ProviderName = "WinMgmt";
};
\r\n
[2, PID:6664][12/19/2023 10:46:27] :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:
