Can someone help me figure out how to access SQL Server on my network from a Road Warrior W2k VPN client?
PPTP Road Warrior Access is configured using Local Users authentication. The Win2k client can connect to ASL, gets an IP from the PPTP-Pool, can ping all machines on the network and can even access drives on the network.
SQL Server 2000 is installed on a W2k Server that is set up as a Primary Domain Controller. I defined the same user/password combo in Windows, SQL Server and ASL. But still no go. I still can't make a connection to SQL Server.
Not sure if this is related by the Road Warrior client cannot browse the machines on the network (no WINS server?) and it cannot ping or SMB any machine by name. Only IP addresses work.
When I attempt to connect to SQL Server, I use the IP of the server and the name of the SQL Server instance. The same approach works fine from another machine on the network and on the server itself.
What am I missing?
Thanks for your help.
Farid
This thread was automatically locked due to age.
