Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I have just added a login to test an ETL process on a database and I get the error described below when connect using the account I click on the 'Tables' tab on the object explorer on SSMS on a database with the login set up as a user.

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

Additional Information

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

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

This looks like it should be a noddy mistake but I can't find anything that fixes the problem in a quick google search. Any ideas?

share|improve this question
    
Do you get this error when you log in as SA (or equivalant administrator rights)? –  Mark Henderson Jul 21 '09 at 21:26
    
No. Only when I log in as the user I just created. –  ConcernedOfTunbridgeWells Jul 22 '09 at 8:51
    
I posted a somewhat similar question on stackoverflow here: stackoverflow.com/questions/2002773/… –  Rob Garrison Jan 4 '10 at 23:13

1 Answer 1

up vote 1 down vote accepted

Might not be the same thing but I was getting that error today.

Turned out that in my haste to grant a user full access to a database I ticked all the boxes under role members including db_denydatareader, db_denydatawriter.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.