Configuration Manager console cannot connect to the Configuration Manager site database

Question

Hi ,
after installing The Volume Activation Management Tool (VAMT) , and add Database with name VAMT with sqlcmd :

sqlcmd -S [server name]\MSSQLSERVER
1> USE [VAMT]
2> GO
1> alter table base.GenuineStatusText alter column GenuineStatusText nvarchar(255) NULL
2> GO

I've lost the connection sccm console , After checking the log files , this is what i got :

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 __ExtendedStatus
{
Operation = "ExecQuery";
ParameterInfo = "SELECT * FROM SMS_Site WHERE SiteCode = 'xxx'";
ProviderName = "WinMgmt";
};

Error Code:
ProviderLoadFailure
\r\nSystem.Management.ManagementException\r\nProvider load 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 * FROM SMS_Site WHERE SiteCode = 'xxx'";
ProviderName = "WinMgmt";
};
\r\n

Forgot to mention that i can connect to sql server Remotly with no proplems

Any ideas ?

Best Regards

Answer 1

Hi, @Ahmed Yousef

It seems the issue is related to adding database for VAMT.
And I'm sorry to say this forum does not suppot remote assistance.
If the issue is urgent for you, then it is recommended that you contact Microsoft Customer Support Services (CSS) for a dedicated Support.
Here is the link of CSS support:
https://support.microsoft.com/en-us/hub/4343728/support-for-business

Answer 2

After Deleteing the VAMT Database and uinstall VAMT from the server , iv'e checked the SMSPro.log , and this is what i got :

---

~
$$<SMS Provider><04-03-2022 11:06:24.207-180><thread=10288 (0x2830)>
~ $$<SMS Provider><04-03-2022 11:06:24.208-180><thread=10288 (0x2830)>
CExtUserContext::EnterThread : User=GUEST Sid= Caching IWbemContextPtr=0000020B41F12350 in Process 0x26e0 (9952)~ $$<SMS Provider><04-03-2022 11:06:24.210-180><thread=10288 (0x2830)>
Context: SMSAppName=Configuration Manager Administrator console~ $$<SMS Provider><04-03-2022 11:06:24.211-180><thread=10288 (0x2830)>
Context: MachineName=s2022.dab.local~ $$<SMS Provider><04-03-2022 11:06:24.212-180><thread=10288 (0x2830)>
Context: UserName=DAB\admin~ $$<SMS Provider><04-03-2022 11:06:24.213-180><thread=10288 (0x2830)>
Context: ObjectLockContext=49c21b30-f74a-416c-824c-1f7c79be9eea~ $$<SMS Provider><04-03-2022 11:06:24.213-180><thread=10288 (0x2830)>
Context: ApplicationName=Microsoft.ConfigurationManagement.exe~ $$<SMS Provider><04-03-2022 11:06:24.214-180><thread=10288 (0x2830)>
Context: ApplicationVersion=5.2111.1056.1000~ $$<SMS Provider><04-03-2022 11:06:24.215-180><thread=10288 (0x2830)>
Context: LocaleID=MS\0x409~ $$<SMS Provider><04-03-2022 11:06:24.215-180><thread=10288 (0x2830)>
Context: __ProviderArchitecture=32 ~ $$<SMS Provider><04-03-2022 11:06:24.216-180><thread=10288 (0x2830)>
Context: __RequiredArchitecture=0 (Bool)~ $$<SMS Provider><04-03-2022 11:06:24.217-180><thread=10288 (0x2830)>
Context: __ClientPreferredLanguages=en-US,en~ $$<SMS Provider><04-03-2022 11:06:24.218-180><thread=10288 (0x2830)>
Context: __CorrelationId={00000000-0000-0000-0000-000000000000}~ $$<SMS Provider><04-03-2022 11:06:24.219-180><thread=10288 (0x2830)>
Context: __GroupOperationId=3725 ~ $$<SMS Provider><04-03-2022 11:06:24.219-180><thread=10288 (0x2830)>
CExtUserContext : Set ThreadLocaleID OK to: 1033~ $$<SMS Provider><04-03-2022 11:06:24.220-180><thread=10288 (0x2830)>
Looking for ExtensionProvider instances...~ $$<SMS Provider><04-03-2022 11:06:24.220-180><thread=10288 (0x2830)>
Loading IClassManager: {3B1F3900-A186-11d0-BDA9-00A0C909FDD7}~ $$<SMS Provider><04-03-2022 11:06:24.220-180><thread=10288 (0x2830)>
**** CSspClassManager CONSTRUCTOR~ $$<SMS Provider><04-03-2022 11:06:24.220-180><thread=10288 (0x2830)>
CSspClassManager::Initialize 0~ $$<SMS Provider><04-03-2022 11:06:24.220-180><thread=10288 (0x2830)>
Correctly got registry root dir~ $$<SMS Provider><04-03-2022 11:06:24.220-180><thread=10288 (0x2830)>
Log level = 1~ $$<SMS Provider><04-03-2022 11:06:24.220-180><thread=10288 (0x2830)>
Log path = C:\Program Files\Microsoft Configuration Manager\Logs~ $$<SMS Provider><04-03-2022 11:06:24.220-180><thread=10288 (0x2830)>
SiteInstallRootDir = C:\Program Files\Microsoft Configuration Manager~ $$<SMS Provider><04-03-2022 11:06:24.220-180><thread=10288 (0x2830)>
Minimal Notification Polling Interval = 30 (seconds) ~ $$<SMS Provider><04-03-2022 11:06:24.220-180><thread=10288 (0x2830)>
UseLegacyCardinality=769649360~ $$<SMS Provider><04-03-2022 11:06:24.220-180><thread=10288 (0x2830)>
CSspClassManager::Initialize, Reading SQL db info from registry for sitecode PR1...~ $$<SMS Provider><04-03-2022 11:06:24.220-180><thread=10288 (0x2830)>
Set SQL Machine s2022.dab.local from registry~ $$<SMS Provider><04-03-2022 11:06:24.236-180><thread=10288 (0x2830)>
[HY000][-2146893048][Microsoft][SQL Server Native Client 11.0]SQL Server Network Interfaces: The token supplied to the function is invalid~~ $$<SMS Provider><04-03-2022 11:06:24.252-180><thread=10288 (0x2830)> [HY000][-2146893048][Microsoft][SQL Server Native Client 11.0]Cannot generate SSPI context $$<SMS Provider><04-03-2022 11:06:24.252-180><thread=10288 (0x2830)>
[HY000][-2146893048][Microsoft][SQL Server Native Client 11.0]SQL Server Network Interfaces: The token supplied to the function is invalid~~ $$<SMS Provider><04-03-2022 11:06:24.252-180><thread=10288 (0x2830)> [HY000][-2146893048][Microsoft][SQL Server Native Client 11.0]Cannot generate SSPI context $$<SMS Provider><04-03-2022 11:06:24.252-180><thread=10288 (0x2830)>
*** Failed to connect to the SQL Server, connection type: SMS ACCESS. $$<SMS Provider><04-03-2022 11:06:24.252-180><thread=10288 (0x2830)>
Failed to get sql connection $$<SMS Provider><04-03-2022 11:06:24.252-180><thread=10288 (0x2830)>
~~~X:\bt\1216594\repo\src\SiteServer\SDK_Provider\SMSProv\sspclassmanager.cpp(689) : Failed to get active site server information.~~~ $$<SMS Provider><04-03-2022 11:06:24.252-180><thread=10288 (0x2830)>
~~~Failed to get active site server information. ~~~ $$<SMS Provider><04-03-2022 11:06:24.252-180><thread=10288 (0x2830)>
Found IClassManger: Opal SMS CSsp Provider Extension Implementation.~ $$<SMS Provider><04-03-2022 11:06:24.252-180><thread=10288 (0x2830)>
CExtUserContext::LeaveThread : Releasing IWbemContextPtr=1106322256~ $$<SMS Provider><04-03-2022 11:06:24.252-180><thread=10288 (0x2830)>
SMSPROV DllMain - DLL_PROCESS_DETACH...calling AfxTermExtensionModule~ $$<SMS Provider><04-03-2022 11:07:16.458-180><thread=8204 (0x200C)>
EXTNPROV DllMain DLL_PROCESS_DETACH~ $$<SMS Provider><04-03-2022 11:07:16.458-180><thread=8204 (0x200C)>

