Thursday, December 06, 2012 11:59 AM
I have a SQL server 2008 installed, Transactional(PULL) Replication has been implemented der,everthng was working fine but suddenly snapshots are failing to generate.When I execute the snapshot agent it shows me error that,
Access to the path 'path of a snapshot folder' is denied.
snapshot folder is shared to everyone with all securities,I can access the path through run.Folder is shared to SQL agent and main SQL service.
Thursday, December 06, 2012 12:35 PMModerator
There are two parts to this - the share must be shared to the account which is doing the pulling - apparently you are using the everyone group. This group must have at least read access to the share.
Then the account you are using must have folder rights to read and list files and folders permissions to the folder which underlies the share. So grant this right also to the everyone group. To do this right click on the folder using file explorer and select Properties and Security, then ensure that for the Everyone account you have checked List Folders and Contents, and Read. You may need to click on the Advanced button and select Edit and then do the same thing and ensure that the Replace all child objects... check box is checked.
looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
- Marked As Answer by Maggie LuoMicrosoft Contingent Staff, Moderator Thursday, December 13, 2012 4:25 PM
Friday, December 14, 2012 4:55 AM
Sharing and Security was not an issue....just a SQL service restart is solved my problem.I dont know the root cause bt may be impact was depend on restart.