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

Hello, nice to meet you

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Leave a Reply