I need to set up simple replication between a server in a managed
hosting environment and our office (connection being made via a VPN).
Hosted end will be the publisher/distributor and our end will be the
subscriber. Problem is at the hosted end our servers are not within a
private domain and the hosting company will not set up trust
relationship between our end and theirs because it will compromise the
other servers in their public domain.
I understood from SQL BOL that it is necessary to have a Trust
relationship set up between publisher and subscriber if the boxes are in
It has been suggested by someone that it is possible to still perform
replication if I have an identical SQL login on both boxes. Can anyone
categorically confirm or deny this, or suggest any other means of
setting up this replication given the environment that we have.
I'd really appreciate any help that anyone can give me on this ASAP. We
sell rare and collectable music on our site and I'm _more_ than willing
to bribe (or corrupt) someone who can help me!!