0

In Microsoft SQL Server Management Studio, I unchecked 'sysadmin' for my Windows user under server roles in Security -> Logins. Now when I try to connect to SQL Server using Windows authentication, I get the error

The SELECT permission was denied on the object 'configurations', database 'mssqlsystemresource', schema 'sys'. (Microsoft SQL Server, Error: 229).

Please help!

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Sava B.
  • 1,007
  • 1
  • 10
  • 21
  • Check if your Windows user has any explicit 'Deny' privileges set. – AHiggins Dec 01 '14 at 18:09
  • 1
    Possible duplicate of [The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'](http://stackoverflow.com/questions/1473315/the-select-permission-was-denied-on-the-object-sysobjects-database-mssqlsyst) – Bacon Bits Dec 01 '14 at 18:10
  • @GoatCO I can't get into management studio at all. All the privileges are set except sysadmin, including all the deny privileges. – Sava B. Dec 01 '14 at 18:44

0 Answers0