Sunday, February 19, 2012

Database wont 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 contexthttp://www.sqlservercentral.com/columnists/cmiller/cannotgeneratesspicontext.asp
http://support.microsoft.com/?id=811889
and
http://blogs.msdn.com/sql_protocols/archive/2005/10/19/482782.aspx|||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