Cannot connect to SQL Server through VPN

I established a VPN tunnel to my network at work to test merge replication.
While I am able to connect via VPN to my network and ping the server in
which the SQL server resides, I am not able to establish a connection to the
Sql Server to register in my Enterprise Manager. The error I get is "Sql
Server does not exist or Connection OPen [Connect()]. I am running Win2
k
Pro in my home station, sp4, mdac 2.8 and ie6 with all updates. The server
is a win 2k Server with the same updates as my station. Sql Server in both
sides is 2000. The connection method is through DSL. Only two of close to
50 vpn subscribers in my network are experiencing this problem. The
firewall is a Watchguard 2500 firebox, router is a cisco router and the
switch is an HP switch. Some of the other subscribers are also DSL. My
gateway at home is a 2Gateway wireless portal.
Thanks for any help any of you may provide.Run the following command to make sure you can connect to the server through
the sql port, which is 1433 by default:
telnet servername_or_ip 1433
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 programming by Example
"Paul Ohlemacher" <Paul.Ohlemacher@.execupay.com> wrote in message
news:%23%23Hi0fwAEHA.1452@.TK2MSFTNGP09.phx.gbl...
> I established a VPN tunnel to my network at work to test merge
replication.
> While I am able to connect via VPN to my network and ping the server in
> which the SQL server resides, I am not able to establish a connection to
the
> Sql Server to register in my Enterprise Manager. The error I get is "Sql
> Server does not exist or Connection OPen [Connect()]. I am running Wi
n2k
> Pro in my home station, sp4, mdac 2.8 and ie6 with all updates. The
server
> is a win 2k Server with the same updates as my station. Sql Server in
both
> sides is 2000. The connection method is through DSL. Only two of close
to
> 50 vpn subscribers in my network are experiencing this problem. The
> firewall is a Watchguard 2500 firebox, router is a cisco router and the
> switch is an HP switch. Some of the other subscribers are also DSL. My
> gateway at home is a 2Gateway wireless portal.
> Thanks for any help any of you may provide.
>|||Hi,
Can you create a Alias server using "CLient network utility with the
protocol as TCP/IP , IPaddress and Port number.
After that try connecting to SQL server using the Alias name you just
created.
Thanks
Hari
MCDBA
"Paul Ohlemacher" <Paul.Ohlemacher@.execupay.com> wrote in message
news:##Hi0fwAEHA.1452@.TK2MSFTNGP09.phx.gbl...
> I established a VPN tunnel to my network at work to test merge
replication.
> While I am able to connect via VPN to my network and ping the server in
> which the SQL server resides, I am not able to establish a connection to
the
> Sql Server to register in my Enterprise Manager. The error I get is "Sql
> Server does not exist or Connection OPen [Connect()]. I am running Wi
n2k
> Pro in my home station, sp4, mdac 2.8 and ie6 with all updates. The
server
> is a win 2k Server with the same updates as my station. Sql Server in
both
> sides is 2000. The connection method is through DSL. Only two of close
to
> 50 vpn subscribers in my network are experiencing this problem. The
> firewall is a Watchguard 2500 firebox, router is a cisco router and the
> switch is an HP switch. Some of the other subscribers are also DSL. My
> gateway at home is a 2Gateway wireless portal.
> Thanks for any help any of you may provide.
>|||Hari:
Thanks for replying but was one of the first things I've tried...
Any other Idea's?
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23qqDBDyAEHA.3248@.TK2MSFTNGP11.phx.gbl...
> Hi,
> Can you create a Alias server using "CLient network utility with the
> protocol as TCP/IP , IPaddress and Port number.
> After that try connecting to SQL server using the Alias name you just
> created.
> Thanks
> Hari
> MCDBA
>
> "Paul Ohlemacher" <Paul.Ohlemacher@.execupay.com> wrote in message
> news:##Hi0fwAEHA.1452@.TK2MSFTNGP09.phx.gbl...
> replication.
> the
"Sql
Win2k
> server
> both
> to
>|||What port is your SQL server listening on? Check the router at home to
verify you can access that port.
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
"Paul Ohlemacher" <Paul.Ohlemacher@.execupay.com> wrote in message
news:OAtI5tUBEHA.576@.TK2MSFTNGP11.phx.gbl...
> Hari:
> Thanks for replying but was one of the first things I've tried...
> Any other Idea's?
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:%23qqDBDyAEHA.3248@.TK2MSFTNGP11.phx.gbl...
in
to
> "Sql
> Win2k
close
the
My
>|||My suggestion would be to make network traces on both the client and the
server. This will tell you if the traffic is ever reaching the server.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.