June 24, 2013 at 3:19 am
Hi all,
When i am trying to restore a database with the backup i am getting this error
06/24/2013 14:30:54,spid59,Unknown,The operating system returned the error '5(Access is denied.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\IPE_OCT_120_log'.
06/24/2013 14:30:54,spid59,Unknown,Error: 3634<c/> Severity: 16<c/> State: 1.
i am unable to figure it out.
June 24, 2013 at 3:46 am
It looks like the folder 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\IPE_OCT_120_log' doesn't exist or the SQL service account doesn't have read/write access to that folder.
June 24, 2013 at 3:51 am
how to give permissions to service accounts. how to check what permissions the existing service account have. can any one throw some light on it . any useful material.
June 24, 2013 at 3:55 am
Changing permissions on a folder is done from within Windows. You can use the Windows Explorer and open the properties of the folder. Use the security tab to add accounts and add/change permissions.
June 24, 2013 at 5:57 am
i am not able to see any service accounts in security ... can any one give further more details.
June 24, 2013 at 7:57 am
See which account the SQL Server process is run as. Grant privileges to that one.
June 25, 2013 at 7:07 am
Please follow the below procedure.
Open SQL Server configuration manager
Check the service account
Browse the appropriate folder where backup file exists
Open the properties of server then click on security tab
Add the service account and provide the read write permissions.
Thanks,
I’m nobody but still I’m somebody to someone………….
June 25, 2013 at 7:22 am
i cant see any service accounts i can see only domain user accounts there. do we need to add service acount in security tab
June 25, 2013 at 8:23 am
Is backup path accessible from the server where you are restoring?
Thanks,
I’m nobody but still I’m somebody to someone………….
June 26, 2013 at 12:14 am
m.rajesh.uk (6/25/2013)
i cant see any service accounts i can see only domain user accounts there. do we need to add service acount in security tab
The user account that is used to run a service is referred to as a "Service Account". A service account is NOT an account you will find literally in AD or a user list.
Grant the domain account that is used to run the SQL Service (see steps in the post from 'sweetmoulali') the read/write permissions on the folder.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply