Re: Unable to Generate SSPI Context w/ .Net 2.0 App and Windows 2000 Professional Client

We see this all the time when we do off-domain demos in the field. The best solution (IMHO), is to not use SSPI, but a work-around is to log into the local machine (not the domain) and let the local system authenticate the user.

--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________

"GSC" <greg.cheek@xxxxxxxxx> wrote in message news:cd7be41c-6b53-4ff3-99cf-d7832fe20fb3@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I have a C# .Net App using Windows trusted security connecting to a
Sql server 2000 (running on a Windows 2000 Server). If I change the
connection parameters to use a SQL Account it works fine, but when I
change it to use NT Security, it fails with Unable to Generate SSPI
Context. The same app works fine on XP Professional machines on the
same network. Also, I have many Delphi applications running on the
same machine using Windows Authentication that work fine; but they are
not .Net apps, just standard Win32 applications.

Any help or suggestions would be greatly appreciated.

Thanks

.

Relevant Pages

  • Re: Unable to Generate SSPI Context w/ .Net 2.0 App and Windows 2000 Professional Client
    ... local machine and let the local system authenticate the ... Hitchhiker's Guide to Visual Studio and SQL Server ... Sql server 2000 (running on a Windows 2000 Server). ... change it to use NT Security, it fails with Unable to Generate SSPI ...
    (microsoft.public.sqlserver.connect)
  • Re: login failed for sql server
    ... I can't swear to it but I think using SSPI and a User Id are mutually ... I also seem to remember having this issue if my Sql Server instance was ... not setup to support Mixed security. ... ive even hardcoded the user name in the connection string. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Unable to connect if member of many groups
    ... I have a setup where Acitive Domain users are member of many groups. ... the user cannot connect to the SQL Server ... of more than 269 groups I get the "Cannot generate SSPI context" error. ...
    (microsoft.public.sqlserver.connect)
  • Re: Connect to Desktop SQL Server 2000 from Pocket PC
    ... SSPI is in fact supported, but you have to provide user ID and password ... This might be useful if SQL authentication is disabled on a server. ... > Xref: cpmsftngxa10.phx.gbl ... >> I need to connect from a program in the Pocket PC to SQL Server in my ...
    (microsoft.public.dotnet.framework.compactframework)