cannot generate SSPI context on Win XP machine -- sql server connect

Robert Dufour
5/3/2007 12:39:59 PM

I am running sql server 2005 developper edition on a Windows XP Sp2 machine
that is part of a domain.

I am getting the cannot generate SSPI context error when I am trying to
connect via integrated security. I can connect using username and password.

I looked at the docs but found that the setspn utility is only for servers
(w2k w2003 etc). How do I fix this problem on a Windows XP machine.

Thanks for any help
Bob

Sue Hoegemeier
5/10/2007 7:37:16 PM

Trying to connect from what client to what server using
integrated security? Is this a local connection - just
connecting to the SQL Server on your machine?
Are the services running under a domain account or a built
in account?

-Sue

On Thu, 3 May 2007 12:39:59 -0400, "Robert Dufour"
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server connect

sql server connect : cannot generate SSPI context on Win XP machine