Problem with Database Restore

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

Categories

No Responses

Leave a Reply

Your email address will not be published. Required fields are marked *