up vote 1 down vote favorite
share [g+] share [fb]

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?

link|improve this question
56% accept rate
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
feedback

1 Answer

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.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

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