Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Merge Replication: Event ID 14151


Merge Replication: Event ID 14151

Author
Message
arrjay
arrjay
SSC Veteran
SSC Veteran (207 reputation)SSC Veteran (207 reputation)SSC Veteran (207 reputation)SSC Veteran (207 reputation)SSC Veteran (207 reputation)SSC Veteran (207 reputation)SSC Veteran (207 reputation)SSC Veteran (207 reputation)

Group: General Forum Members
Points: 207 Visits: 600
Hey All, I'm in the process of setting up Merge Replication on two test databases before I roll it out to our production environment.

The databases are on separate servers within a private LAN. Once I set the merge replication up there is no error given, so the assumption is that it has been set up correctly. However, the subscriber is not receiving any updates from the publisher database. Why?

I have tried troubleshooting this issue by performing;

A telnet to the other SQL port
Ensuring firewall setting have been disabled for this connection
I'm using the correct account details
That the account has been granted access to the subscriber database

The only information I can find that this process is not working is through Windows Event Viewer, I am getting the following error message;

Replication-Replication Merge Subsystem: agent NAGA-AdventureWorks2012-NagaAdevntureWorks-COBAN-6 failed. The process could not connect to Subscriber 'COBAN'.

Can anyone shed some light on this issue?

Thanks! RJ

--------------------------------------------

Laughing in the face of contention...
arnipetursson
arnipetursson
Old Hand
Old Hand (339 reputation)Old Hand (339 reputation)Old Hand (339 reputation)Old Hand (339 reputation)Old Hand (339 reputation)Old Hand (339 reputation)Old Hand (339 reputation)Old Hand (339 reputation)

Group: General Forum Members
Points: 339 Visits: 1019
The merge agent cannot connect to the subscriber.
Either
1. any user cannot connect from the publisher to the subscriber due to network or firewall issues
2. The user you set up as the merge agent user cannot connect to the subscriber instance or does not have sufficient rights in the subscriber database (db_owner role).
arrjay
arrjay
SSC Veteran
SSC Veteran (207 reputation)SSC Veteran (207 reputation)SSC Veteran (207 reputation)SSC Veteran (207 reputation)SSC Veteran (207 reputation)SSC Veteran (207 reputation)SSC Veteran (207 reputation)SSC Veteran (207 reputation)

Group: General Forum Members
Points: 207 Visits: 600
Thanks for your response.

However, I am using the same account that the servers run under for the merge agent. I have tried creating a new user for the merge replication process but this doesn't seem to work either.

Do you have any further suggestions?

Thanks/

--------------------------------------------

Laughing in the face of contention...
Brandon J Williams
Brandon J Williams
SSC Rookie
SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)

Group: General Forum Members
Points: 39 Visits: 927
This is a permissions issue.

If it is a Merge push subscription, ensure the Merge Agent process account is db_owner in the distribution database, a member of the PAL, a login associated with a user in the publication database, and has read permissions on the snapshot share.

If it is a Merge pull subscription, ensure the Merge Agent process account is db_owner in the subscription database and that the account used to connect to the Publisher and Distributor is a member of the PAL, a login associated with a user in the publication database, a login associated with a user in the distribution database, and has read permissions on the snapshot share.

All of this is covered in Replication Agent Security Model.

If you are still have problems after this, increase the -HistoryVerboseLevel to get additional details and/or enable verbose agent logging.
arrjay
arrjay
SSC Veteran
SSC Veteran (207 reputation)SSC Veteran (207 reputation)SSC Veteran (207 reputation)SSC Veteran (207 reputation)SSC Veteran (207 reputation)SSC Veteran (207 reputation)SSC Veteran (207 reputation)SSC Veteran (207 reputation)

Group: General Forum Members
Points: 207 Visits: 600
Hi there - Thanks for the response.

I found that this was related to my snapshot path not being unc formatted. All sorted now.

Thanks.

--------------------------------------------

Laughing in the face of contention...
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search