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

Another error that came my way this morning was the SSPI context error when trying to connect to a SQL server.

A colleague was trying to use SQL Management Studio to connect to a specific database server. His Active Directory credentials had been setup with data reader privileges to the specific database. Each time he attempted to connect to the database he received the error message:

—————————
Microsoft SQL Server Login
—————————
Connection failed:
SQLState: ‘HY000’
SQL Server Error: 0
[Microsoft][ODBC SQL Server Driver]Cannot generate SSPI context

—————————
OK
—————————

After trying some suggestions on the Cannot generate SSPI context support page, I stumbled on a forum post that discussed checking how the specific account was setup on Active Directory. It turns out that his account had an option enabled that was set to ‘Use DES encryption types for this account’.

SSPI context

After disabling this option he was able to connect without any problems.

One Reply to “[Microsoft][ODBC SQL Server Driver]Cannot generate SSPI context”

  1. can any one assist me on the below error.
    Microsoft SQL Server Login
    —————————
    Connection failed:
    SQLState: ‘ss1000′
    SQL Server Error: 0
    [Microsoft][ODBC SQL Server Driver]Cannot generate SSPI context

    —————————
    OK