Re: can not generate SSPI Context
From: Mike (MichaelLopez_at_inds.com)
Date: 06/25/04
- Previous message: john1811: "Re: ANSI_WARNINGS error in Stored Procedure"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Fri, 25 Jun 2004 16:53:16 -0400
One of the goals of MDAC 2.8 was to tighten security .
SSPI (Security Support Provider Interface ) is used when you are using
Windows Authentication to connect to the SQL server. That is to say the
domain account of the interactive user trying to connect to SQL server is
used.
Sounds like the authentication token is lost or corrupted or something over
the VPN and SQL Server does not see the user as a valid domain account.
Here are some links that I hope help:
http://support.microsoft.com/default.aspx?scid=kb;en-us;820761
http://support.microsoft.com/default.aspx?scid=kb;en-us;814401
http://support.microsoft.com/default.aspx?scid=kb;en-us;821373
Good luck,
Mike
"Chambonneau" <g.chambonneau@castsoftware.com> wrote in message
news:ez6RRaBPEHA.3476@tk2msftngp13.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 ?!?
>
>
>
- Previous message: john1811: "Re: ANSI_WARNINGS error in Stored Procedure"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
