Connection SQl 2000 thru modem, Help!!

[Guest]

i'm using Enterprise Edition of SQL 2000 on two servers, one on a head office
and a remote server. The head office server is the parent server and the
remote one is configured as a child of the head office. i'd use the DNS
address of the child server as alternate DNS address for the head office and
vice versa.

I'm trying to establish a transactional replication for the remote server
with the publication and distributor running on the head office thru a modem
connection of 33.6 kbps. All agents of my Replication Monitor are all systems
go, one problem is my distribution agent (the agent cannot find the subsriber
on the remote server). Although i already registered the remote server on my
local SQL server.

I need your help here guys!

 

[Ryan Hanisco]

Richard,

I am assuming that you are using Dial on Demand Routing (DoD Routing) to get
these sites to talk to one another. So the question is, what communication
ARE you getting? Can you ping? By name and IP Address? Can you do a port
scan and see the SQL port (TCP1433)? Can you connect across the MODEM link
with the Enterprise Manager?

Once we know you have good communication, then you can start troubleshooting
the database replication. I will point out that this is a very small pipe
for database replication. How often are you publishing? What replication
model are you trying to use?

Give us some more information about your topology and what you are trying to
do and maybe we can be of more help.

 

[Guest]

I'd already established my connection, i'd already can see the files on the
remote computer, and register the remote server's SQL on my local SQL
Enterprise Manager. The remaining problem was the error on the distribution
agent of the SQL 2000.