ConfigMgr unable to connect to site database

Question

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.

Answer 1

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.

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.

Answer 2

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