SQL Server using Windows Authentication over VPN

[jmondaca]

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.

[sateeshk]

hi

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

[mostiguy]

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?