can not generate SSPI Context

Hello everybody
I have a VB6 app using Trusted Connection to a SQL Server 2000.
This application can also run when creating a VPN Connection and using a
TCP/IP Connectionstring
I upgrade my MDAC installation (2.8) and now when I tried to run my app over
VPN, I obtain: "cannot generate SSPI Context"
It runs without problem in LAN using Trusted but not anymore over VPN.
Can anyone help me ?!?Have a look at
HOW TO: Troubleshoot the "Cannot Generate SSPI Context" Error Message
http://support.microsoft.com/defaul...kb;en-us;811889
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Chambonneau" <g.chambonneau@.castsoftware.com> wrote in message
news:%23xis2GBPEHA.3744@.TK2MSFTNGP11.phx.gbl...
> Hello everybody
> I have a VB6 app using Trusted Connection to a SQL Server 2000.
> This application can also run when creating a VPN Connection and using a
> TCP/IP Connectionstring
>
> I upgrade my MDAC installation (2.8) and now when I tried to run my app
over
> VPN, I obtain: "cannot generate SSPI Context"
> It runs without problem in LAN using Trusted but not anymore over VPN.
> Can anyone help me ?!?
>|||Also don't forget to look at the hosts and lmhosts files in your system32
folder.
You need the correct hosts configuration in there. There are a variety of
problems that can cause the SSPI error and a change of hosts file config
sorted mine out on most client machines but I still have the problem on two
of them where it drops off after 45 mins for no apparent rhyme or reason.
The hosts file that works for me looks like this (bar the IBM manufactured
PC's)
127.0.0.1 localhost.uk-resources.net
127.0.0.1 mypc.uk-resources.net
192.168.16.2 ourserver.uk-resources.net
Don't forget to backup the original hosts and lmhost file before changing
anything.
There is some issue I recall seeing when researching the problem a few
months ago about the way the DNS resolves when using vpn and it may be
router related.
Regards,
Paul
"Chambonneau" <g.chambonneau@.castsoftware.com> wrote in message
news:%23xis2GBPEHA.3744@.TK2MSFTNGP11.phx.gbl...
> Hello everybody
> I have a VB6 app using Trusted Connection to a SQL Server 2000.
> This application can also run when creating a VPN Connection and using a
> TCP/IP Connectionstring
>
> I upgrade my MDAC installation (2.8) and now when I tried to run my app
over
> VPN, I obtain: "cannot generate SSPI Context"
> It runs without problem in LAN using Trusted but not anymore over VPN.
> Can anyone help me ?!?
>sql