Share via

SCCM Configuration Manager console cannot connect to Site

Trinadhchandra kola 46 Reputation points
2022-12-14T06:40:45.16+00:00

Hi All,

I am getting errors while connecting to SCCM Console. I cannot connect to the Site.

270392-image.png

I have checked everything and all logs, all the logs show same error

* [28000][18456][Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user '. SMS_SITE_COMPONENT_MANAGER 12/14/2022 8:41:39 AM 4528 (0x11B0)
* [28000][18456][Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user '. SMS_SITE_COMPONENT_MANAGER 12/14/2022 8:41:39 AM 4528 (0x11B0)
*** Failed to connect to the SQL Server, connection type: SMS ACCESS. SMS_SITE_COMPONENT_MANAGER 12/14/2022 8:41:39 AM 4528 (0x11B0)

I have reset the site server also, I have checked SQL and SCCM Permission also, all looks good.

Kindly suggest.

Thank You.

Regards,
Trinadh Kola.

Microsoft Configuration Manager Deployment
Microsoft Configuration Manager Deployment
Microsoft Configuration Manager: An integrated solution for for managing large groups of personal computers and servers.Deployment: The process of delivering, assembling, and maintaining a particular version of a software system at a site.
929 questions
0 comments
Accepted answer
  1. Simon Ren-MSFT 31,756 Reputation points Microsoft Vendor
    2022-12-15T02:38:54.13+00:00

    Hi,

    Thanks very much for your feedback and sharing. We're glad that the issue is gone now. It's appreciated that you could click "Accept Answer" to the helpful reply, this will help other users to search for useful information more quickly. Here's a short summary for the problem.

    Problem/Symptom:
    Configuration Manager console cannot connect to Site

    Solution/Workaround:
    Someone Removed the ConfigMgr installation folder permission.
    Added it back and started working.

    Best regards,
    Simon

    If the response is helpful, please click "Accept Answer" and upvote it.
    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.

    2 people found this answer helpful.
    0 comments

5 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Simon Ren-MSFT 31,756 Reputation points Microsoft Vendor
    2022-12-14T08:28:11.433+00:00

    Hi @Trinadhchandra kola ,

    We can add SCCM site server computer account in the SQL logins to have a try.

    Open SSMS and connect to the site database, then navigate to <Server>/Security/Logins, check if the computer account is there.
    If not, add it. If yes, remove it and add it back with the same setting. Then check the results.

    Similar threads for your reference:
    SCCM console launch fails, SQL connectivity issue with SCCM machine account
    SCCM Console Cannot Connect to Database

    Best regards,
    Simon

    If the response is helpful, please click "Accept Answer" and upvote it.
    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.

    0 comments
  2. Trinadhchandra kola 46 Reputation points
    2022-12-14T08:30:16.537+00:00

    Hi @Simon Ren-MSFT

    I have already validate it, it is already part of SQL Login..

    Thank You.

    Regards,
    Trinadh Kola.

    0 comments
  3. Trinadhchandra kola 46 Reputation points
    2022-12-15T00:10:31.6+00:00

    Hi All,

    The issue has been Fixed are added permission to the SCCM ConfigMgr installation folder. Someone Removed the folder permission, I have added it back and started working.

    Thank You.

    Regards,
    Trinadh Kola.

    0 comments
  4. Shaikh, Iqbal 1 Reputation point
    2023-04-11T14:06:58.6766667+00:00

    similar issue windows 20h2 device, recent update was KB5012170 not sure what changed permission added to folders, works now thanks guys