2

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?

3
1

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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