ConfigMgr unable to connect to site database

Chris 221 Reputation points
2021-03-22T23:31:02.823+00:00

I see many people have had this problem and a lot have been solved by applying correct permissions. In my case this has been working for about 5 years straight with no issues and permissions have not changed at all to my knowledge.

What are some other log files I can look at to locate a problem?

The only thing I have done thus far is restart the server and that has not resolved it.
I have 1 primary site and everything is on 1 box, SQL and primary site server are the same server.

80404-1.png

80396-2.png

Microsoft Configuration Manager
0 comments No comments
{count} votes

Accepted answer
  1. AllenLiu-MSFT 40,316 Reputation points Microsoft Vendor
    2021-03-23T06:18:47.76+00:00

    Hi, @Chris
    Thank you for posting in Microsoft Q&A forum.
    If the Logs folder has the wrong permissions the console will not connect.
    We may check if the "C:\Program Files\Microsoft Configuration Manager\Logs" missing the administrators group and the system account? If yes, add them and grant full control for them.
    80515-40.jpg
    And we may refer to this article for more troubleshooting:
    http://schadda.blogspot.com/2012/08/how-to-fix-issues-related-with_7.html
    (Third-party link, just for your reference)


    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.

    1 person found this answer helpful.
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Chris 221 Reputation points
    2021-03-23T13:40:33.863+00:00

    Wow, somehow SYSTEM lost all permissions to the logs folder........
    Very weird, thank you! it is working now