Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
SQL 2008. Merge replication. Snapshot agent. Access Denied

Unanswered SQL 2008. Merge replication. Snapshot agent. Access Denied

  • Tuesday, June 09, 2009 10:09 AM
     
     
    Sign In to Vote
    0
    Windows Server 2008 Standard x64 SP1, SQL Server 2008 Enterprise Edition x64 SP1
    Snapshot agent has read-write permissions to ReplData folder but cannot access local snapshot folder. How to resolve this error?

    Error messages:
    Source: mscorlib
    Target Site: Void WinIOError(Int32, System.String)
    Message: Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\ReplData\unc\ServerName_DatabaseName_PublicationName\DateTime\' is denied.
    Stack:    at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
       at System.IO.Directory.InternalCreateDirectory(String fullPath, String path, DirectorySecurity dirSecurity)
       at System.IO.Directory.CreateDirectory(String path, DirectorySecurity directorySecurity)
       at Microsoft.SqlServer.Replication.Utilities.CreateDirectoryWithExtendedErrorInformation(String directory)
       at Microsoft.SqlServer.Replication.Snapshot.SnapshotProvider.CreateSnapshotFolders()
       at Microsoft.SqlServer.Replication.Snapshot.MergeSnapshotProvider.CreateSnapshotFolders()
       at Microsoft.SqlServer.Replication.Snapshot.SqlServerSnapshotProvider.GenerateSnapshot()
       at Microsoft.SqlServer.Replication.SnapshotGenerationAgent.InternalRun()
       at Microsoft.SqlServer.Replication.AgentCore.Run() (Source: mscorlib, Error number: 0)
    Get help: http://help/0
     

All Replies

  • Tuesday, June 09, 2009 10:57 AM
    Moderator
     
     
    Sign In to Vote
    0
    it also needs list files and folders rights as well.
    looking for a book on SQL Server replication? http://www.nwsu.com/0974973602.html 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
     
  • Tuesday, June 09, 2009 2:33 PM
     
     
    Sign In to Vote
    0
    Problem is resolved.
    Snapshot agent is executed with sql server account. Not account that is used for merge agent. And there is some problem with installation and sql server account was not in special user group (that has required permissons) created by setup. After I explicitely added sql server account to mentioned group the error was disappeared.
     
  • Sunday, October 24, 2010 12:45 PM
     
     
    Sign In to Vote
    0
    Which group?
     
  • Friday, February 17, 2012 11:03 AM
     
     
    Sign In to Vote
    0

    I am also getting the same access denied problem for Snapshot agent. Could you please let me know which SQL account you added in which group. Please help me to resolve the problem.....

    Would like to mention here that i am getting this error for transactional replication...

    • Edited by Onkar Saini Friday, February 17, 2012 11:04 AM
    •  
     
  • Friday, February 17, 2012 4:25 PM
    Moderator
     
     
    Sign In to Vote
    0
    Change the default snapshot folder to a different location like c:\temp. IIRC disabling user account control also fixes this.

    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