Monday, March 12, 2012

Replication over WAN setup

Hello, I'm newbie in replication field. At the moment, I am able to setup replication on LAN (1 distributor to few subcribers). However, I found some difficulties on setting-up the replication on WAN. Is there any guidelines, setup documents or examples (like print screen) for me to refer to ? Hope able to get any assistance at here.

Best Regards,

Hans

Hello Hans,

What kind of difficulties did you see? Can you list them?

Thanks.

|||

are you replicating between two different domains? If so, please reference this support article: http://support.microsoft.com/kb/321822/en-us.

If not, please give us some more info, such as complete error number and error message.

|||

First define if the problem is the network connection (routing, firewall, e.t.c.)

Then if it is a security problem (different domains without trust, accounts with improper rights, wrong passwords, e.t.c.)

Lastly if it is a SQL config problem (e.g. are you running the SQL service with the SA account?)

Can you give more details?

|||

Sorry for the late reply guys, I guess I just figure out my problem. For WAN setup, wat I need is have to do some alias mapping for the server that I wanna connect (subscriber or publisher server). Once did the mapping , replication is able to run. :) Thx for the advice by the way.

Best Regards,

Hans

No comments:

Post a Comment