sql server connect: Cannot generate sspi context -- sql server connect

Cannot generate sspi context

George
5/24/2007 3:51:00 AM

sql server connect: I am using Win2k server(sp4) and Sql 2000(sp4). When register from
enterprise manager by using windows authentication , it was showing 'cannot
generate sspi context'.
When I use FQDN to register, it work fine

Regards,

Re: Cannot generate sspi context

Sue Hoegemeier
5/29/2007 8:29:57 PM

Did you check the event logs on the box where you are trying
to register SQL Server? Look especially for DNS issues,
possibly windows time service issues.
Did you try connecting with named pipes - if that's enabled
on the server?

-Sue

On Thu, 24 May 2007 03:51:00 -0700, George
[quoted text, click to view]

RE: Cannot generate sspi context

vijayrod
5/31/2007 9:00:01 AM

Looks like a service principal name (SPN) registration issue! Can you try
troubleshooting steps as in below article ?

http://support.microsoft.com/kb/811889 - How to troubleshoot the "Cannot
generate SSPI context" error message

[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 in the sql server connect group.