topic SQL Server using Windows Authentication over VPN in Network Access Control

SQL Server using Windows Authentication over VPN

jmondaca — Fri, 21 Feb 2020 18:09:32 GMT

I cannot connect to my SQL Server using Windows Authentication over VPN using VPN client and a PIX 515.

Is this possible or what options do I have?

Thanks.

Re: SQL Server using Windows Authentication over VPN

sateeshk — Fri, 27 Feb 2004 22:47:33 GMT

Are useing windowsNT or win2k?

If ur useing windows

For authentication u need to open some ports i.e

sql = 1433

Ldap udp = 389

ldap gc tcp =1 3268

ldap ssltcp = 3269

Kerberos tcp/udp = 88

rpc = 135

In firewall use

fixup protocol sqlnet 1521

Also check the event viewer in windows2000,what type event ID ur getting.

while try to connect to sql server.

For event ID checking : www.eventid.net

Thanks

Sateesh kumar.k

Re: SQL Server using Windows Authentication over VPN

mostiguy — Sat, 28 Feb 2004 14:27:02 GMT

from the client, can you ping the sql server by hostname? it is probably a name resolution problem. are you passing wins and dns settings to the vpn client?