Connecting to SQL Server over a VPN & through a router... -- sql server connect

LemonSmasher NO[at]SPAM hotmail.com
8/19/2005 1:37:35 PM

Hi All,

I have a NetGear combined wireless router / ADSL modem, and am
attempting to connect to SQL Server from my (wifi enabled) laptop, but
am getting a 'failed to create SSPI context' message (note that I'm
using Windows Authentication). I'm connected to my work LAN through a
SonicWall VPN. If I take the router out of the equation, I can connect
fine - even through the VPN.

Outlook also has no luck connecting - it appears that some aspect of
Windows Authentication is broken by the router being included in the
setup.

I can ping machines on my company LAN when connected through the
router, and can also connect to SQL server using the SS authentication
- so I'm not far away from being able to authenticate.

Any thoughts/help would be much appreciated.

Thanks,

Will (LemonSmasher)

LemonSmasher NO[at]SPAM hotmail.com
8/19/2005 4:03:07 PM

Mmm... looks like I've 'solved' this. Having established the VPN
connection for the first time, I logged off of Windows, then logged
back on, reestablished the VPN connection and then authentication
worked. Must've been down to something being cached in my original
session - if anyone can shed light on this (or if its just a lucky
coincidence!), I'd be interested in hearing from you!

Will.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server connect

sql server connect : Connecting to SQL Server over a VPN & through a router...