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

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

    Hi,
    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
    Location
    San Antonio, TX
    Posts
    3,662
    "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
    Posts
    2

    Solution Found

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

Posting Permissions

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