SCCM 2012 R2 console cannot connect to site database

[Kaz77]

Hi,

I have been using SCCM fairly successfully but now cannot get the console to connect to the site database.

I have looked in the smsAdminUI.log and found the following information

 

[13, PID:7524][11/24/2015 10:57:12] :System.Management.ManagementException\r\nGeneric failure \r\n at System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode)

at System.Management.ManagementObjectCollection.ManagementObjectEnumerator.MoveNext()

at Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlQueryResultsObject.d__0.MoveNext()\r\nManagementException details:

instance of SMS_ExtendedStatus

{

Description = "Can't create instance of CSecuredSource for SMS_Site";

ErrorCode = 3250653696;

File = "e:\\nts_sccm_release\\sms\\siteserver\\sdk_provider\\smsprov\\sspobjectquery.cpp";

Line = 2057;

ObjectInfo = "SMS_Site";

Operation = "ExecQuery";

ParameterInfo = "SELECT * FROM SMS_Site WHERE SiteCode = 'STP'";

ProviderName = "WinMgmt";

SQLMessage = "[42000][6513][Microsoft]

[sql Server]Failed to initialize the Common Language Runtime (CLR) v2.0.50727 due to memory pressure. This is probably due to memory pressure in the MemToLeave region of memory. For more information, see the CLR integration documentation in SQL Server Books Online.";

	SQLSeverity = 16;

	SQLStatus = 6513;

	StatusCode = 2147749889;

};

\r\n

[13, PID:7524][11/24/2015 10:57:12] :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.d__0.MoveNext()

   at Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlConnectionManager.Connect(String configMgrServerPath)

   at Microsoft.ConfigurationManagement.AdminConsole.SmsSiteConnectionNode.GetConnectionManagerInstance(String connectionManagerInstance)\r\nConfigMgr Error Object:

instance of SMS_ExtendedStatus

{

	Description = "Can't create instance of CSecuredSource for SMS_Site";

	ErrorCode = 3250653696;

	File = "e:\\nts_sccm_release\\sms\\siteserver\\sdk_provider\\smsprov\\sspobjectquery.cpp";

	Line = 2057;

	ObjectInfo = "SMS_Site";

	Operation = "ExecQuery";

	ParameterInfo = "SELECT * FROM SMS_Site WHERE SiteCode = 'STP'";

	ProviderName = "WinMgmt";

	SQLMessage = "[42000][6513][Microsoft][sql Server Native Client 11.0][sql Server]Failed to initialize the Common Language Runtime (CLR) v2.0.50727 due to memory pressure. This is probably due to memory pressure in the MemToLeave region of memory. For more information, see the CLR integration documentation in SQL Server Books Online.";

	SQLSeverity = 16;

	SQLStatus = 6513;

	StatusCode = 2147749889;

};

\r\nSystem.Management.ManagementException\r\nGeneric failure \r\n   at System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode)

   at System.Management.ManagementObjectCollection.ManagementObjectEnumerator.MoveNext()

   at Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlQueryResultsObject.d__0.MoveNext()\r\nManagementException details:

instance of SMS_ExtendedStatus

{

	Description = "Can't create instance of CSecuredSource for SMS_Site";

	ErrorCode = 3250653696;

	File = "e:\\nts_sccm_release\\sms\\siteserver\\sdk_provider\\smsprov\\sspobjectquery.cpp";

	Line = 2057;

	ObjectInfo = "SMS_Site";

	Operation = "ExecQuery";

	ParameterInfo = "SELECT * FROM SMS_Site WHERE SiteCode = 'STP'";

	ProviderName = "WinMgmt";

	SQLMessage = "[42000][6513][Microsoft][sql Server Native Client 11.0][sql Server]Failed to initialize the Common Language Runtime (CLR) v2.0.50727 due to memory pressure. This is probably due to memory pressure in the MemToLeave region of memory. For more information, see the CLR integration documentation in SQL Server Books Online.";

	SQLSeverity = 16;

	SQLStatus = 6513;

	StatusCode = 2147749889;

};

\r\n
 

Does anyone know what I need to check to get this working again?  I have looked at the memory usage of the server and this doesn't appear to be a problem.  SQL is allocated 8GB of memory

[DavetheITguy]

Is this installed on a hyper v machine ?

[Kaz77]

No, it is on the main server - mistake I know but I didn't fully know what I was doing at the time

[Kaz77]

I rebooted the server this morning and now the console starts - What a relief