The SELECT permission was denied on the object 'configurations', database 'mssqlsystemresource', schema 'sys'

I recently encountered a situation where this error message began appearing to all non-sysadmin logins on a SQL Server.

Most commonly, this is caused by hardening of a SQL Server (the revoking of permissions assigned to PUBLIC) or the user(s) being added to a group that was being denied select permissions.

In this case, it was occurring for all users that didn't have the sysadmin server role.

SP_Helprotect was helpful in diagnosing the problem:



The public role was being explicitly denied select permission to all objects.

The problem was solved by running:


The original cause was not detetmined.