Answer 3

Hi ,

I got successfully the console loaded after changing the user in the log on tab in SQL Server Service

is there an explaination ?

thank you

Answer 4

The solution just disable the PKI Client Certificate ,restart the SQL Server and the console was loaded successfuly also the SMS Site , See The picture

Answer 5

SmsAdminUI.log

[1, PID:4212][04/04/2022 10:23:32] :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 __ExtendedStatus
{
Operation = "ExecQuery";
ParameterInfo = "SELECT * FROM SMS_Site WHERE SiteCode = 'PR1'";
ProviderName = "WinMgmt";
};
Error Code:
ProviderLoadFailure
\r\nSystem.Management.ManagementException\r\nProvider load 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 * FROM SMS_Site WHERE SiteCode = 'PR1'";
ProviderName = "WinMgmt";
};
\r\n
[2, PID:4212][04/04/2022 10:23:33] :System.Management.ManagementException\r\nProvider load failure \r\n at System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode)
at System.Management.ManagementObject.InvokeMethod(String methodName, ManagementBaseObject inParameters, InvokeMethodOptions options)
at Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlConnectionManager.ExecuteMethod(String methodClass, String methodName, Dictionary2 methodParameters, Boolean traceParameters)\r\nManagementException details: [2, PID:4212][04/04/2022 10:23:33] :System.Management.ManagementException\r\nProvider load failure \r\n at System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode) at System.Management.ManagementObject.InvokeMethod(String methodName, ManagementBaseObject inParameters, InvokeMethodOptions options) at Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlConnectionManager.ExecuteMethod(String methodClass, String methodName, Dictionary2 methodParameters, Boolean traceParameters)\r\nManagementException details:
[2, PID:4212][04/04/2022 10:23:33] :System.Management.ManagementException\r\nProvider load failure \r\n at System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode)
at System.Management.ManagementObject.InvokeMethod(String methodName, ManagementBaseObject inParameters, InvokeMethodOptions options)
at Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlConnectionManager.ExecuteMethod(String methodClass, String methodName, Dictionary2 methodParameters, Boolean traceParameters)\r\nManagementException details: [2, PID:4212][04/04/2022 10:23:33] :System.Management.ManagementException\r\nProvider load failure \r\n at System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode) at System.Management.ManagementObject.InvokeMethod(String methodName, ManagementBaseObject inParameters, InvokeMethodOptions options) at Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlConnectionManager.ExecuteMethod(String methodClass, String methodName, Dictionary2 methodParameters, Boolean traceParameters)\r\nManagementException details: