PENDING Cannot connect to site after large software update deployment

[mhpk0]

We migrated to a new SCCM server a few months ago. Now, every month that we deploy software updates, I am unable to connect to the configuration manager console with the error "Configuration Manager cannot connect to the site." When I check resources(16CPU, 24GB Memory allocated) the CPU usage is around ~10% usage and memory about ~65% usage. After rebooting the server, everything works as normal. I checked SMSAdminUI.log and see the following:

[1, PID:31660][07/23/2024 20:59:52] :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 SMS_ExtendedStatus
{
    Description = "Can't create instance of CSecuredSource for SMS_Site";
    ErrorCode = 3250653696;
    File = "D:\\dbs\\sh\\cmgm\\0502_134106\\cmd\\1g\\src\\SiteServer\\SDK_Provider\\SMSProv\\sspobjectquery.cpp";
    Line = 2082;
    ObjectInfo = "SMS_Site";
    Operation = "ExecQuery";
    ParameterInfo = "SELECT * FROM SMS_Site WHERE SiteCode = 'XXX'";
    ProviderName = "WinMgmt";
    SQLMessage = "[HY000][596][Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Cannot continue the execution because the session is in the kill state.";
    SQLSeverity = 21;
    SQLStatus = 596;
    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.<GetEnumerator>d__75.MoveNext()\r\nManagementException details:
instance of SMS_ExtendedStatus
{
    Description = "Can't create instance of CSecuredSource for SMS_Site";
    ErrorCode = 3250653696;
    File = "D:\\dbs\\sh\\cmgm\\0502_134106\\cmd\\1g\\src\\SiteServer\\SDK_Provider\\SMSProv\\sspobjectquery.cpp";
    Line = 2082;
    ObjectInfo = "SMS_Site";
    Operation = "ExecQuery";
    ParameterInfo = "SELECT * FROM SMS_Site WHERE SiteCode = 'XXX'";
    ProviderName = "WinMgmt";
    SQLMessage = "[HY000][596][Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Cannot continue the execution because the session is in the kill state.";
    SQLSeverity = 21;
    SQLStatus = 596;
    StatusCode = 2147749889;
};
\r\n

 

[mhpk0]

Anyone?