Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2006

    Unanswered: Database won't start in cluster - cannot generate SSPI context

    I have a MSSQL database running in a Microsoft cluster. I was working on troubleshooting for another SAP problem when they suggested I change the setting using hte SQL Server Client Network Utility to 'named pipes' from 'tcp/ip'. Every since, despite changing it back I'm unable to start the database in the cluster.

    I'm kind of a newbie at this so I'd really appreciate any help in getting this database up and running.

    Here is the error message from the event log:
    sqsrvres] checkODBCConnectError: sqlstate = HY000; native error = 0; message = [Microsoft][ODBC SQL Server Driver]Cannot generate SSPI context

  2. #2
    Join Date
    Jul 2003
    San Antonio, TX
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Jun 2006

    Solution Found

    Thanks for your help. The solution was to change the /etc/hosts to the SQL Server instance name. Everything is up and running now.
    The line in my /etc/hosts used to read: localhost
    Now it reads: <instance name>
    # localhost

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts