February 1, 2005 at 2:41 pm
We recently went from mixed mode to trusted security.
I am able to connect to the SQL servers without any problems within the office, but when I try to make a trusted connection from home using a vpn tunnel, i get the following error :
A connection to the server cannot be established
Cannot generate SSPI Context
Any ideas on why this could be happening and how it can be resolved ???
TIA
February 1, 2005 at 3:23 pm
Check this out.
February 1, 2005 at 3:34 pm
This is a CLASSIC connection problem. I am going to give you three possiblities / workarounds
1. When you use VPN, generally NT Authentication credentials are not passed to SQL Server by some VPN clients/routers. Check with your network guys if they can change router/client config to allow NT Credentials passed
2. This error is common when using NT authentication with Tcp/IP as the default netlib across a VPN connection. Try using Named pipes as the default netlib
3. Switch to using SQL authentication when connecting from VPN
HTH
* Noel
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply