Last week, I restored a database from backup and was having the following error when trying to access the tables:
“The SELECT permission was denied on the object ‘extended_properties’, database ‘mssqlsystemresource’, schema ‘sys'”.
After some research, I found the next solution:
Solution for SQL Server
Actually after the MSSQL database restore it get’s orphan and the database user schema is over-written; hence de-attaching the database user and then re-attaching it back or deleting the database user and re-attaching it back will solve the Issue.
Solution for Website Panel
You can do that from WebSitePanel > Databases > MSSQL 2008 > Database > un-check the database user and then repeat the process and check (assign user) back again.
Hope this helped you, and happy restoring
No Responses