Query analyzer error message - Cannot generate SSPI context

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Kelay
    New Member
    • Feb 2006
    • 1

    Query analyzer error message - Cannot generate SSPI context

    Hi all,
    This is my first post, so please be gentle. hahaha
    I have a SQL Server running Windows 2003, and SQL Server 2000.
    I am able to VPN into the server fine, however no one is able to access the server through Enterprise Manager or Query Analyzer. The Server has been fine lately, but it seems that something as of lately has happened. All client machines have not been updated lately or anything of the sort which would
    lead me to think that it is anything other that the server itself.

    I Get the following Message in Query analyzer when trying to logon:

    [Microsoft][ODBC SQL Server Driver]Cannot generate SSPI context.

    Any HELP would be greatly appreciated.

    ~Thanks.
  • rogge
    New Member
    • Oct 2006
    • 1

    #2
    I checked the system log and was told the SPS server could not connect to a timing/clock computer...

    I ran the net time command to sync the SPS server time with our domain server and that eliminated the problem.

    net time \\<ip or computer name> /SET /Y

    Comment

    Working...