Help and Support

PRB: Error message: Cannot generate SSPI context

Article ID:814401
Last Review:July 26, 2006
Revision:1.2

SYMPTOMS

When you try to connect to a computer running SQL Server 7.0, you may receive an error message if all the following conditions are true:
Your computer is running Windows 2000.
You are using Windows Authentication with domain user credentials
There is no active network connection from the computer running SQL Server to the domain.
You may receive the following error message:
Cannot generate SSPI context

Back to the top

CAUSE

This problem occurs because the computer running SQL Server cannot connect to a domain controller to authenticate your user credentials.

Back to the top

RESOLUTION

To resolve this problem, make sure that the computer running SQL Server is connected to the domain network and that it can communicate with the domain controller.

Back to the top

MORE INFORMATION

If you use domain user credentials the first time that you connect to the computer running SQL Server while the computer is connected to your domain network, you can continue to communicate with the computer running SQL Server even if that computer cannot connect to the domain controller later. You can continue to communicate because your domain user credentials have been cached. You can continue to communicate until you disconnect from the computer running SQL Server.

Verify that the domain to which the computer running SQL Server belongs and the domain user account that you use to connect to the computer are in the same forest. The domain and the account must be in the same forest for Security Support Provider Interface (SSPI) to work.

Back to the top

REFERENCES

For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
269541 (http://support.microsoft.com/kb/269541/) Missing Windows NT LM Security Support Provider registry key causes "Cannot generate SSPI context" error message when you connect to SQL Server
267588 (http://support.microsoft.com/kb/267588/) "Cannot generate SSPI context" error message is displayed when you connect to SQL Server 2000
811889 (http://support.microsoft.com/kb/811889/) How to troubleshoot the "Cannot generate SSPI context" error message

Back to the top


APPLIES TO
Microsoft SQL Server 7.0 Standard Edition, when used with:
  Microsoft Windows 2000 Standard Edition
   the operating system: Microsoft Windows XP

Back to the top

Keywords: 
kblogin kbsecurity kbprb kbauthentication KB814401

Back to the top

Article Translations

 

Related Support Centers

Other Support Options

  • Contact Microsoft
    Phone Numbers, Support Options and Pricing, Online Help, and more.
  • Customer Service
    For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
  • Newsgroups
    Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.