Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Access Denied to SQL Replication Snapshot folder

Answered Access Denied to SQL Replication Snapshot folder

  • Thursday, December 06, 2012 11:59 AM
     
     
    Sign In to Vote
    0

     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.

    ANY HELP........?

     

All Replies

  • Thursday, December 06, 2012 12:35 PM
    Moderator
     
     Answered
    Sign In to Vote
    0

    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

     
  • Friday, December 14, 2012 4:55 AM
     
     
    Sign In to Vote
    0

    ISSUE RESOLVED------

     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.