question

Chitrarekha avatar image
Chitrarekha asked

Transactional Replication

I have followed the link below to create transactional replication http://www.sql-server-performance.com/2010/transactional-replication-2008-r2/ When I click on the Publication and launch Replication Monitor, snapshot agent error Source: mscorlib Target Site: Void WinIOError(Int32, System.String) Message: Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\ReplData\unc\DEVWINSQL3_ABRAEMPLOYEESELFSERVICE_ABRASELFSERVICE_PUBLICATION\20120620160002\' 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) How do I fix the error message, will the above document assist me in setting up transactional replication?
sql-server-2008-r2replication
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

·
KenJ avatar image
KenJ answered
When you create your snapshot it needs to be in a location that is accessible to both servers. The second computer cannot see the path on the C:\ drive of the first computer.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Chitrarekha avatar image
Chitrarekha answered
In this case I have actually created in the same server so do not know why it cannot find the path. In the link below it is http://www.sql-server-performance.com/2010/transactional-replication-2008-r2/ the server on which the Replication is configured will itself be holding the distribution database. Can I choose a different server and the distribution database will be configured on a different server.
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

KenJ avatar image KenJ commented ·
The tutorial you linked to says the snapshot "should never be placed on the C drive of the server i.e. the drive which is hosting the Operating System" Double check to make sure the account you set up the snapshot agent with has access to your path.
3 Likes 3 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.