Problem in restoring share point ? Error SQLException access to module is blocked

If you encounter this error, while restoring your sharepoint to another share point server,

Object Project Server Application failed in event OnPostRestore. For more information, see the error log located in the backup directory. SqlException: Access to module dbo.proc_MIP_GetObjectVersion is blocked because the signature is not valid.

This is could be due to that the shared services cannot be install in SQL server 2005 embedded version. The error when creating a new shared services "SSP Databases cannot be created in the Windows Internal Database; they must be created in SQLExpress or a full SQL Server installation"

or these error

Access to the table dbo.sites is blocked because the signature is not valid.
Access to module dbo.proc_GetCurrent is blocked because the signature is not valid.

Please follow the below guide,

This will provision the SPWebService service has not been fully provision after we restored.http://kbalertz.com/944154/receive-error-message-browse-SharePoint-collections-after-hotfix-package-public-update-Windows-SharePoint-Services-applied.aspx

If you still has error, then follow this guide to Restore a shared service provider administration site.

http://blog.tylerholmes.com/2008/03/restoring-shared-service-provider-admin.html

To check the shared services db is the problem , login to ms sql and query the shared_services1_db tables and you will see error.