Help Restoring Database On Virtual PC

Results 1 to 4 of 4
  1. #1
    Elite Member bheybhee2008 is offline
    Member +Rank
    Jan 2009 Join Date
    194Posts

    Help Restoring Database On Virtual PC

    System.Data.SqlClient.SqlError: The operating system returned the error '5(Access is denied.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\[my database name].mdf'. (Microsoft.SqlServer.Express.Smo)


  2. #2
    NX GAMES JessB75 is offline
    Grand MasterRank
    Jun 2010 Join Date
    USALocation
    745Posts

    Re: Help Restoring Database On Virtual PC

    delete this on your sql folder " [my database name].mdf "

  3. #3
    Grand Master Jolin88 is offline
    Grand MasterRank
    Aug 2007 Join Date
    EuropeLocation
    2,173Posts

    Re: Help Restoring Database On Virtual PC


  4. #4
    Elite Member bheybhee2008 is offline
    Member +Rank
    Jan 2009 Join Date
    194Posts

    Re: Help Restoring Database On Virtual PC

    Problem Solve...

    My steps in detail.

    1. open up SQL Server Configuration Manager (I am using SQL Server 2005)

    2.right click on SQL Sever Express (I assume it is the same for the full version of SQL Server)

    3.Choose Properties

    4. in the Logon tab - click the built in account radio button and choose 'Local system' from the drop down.

    This worked for me



    good luck all



Advertisement