August 12, 2015
S A Delphin
Hey Guys. wanted to share a issue that i have encountered today with my ConfigMgr LAB environment. When i tried launching the ConfigMgr console in the LAB today I was gifted with the below error.
As soon i got this message i checked the SmsAdminUI.log and i could see the below log snippet
[6, PID:3960][08/12/2015 13:09:20] :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()As this suggests that the SMS provider is failing to execute a WMI query i quickly connected Root\SMS\Site_LAB and tried running SELECT * FROM SMS_Site WHERE SiteCode = 'LAB'
at Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlConnectionManager.Connect(String configMgrServerPath)
at Microsoft.ConfigurationManagement.AdminConsole.SmsSiteConnectionNode.GetConnectionManagerInstance(String connectionManagerInstance)\r\nConfigMgr Error Object:
Description = "Can't create instance of CSecuredSource for SMS_Site";
ErrorCode = 3250653696;
I have got the below error message
As this was misleading i went and checked smsprov.log to see if there is any error. and in the smsprov.log i could see the below snippet
This finally gave me some convincing evidence that there is some problem with the SQL instance.CSspQueryForObject :: Execute... SMS Provider 12.08.2015 10:36:24 5516 (0x158C)*** select so.ObjectTypeID, so.ObjectTypeName, CASE dbo.fnIsSiteInMaintMode() WHEN 0 THEN so.AvailableOperations ELSE dbo.fnOR(oo.BitFlag) & so.AvailableOperations END from dbo.RBAC_SecuredObjectTypes AS so inner join dbo.RBAC_ObjectOperations AS oo ON oo.ObjectTypeID = so.ObjectTypeID where oo.isReadOnly = 1 AND so.ObjectTypeName = 'SMS_Site' group by so.ObjectTypeID, so.ObjectTypeName, so.AvailableOperations SMS Provider 12.08.2015 10:36:24 5516 (0x158C)*** [42000][6517][Microsoft][SQL Server Native Client 11.0][SQL Server]Failed to create AppDomain "CM_LAB.dbo[runtime].822". ~~Exception has been thrown by the target of an invocation. SMS Provider 12.08.2015 10:36:24 5516 (0x158C)*~*~[42000][6517][Microsoft][SQL Server Native Client 11.0][SQL Server]Failed to create AppDomain "CM_LAB.dbo[runtime].822". ~~Exception has been thrown by the target of an invocation. ThreadID : 5516 , DbError: 6517 , Sev: 16~*~* SMS Provider 12.08.2015 10:36:24 5516 (0x158C)CSecuritySource::GetSecurityObjectEx - SQL cmd failed SMS Provider 12.08.2015 10:36:24 5516 (0x158C)*~*~e:\nts_sccm_release\sms\siteserver\sdk_provider\smsprov\sspobjectquery.cpp(2057) : Can't create instance of CSecuredSource for SMS_Site~ SQL Error: [42000][6517][Microsoft][SQL Server Native Client 11.0][SQL Server]Failed to create AppDomain "CM_LAB.dbo[runtime].822". ~~Exception has been thrown by the target of an invocation.~*~* SMS Provider 12.08.2015 10:36:24 5516 (0x158C)*~*~Can't create instance of CSecuredSource for SMS_Site [42000][6517][Microsoft][SQL Server Native Client 11.0][SQL Server]Failed to create AppDomain "CM_LAB.dbo[runtime].822". ~~Exception has been thrown by the target of an invocation.~*~* SMS Provider 12.08.2015 10:36:24 5516 (0x158C)Execute WQL =SELECT * FROM SMS_Site WHERE SiteCode = 'LAB' SMS Provider 12.08.2015 10:36:24 5516 (0x158C)
As a first step I restarted the SQL instance (Would not be the first for most of us ) and voila the console started showing me the Asset and compliance workspace. And that saved my day.
Bottom line, to me restarted the SQL instance worked.
Hope this helps ..
