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.
944 questions
0 comments No comments
{count} votes

Accepted answer
  1. Simon Ren-MSFT 32,371 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 No comments

5 additional answers

Sort by: Most helpful
  1. Steve P 0 Reputation points
    2023-05-11T17:47:10.28+00:00

    I had the same problem

    The above did not work, but the fix was easy. Repair the Configuration Manager Console by going to :

    Control Panel/Programs and Features/Microsoft Endpoint Configuration Manager Console

    and choose Repair.

    0 comments No comments