Configuration Manager console cannot connect to the Configuration Manager site database

Ahmed Yousef 1 Reputation point
2022-03-24T10:13:10.597+00:00

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

Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,269 questions
Microsoft Configuration Manager
{count} votes

10 answers

Sort by: Most helpful
  1. Limitless Technology 39,421 Reputation points
    2022-03-24T17:01:32.053+00:00

    Hello @Ahmed Yousef

    Please try to rebuild your WMI repository on the SCCM server:

    net stop winmgmt

    winmgmt /salvagerepository %windir%\System32\wbem

    winmgmt /resetrepository %windir%\System32\wbem

    Also, check the icalcs permissions on the folder: "Microsoft Configuration Manager"

    Hope this helps with your query,

    ------------

    --If the reply is helpful, please Upvote and Accept as answer--

    1 person found this answer helpful.

  2. AllenLiu-MSFT 41,136 Reputation points Microsoft Vendor
    2022-03-25T06:45:44.293+00:00

    Hi, @Ahmed Yousef

    Thank you for posting in Microsoft Q&A forum.

    It seems the error is same as the below thread I have seen, you may check if the "C:\Program Files\Microsoft Configuration Manager\Logs" missing the administrators group and the system account?

    https://learn.microsoft.com/en-us/answers/questions/326448/configmgr-unable-to-connect-to-site-database.html


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


  3. Ahmed Yousef 1 Reputation point
    2022-03-27T07:38:12.62+00:00

    I must mention that after Vaidation of DCOM Permission , this is what i got ( Unknow user ? )

    187233-screenshot.jpg

    0 comments No comments

  4. AllenLiu-MSFT 41,136 Reputation points Microsoft Vendor
    2022-03-28T09:37:52.13+00:00

    Hi, @Ahmed Yousef

    Thank you for posting in Microsoft Q&A forum.

    The "Account Unknown" should not related to the issue, I see you have "SMS Admins" in the DCOM permission, that should be enough for SCCM console to access the site database.
    For you wmi issue, you may check the article to see if it helps:
    https://hiraniconfigmgr.com/postDetails/43/Unable-to-Connect-1610-Console
    (Please note: Information posted in the given link is hosted by a third party. Microsoft does not guarantee the accuracy and effectiveness of information.)


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


  5. Ahmed Yousef 1 Reputation point
    2022-03-29T07:14:18.38+00:00

    Afte checking the SQL Server 2017 Error Log this is what i got :
    187784-sql.png

    CM_PR1 : this database for SCCM

    0 comments No comments