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

On Jun 6, 12:06 pm, "William Vaughn [MVP]" <billvaNoS...@xxxxxxxxx>
wrote:
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.ch...@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

These PC's are in the same domain, but it only works with a SQL
account. I'm not for sure setup IMHO, just that other machines
basically right next to it works fine with intregrated security, but
the Windows 2000 machine won't work.

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 ... same machine using Windows Authentication that work fine; ... the Windows 2000 machine won't work. ...
    (microsoft.public.sqlserver.connect)
  • Re: Slow booting xp home.
    ... Changing the boot order to boot first from your hard disk might save you a half second, but you won't be able to boot from a CD until you change it back - and the time spent to do that will erase any previous time saved. ... 2- Consider what software you really want to start with Windows and also how you've configured your applications at startup ... Installing and Registering Visual Studio Express Editions Smart Device ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Slow booting xp home.
    ... Thirty seconds to boot Windows? ... I read somewhere that Microsoft suggest 30s boot up on xp home, I have seen videos on youtube of 8s boot up on xp, I'd be delighted with 30s and happy just to get below a minute. ... Installing and Registering Visual Studio Express Editions Smart Device ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Remote connection failed
    ... If you are going over a remote connection or are not logging ... into the domain where SQL Server is then no, Windows ... authentication won't work. ...
    (microsoft.public.sqlserver.connect)
  • Re: Security Update for SQL Server 2005 Service Pack 2 (KB948109)
    ... If you're running Windows Live Mail, sign out then close the application. ... Understand that you can open a free support incident about your issues: ... When you call, clearly state that your problem is related to a Security Update and cite the update's KB number. ... SQL Server Database Services 2005 ENU SP2 ...
    (microsoft.public.windowsupdate)