Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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:… – Rob Garrison Jan 4 '10 at 23:13
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


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.