add route - ppp connection

[eddiec]

hi everyone,

I have 1 SQL server at a remote site. The site has no permanent connection
to head office.

Once every two hours the remote server will dial head office and synchronise
data with the SQL Server in head office.

How can I set up a route so that the remote server knows that it can find
the head office server on the other side of the ppp connection?

The remote server is connecting as a RAS client to the head office. Every
time that it connects, the interface number changes, so I have to change the
"route add" to point to the new interface number.

How can I get the ppp interface number to remain the same or is there some
other way?

TIA

eddiec

 

[Robert L [MS-MVP]]

not sure the issue. but assuming "the interface number changes" means IP chnaging, you setup static IP for the remote server as client if you have windows server 2003 as VPN server; or use ip pool or assign client ip manualy.

Don't send e-mail or reply to me except you need consulting services. Posting on MS newsgroup will benefit all readers and you may get more help.

Bob Lin, MS-MVP, MCSE & CNE
How to Setup Windows, Network, Remote Access on http://www.HowToNetworking.com
Networking, Internet, Routing, VPN Troubleshooting on http://www.ChicagoTech.net
This posting is provided "AS IS" with no warranties.

hi everyone,

I have 1 SQL server at a remote site. The site has no permanent connection
to head office.

Once every two hours the remote server will dial head office and synchronise
data with the SQL Server in head office.

How can I set up a route so that the remote server knows that it can find
the head office server on the other side of the ppp connection?

The remote server is connecting as a RAS client to the head office. Every
time that it connects, the interface number changes, so I have to change the
"route add" to point to the new interface number.

How can I get the ppp interface number to remain the same or is there some
other way?

TIA

eddiec

 

[Bill Grant]

Like Robert, I am not sure what you mean here. Why do you need to add a
route to the client? By default, the client will send all traffic over the
VPN link. Have you disabled the "use default gateway.." option?

Do you need to add the "received" IP address into a route command? You
would probably need to use a script of some sort to retrieve the received IP
and plug it into the route command.

You can force the connection to always get the same IP, but I think it
only works in W2k native mode or W2k3.

 

[eddiec]

hi Bill and Robert,

The remote server is on the same subnet as the head office network.
Therefore:

If I create a PPP RAS dial-up connection in which the server dials head
office and is assigned an IP in the head office LAN range, the remote server
can access everything at head office fine. However the single workstation
connected to the remote server at the remote site becomes unable to
communicate with the server. The reason being that the server cannot
differentiate between the local and head office networks and becomes
confused.

If I set the IP addresses assigned to the remote server to be in a different
subnet then the remote network continues to function OK even after the
server has dialled head office. However, in order to tell the remote server
that the head office server that it has to access is on the other side of
the PPP connection, I created a route that defines the particular IP needed
as being on the other side of the PPP connection.

eg route ADD 10.0.0.30 MASK 255.255.255.255 192.168.200.10 METRIC 3 IF
0xa0006

The head office server that the remote server has to access is 10.0.0.30
192.168.200.10 is the IP assigned to the PPP connection

This works fine, however there is a problem

Every time the remote server reconnects to the RAS server at head office,
the IP address it receives remains the same however the interface number
(that can be seen if you run 'route print' changes.

Therefore I am unable to add a static route pointing to the PPP connection
as the interface number keeps on changing.

HELP!

TIA

eddiec

 

[Bill Grant]

I would recommend that you change the IP addresses of the machines in
the branch office. You are always going to have trouble trying to route
between sites which use the same IP subnet.