SELECT permission denied object 'configurations'

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

SELECT permission denied object 'configurations'

Author

Topic

marksullivan
Starting Member

2 Posts

Posted - 2008-02-11 : 16:41:30

A client has the following SQL Server 2005 error. The user is unable to log into Management studio. We deleted the user and login and re-created the user and login and get the same error. FYI: If the user is given db_owner and all login privs except sysadmin he gets the error. Only syslogin grants him access. It looks like he is denied access to sys.configurations via the new resource database. Any thought?

The error:

Cannot get to <instance name>.

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

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

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-02-11 : 22:41:08

What's sp level? Use windows or sql authentication? What's default db for the user?