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

    mikeyjay

      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

       

      ------------------------------

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

       

      ------------------------------

      BUTTONS:

       

      OK

      ------------------------------