February 8, 2009 at 11:32 pm
Hi,
We are using SQL Server 2005 Standard Editons. One of the system users are not able to register the production server from their desktop it shows the following error
"Cannot generate SSPI content".
But they are able to login that system through Remote Desktop Connections.
Regards,
S.Balavenkatesh
February 8, 2009 at 11:58 pm
This Microsoft KB article may help http://support.microsoft.com/default.aspx?scid=kb;en-us;811889
--
Andrew Hatfield
February 10, 2009 at 6:13 am
Try registering the server with the IP address instead. Sometimes I see that error if a server name has been changed or if there is a problem with DNS. The IP should always work 🙂
February 10, 2009 at 11:28 am
SSPI errors likely mean you've got a kerberos authentication issue going on. The KB article is the right way to go. RDP authenticates the user locally, so you're not doing a Kerberos authentication attempt from the client. Therefore, the fact that they can connect via RDP doesn't weigh in except to prove that the computer is on the network and able to authenticate domain users. And if it is a Kerberos issue, then the computer name is what's important, because that's what the SPN will be registered with. If you use the IP address, you'll probably get in, as it won't see an SPN and drop back to NTLM security. This allows you to connect, but it doesn't solve the issue.
K. Brian Kelley
@kbriankelley
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply