Error when trying to restore Orion 8.0 MSDE SQL database into MS SQL Server 2005 Express

Question

I have a backup of an Microsoft SQL MSDE database that I made from my Orion 8.0 server.  I try doing a restore into MS SQL Server 2005 express with MS Management Studio Express, but I get the following error.  I tried restoring it with both windows authentication and the sa account and I still get the following error.  Not sure why it is saying access denied.

TITLE: Microsoft SQL Server Management Studio Express------------------------------ Restore failed for Server 'VMNT0009-TEST\ORIONNPM'.  (Microsoft.SqlServer.Express.Smo) For help, click: go.microsoft.com/fwlink ------------------------------ADDITIONAL INFORMATION: System.Data.SqlClient.SqlError: The operating system returned the error '5(Access is denied.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'e:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\NetPerfMon.mdf'. (Microsoft.SqlServer.Express.Smo) For help, click: go.microsoft.com/fwlink ------------------------------BUTTONS: OK------------------------------

mikeyjay · Answer

I believe this may fix the problem.

http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=1634842&SiteID=1

The service account for sqlexpress does not have access/permission. Use Configuration Mgr to change the startup account to LocalSystem (if your database and backup file are on the local machine) or a domain user account that has permission to disk resources (locally and remotely).

The way to change that is to open the config manager, like oj said, and then to go to the services section and right click on SQL Server (the one that's running currently on your machine) and go to properties.  In there is the configuration for the "Log on as" user.

Running as a User can create problem sometimes (security reasons) because user account may have more previledges then the SQL Server account through whihc SQL Service is running. Here is the fix for this issue.

You can specify a location into the file system where 'Everyone' have full access to write or give write permission to the SQL Server user into the file system. After finish this file/folder permission step, restart the restore process you will able to restore your database.

Yann · Answer

Is the MDF file used by another process? (ccollomb.free.fr/.../)

Did you try to attach the database? The .mdf file type is different than the .bak one, thus attaching might work instead of restoring.

HTH,

Yann