Failed to create AppDomain "CM_SMS.dbo - ConfigMgr 2012 R2 console error

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()
   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;

 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'

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

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)

 This finally gave me some convincing evidence that there is some problem with the SQL instance.

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

                                                                                                                                S A Delphin

Posted in: ConfigMgr