-
Elite Member
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)
-
-
NX GAMES
Re: Help Restoring Database On Virtual PC
delete this on your sql folder " [my database name].mdf "
-
Grand Master
Re: Help Restoring Database On Virtual PC
-
Elite Member
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