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 Win2k
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 Win2k
> 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 Win2k
> 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.
>