Cannot generate SSPI context

Posted on 2011-05-12
Last Modified: 2012-05-11
We currently have a problem with a client terminal server connecting to a SQL server via ODBC SQL Server driver.

We have a SQL 2000 server running on Windows 2003, service running as a domain user account.

5 Terminal servers (2x Server 2000, 3x Server 2003) and a bunch of XP client machines connect to this via an in-house application through an ODBC System DSN.

Yesterday, one of the Server 2000 boxes refused to connect, trying to reconfigure the DSN gives "SQLState HY000, SQL Server Error 0, [ODBC SQL Server Driver] Cannot generate SSPI context". The server can however connect to other ODBC connections.

We have tried reinstalling MDAC 2.6 (over the top) and removing/readding the machine to the domain to no avail. I've checked everything is setup the same as the other win2k TS (services etc) and they are. Nothing appears to have changed, nothing relevant in event log on client or server.

Everything I can find points at SPN, however with the other machines connecting fine I can't see this being the case. The SQL server though doesn't have an SPN set, probably due to running as a domain user account.

The problem would appear to be with the client, but I'm out of ideas for where to go with this one. Any help appreciated.
Question by:iris01
    LVL 18

    Accepted Solution


    Author Closing Comment

    Link was somewhat useful, ended up building a new TS as needed an instant solution.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
    NTFS file system has been developed by Microsoft that is widely used by Windows NT operating system and its advanced versions. It is the mostly used over FAT file system as it provides superior features like reliability, security, storage, efficienc…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now