May 11, 2013 at 1:53 am
I recently stored SQL Server 2012 on my pc but when I tried to restore any data base it gives me this error:
ADDITIONAL INFORMATION:
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\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\GVApp.mdf'. (Microsoft.SqlServer.SmoExtended)
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
May 11, 2013 at 2:20 am
I solved it...
suggesting solution if someone else faced this issue:
Go the SQL server confiuration manager > select Ib built accounts > Local System
It works like a charm 🙂 :-):-D
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
May 11, 2013 at 3:38 am
SQL should not generally run as local system, it should run under a minimal privileged domain account.
You got the error because SQL did not have permission on the folder with the backup. Instead of switching to local system, just go to the folder, change the security and grant the SQL Server service account full control.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply