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,
George.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
<George@.discussions.microsoft.com> wrote:
>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,
>George.|||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
> enterprise manager by using windows authentication , it was showing 'canno
t
> generate sspi context'.
> When I use FQDN to register, it work fine
No comments:
Post a Comment