Environment: 1 SCCM build 2403 site server installed on a Windows Server 2022 Datacenter hosting couple of SCCM roles including the SQL Server 2022 database. The site server has been working for awhile. It was shutdown for about a week and now the SCCM console is not opening – here is the error found on the SmsAdminUI.log:
"[1, PID:1812][12/05/2024 12:42:52] :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.<GetEnumerator>d__75.MoveNext()\r\nManagementException details:
instance of __ExtendedStatus
{
Operation = "ExecQuery";
ParameterInfo = "select SiteType From SMS_SCI_SiteDefinition where SiteCode='FRE'";
ProviderName = "WinMgmt";
};
\r\n"
I have completed the following steps without any resolution:
SCCM Service Account is unlocked and has not expired
SCCM SA and system account have full control of the CM and database local data folders
SCCM SA account has read/write access to all databases (CMDB, SSRS, WSUS...) hosted on the same SQL Server 2022 (it is a tiny lab environment with the site server and SQL installed on the same Windows server 2022). SSRS, WSUS applications are working properly and connecting to SQL Server
SQL Server 2022 license is standard edition and has not expired
CM license has not expired
Stopped, uninstalled, reinstalled MSDTC service and reboot
SCCM SA account can login to SQL Server Management Studio and confirmed all databases are running
I ran a Data link test connection to the database using the SCCM SA account but it is failing to connect. This was working before, the only changes made on this server was monthly windows patches.
"[1, PID:1812][12/05/2024 12:42:52] :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.<GetEnumerator>d__75.MoveNext()\r\nManagementException details:
instance of __ExtendedStatus
{
Operation = "ExecQuery";
ParameterInfo = "select SiteType From SMS_SCI_SiteDefinition where SiteCode='FRE'";
ProviderName = "WinMgmt";
};
\r\n"
I have completed the following steps without any resolution:
SCCM Service Account is unlocked and has not expired
SCCM SA and system account have full control of the CM and database local data folders
SCCM SA account has read/write access to all databases (CMDB, SSRS, WSUS...) hosted on the same SQL Server 2022 (it is a tiny lab environment with the site server and SQL installed on the same Windows server 2022). SSRS, WSUS applications are working properly and connecting to SQL Server
SQL Server 2022 license is standard edition and has not expired
CM license has not expired
Stopped, uninstalled, reinstalled MSDTC service and reboot
SCCM SA account can login to SQL Server Management Studio and confirmed all databases are running
I ran a Data link test connection to the database using the SCCM SA account but it is failing to connect. This was working before, the only changes made on this server was monthly windows patches.
Last edited:
