I am the epitome of the accidental DBA so keep that in mind. Our primary SQL Server all of a sudden started denying permissions to users to access the server (any database). The only users who can access the server are those with sysadmin permissions. Nothing has "changed" to cause this - that anyone is aware of. This has happened before and the only way to correct it has been to restart the whole server. The SQL Service was restarted and that doesn't resolve the problem.
I am not a systems person so I have few rights to do things like RDP to the server in question, check security groups via Active Directory, etc. Yes I know that makes this hard to diagnose. I can get to the databases via SSMS because I have sysadmin permissions.
I was wondering if anyone has seen this before or could point me to any literature. I have done the obligatory Google search and didn't see anything particularly germane to the subject matter.
We will be taking the server down tonight to resolve the issue but I would much prefer to identify the cause and fix the problem rather than burn down the house to get rid of the mouse.
Thanks in advance for your time and consideration.