Dear Friends,
I am very new to replication, For learning purpose I am trying to setup merge replication. The given setup I am using.
1. Windows 2000 Server + SP4 (Publisher for SQL 2000)
2. Windows 2003 Server + SP1 (Subscriber For SQL 2000)
I am getting a replication error, I have taken this errors details from merge agent on publisher server.
Find enclosed replication error details in the microsoft document file format (.doc). The document is consist of three SQL Server snapshot rather three diffrent errors.
In the pictures you can find the red & white color cross (wrong sign) on replication monitor tab, I don't know why it is appearing. :confused:
Kindly, give me guidance to rectify this error & setup the marge replication between two SQL 2000 Servers.It appears to be a folder or file permissions issue:
Full (Error) Message : The process could not read file '\\RENMAIL\C$\Program Files\Microsoft SQL Server\MSSQL\ReplData\unc\RENMAIL_pubs_pubs\200604 18105537\publishers_1.sch' due to OS error 5.
OS error 5 is "Access is Denied" (net helpmsg 5).
You need to check the permissions on the folder to which the snapshot is published and verify that the SQL Server Service account for the publisher has read/write access to this folder.
Regards,
hmscott|||Yeah, you're right hmscott that appropriate rights assignment is essential.
But there is other properties also to configured... At the last I have configured "Microsoft SQL Server Replication Remote Dist Agent 8.0" DCOM property on the operating system. The command line to configure DCOM is 'dcomcnfg'.
Now merge replication is working good... Thanx...
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment