Printable View
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)
delete this on your sql folder " [my database name].mdf "
Problem already covered here : http://forum.ragezone.com/f528/guide...oblems-726958/
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