MS SQL Server 2000 VPN problem

Hi,
I'm using MS SQL Server 2000 from long time and its amazing i got stuck this
time. Here is a scenario:
1. I have a client and i used to connect from VPN to login their network and
i can do then whatever i want except i can connect to their MS SQL Server
from my Enterprise Manager as well.
2. I use Remote Desktop Connection to login to different machine so i went
inside the MS SQL Server and see its working fine. Even it works fine when
users are loggin from their local domain name.
Any suggestions will be apreciated.
Thanks.
What is the exact error you get? How are you trying to connect when you get
it (what tool, what protocol, by IP or Name or Name,port or IP,port)?
From a VPN you might need to specify the port since UDP 1434 might be
blocked for certain types of connections. Or even the SQL Server TCP port
(by default it's 1433 for a default instance, it's dynamic for a named
instance) might be blocked by a firewall.
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hi,
Please can you give me steps on how to connect to instance of two SQL Server through VPN.
I shall appricaite it very well.
************************************************** ********************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
|||Yusuf,
test that you can see the server through the SQL tcpip port (default is
1433).
If you're logged on the domain you can use (a) windows authentication,
otherwise you have to use (b) pass-through authentication or (c) sql
standard authentication
Regards,
Paul Ibison