Problem setting up snapshot replication

Question

Problem setting up snapshot replication

Stefaans

SSC-Addicted

Points: 488
More actions
December 14, 2009 at 8:30 am

#207360

I have tried to set up snapshot replication using SQL Server 2008 with the Publisher, Distributor and Subscriber on the same PC.
I have used the wizard to configure the subscription but I cannot create the initial subscription. The error message that I receive is shown below.
Any ideas would be most welcome.
Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL10.SSC20460\MSSQL\ReplData\unc\SSC20460$SSC20460_SANDBOX_PUBLISHER_MYTESTPUBLICATION\20091214101234\' is denied.
Error messages:
Source: mscorlib
Target Site: Void WinIOError(Int32, System.String)
Message: Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL10.SSC20460\MSSQL\ReplData\unc\SSC20460$SSC20460_SANDBOX_PUBLISHER_MYTESTPUBLICATION\20091214101234\' 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.SqlServerSnapshotProvider.GenerateSnapshot()
at Microsoft.SqlServer.Replication.SnapshotGenerationAgent.InternalRun()
at Microsoft.SqlServer.Replication.AgentCore.Run() (Source: mscorlib, Error number: 0)
Get help: http://help/0