Unable to connect through routed network

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: knoche (knoche_at_gmail.com)
Date: 01/28/05 

Date: 28 Jan 2005 06:29:21 -0800

Hello everyone...

I'm trying to setup publishing on my 2 SQL servers for backup purposes.

Main SQL server - (win2k)2 node clustered sql server with ip address of
192.168.0.245

Backup SQL server - (win2k)ip address of 192.168.1.2

I have a VPN connection set up between the two. I also have DFS
running that works fine through the routes.

The routing is working fine. From the backup server, I can ping EVERY
SINGLE IP in the 192.168.0.0/27 range EXCEPT the sql server ip
(192.168.0.245). I can even ping the cluster IP that the SQL service
resides which is .250

>>From a pc in the 192.168.0.0/27 network, I can connect to .245 fine.

I'm honestly a bit lost of even where to look for solutions on this.
Any suggestions or ideas would be greatly appreciated

*Note: the clustered sql server is working fine and not the issue (it's
been running the way it is for about 2 yrs now)

Relevant Pages

  • Cant ping certain ip through route
    ... I'm trying to setup publishing on my 2 SQL servers for backup purposes. ... Main SQL server - 2 node clustered sql server with ip address of ... From the backup server, I can ping EVERY ...
    (microsoft.public.win2000.networking)
  • Cant ping SQL VS IP through route
    ... I'm trying to setup publishing on my 2 SQL servers for backup purposes. ... Main SQL server - 2 node clustered sql server with ip address of ... From the backup server, I can ping EVERY ...
    (microsoft.public.windows.server.clustering)
  • Re: Reconnect does not work TADOconnection
    ... On your timed ping, how often are you pinging the server to keep it active? ... We've dealt with similar issues using ADO and SQL Server. ... connection from SQL is dropped, the ADOConnection remains active until you ... Using an exception handler something like this: ...
    (borland.public.delphi.database.ado)
  • Re: Unable to ping some machines - others ok???
    ... The IP Address of the laptop ... The IP Address of the SQL server ... > decided to attempt to ping the machine to troubleshoot the issue. ... > successfully able to ping other machines on the LAN no probs. ...
    (microsoft.public.windowsxp.security_admin)
  • Re: SQLSMS - Cannot Connect SQL Server 2000
    ... On the right-side make sure TCP/IP is enabled. ... I take it the NewXP computer can ping the laptop by both IP ... Rick Byham, SQL Server Books Online ...
    (microsoft.public.sqlserver.setup)