SQL 2005 failover cluster error Error: 17806, Severity: 20, State: 2 and Error: 18452, Severity: 14, State: 1

I am getting the errors in my SQL 2005 Failover cluster that is running MOSS 2007
 Error: 17806, Severity: 20, State: 2.
2009-04-02 00:03:58.47 Logon       SSPI handshake failed with error code 0x80090311 while establishing a connection with integrated security; the connection has been closed. [CLIENT: 150.0.xx.xxx]
2009-04-02 00:03:58.47 Logon       Error: 18452, Severity: 14, State: 1.
2009-04-02 00:03:58.47 Logon       Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: 150.0.xx.xxx]

Here 150.0.xx.xxx is the IP of my MOSS server

Please help

PaakiAsked:
Who is Participating?
 
wolfman007Connect With a Mentor Commented:
Have a look at the following website

How to troubleshoot the "Cannot generate SSPI context" error message
http://support.microsoft.com/kb/811889/

If this doesn't help then make sure the SQL Server authentication mode is set to mixed.

SQL SERVER - Fix : Error: 18452 Login failed for user (null). The user is not associated with a trusted SQL Server connection.
http://blog.sqlauthority.com/2007/04/14/sql-server-fix-error-18452-login-failed-for-user-null-the-user-is-not-associated-with-a-trusted-sql-server-connection/
0
 
St3veMaxCommented:
Using Kerberos Authentication?

Look up "SETSPN" - Service Principal Name.

HTH
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.