Tuesday, June 09, 2009 10:09 AMWindows 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?
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.AgentCore.Run() (Source: mscorlib, Error number: 0)
Get help: http://help/0
Tuesday, June 09, 2009 10:57 AMModeratorit 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 PMProblem 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 PMWhich group?
Friday, February 17, 2012 11:03 AM
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 PMModeratorChange 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