Connection SQl 2000 thru modem, Help!!

[Guest]

Archived from groups: microsoft.public.win2000.active_directory (More info?)

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!

 

[Guest]

Archived from groups: microsoft.public.win2000.active_directory (More info?)

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.
--
Ryan Hanisco
MCSE, MCDBA
Flagship Integration Services

"Richard Parco" <RichardParco@discussions.microsoft.com> wrote in message
newsD24FC18-E999-4D42-9192-E4FEDF561A2C@microsoft.com...
> 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!

 

[Guest]

Archived from groups: microsoft.public.win2000.active_directory (More info?)

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.

"Ryan Hanisco" wrote:

> 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.
> --
> Ryan Hanisco
> MCSE, MCDBA
> Flagship Integration Services
>
> "Richard Parco" <RichardParco@discussions.microsoft.com> wrote in message
> newsD24FC18-E999-4D42-9192-E4FEDF561A2C@microsoft.com...
> > 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!
>
>
>