2 Replies Latest reply on Dec 10, 2008 9:29 PM by mikeyjay

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


      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: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476





      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: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&LinkId=20476