Trouble with Snapshot -- sql server replication

Shep
10/6/2005 2:42:07 PM

I am trying to setup a simple mirrored database.
I have an SQL database on my local server called 'ABC'. It is behind my
firewall and available to on my network.
I have another database outside of my network at a co-location center that I
want to mirror to (call it 'EFG').
I have made most of the changes that I think were necessary to make this
happen but I am still missing something.
I have opened up a port on my router for the IP address of the database at
the co-location center and opened up the router at the co-location center to
my local server. This enables me to connect to the co-location database
locally using the IP Address of the remote server. Works great.

The problem is that I cannot seem to setup a publisher and subscriber. The
subscriber keeps complaining.

'The process could not connect to Distributor 'ABC'.'

My guess is that the server is trying to use the servername ABC instead of
the IP Address to connect. How can I correct this. I cann successfully
connect to either dataase using the IP but no matter what I do the subscriber
trys to connect to the database name, which the server cannot resolve.

This may not be a replication problem so much as a problem in making each
server know how to resolve the name of the remote server from its IP Address.

Raymond Mak [MSFT]
10/6/2005 6:35:03 PM

Hi Shep,

Judging from what you described below, it appears that you have set up a
pull subscription. This makes accomplishing what you want to achieve a bit
more difficult as you need to arrange both SQL access (to the distributor)
and (snapshot) file access through the firewall (you can setup VPN or FTP for
this). As such, it may be better to use a push subscription so the
Distributor can push data through the firewall from the publisher network to
your subscriber at your co-lo. Either way, you need to establish a SQL
connection through the firewall without the benefit of WINS (i.e. you have to
use IP address). This can be accomplished by setting up an alias on the
machine where the distribution agent is running that maps the server name to
the IP address of the remote machine. Or, you can use the
-Distributor|SubscriberNetwork parameters of the distribution agent to
specify the IP address of the remote machine while using the server name for
the Distributor|Subscriber parameters.

HTH

-Raymond

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server replication

sql server replication : Trouble with Snapshot