[HP SIM] The Systems Insight Manager is not working properly and the database error 0x80090302.

This artical also published in english:http://www.cnblogs.com/larryatcnblog/p/4153295.html

What is HP SIM? The article said that the SIM refers to the Systems Insight MAnager, is the HP company to its own server production of a central management web, the interface is as follows.

The basic function is to detect the HP server in the network, when the server down or have hardware problems can give alarm.

This is the goods out of the question, the sudden access is not, but the background sim service is still running. The following error occurred in EventLog,

Com.hp.mx.database.DbVerificationException:Error Loading Database Verification handler ' Com.hp.mx.database.MsSqlVerificationHandler ' Com.hp.mx.database.DbVerificationException:Error accessing database

SSPI handshake failed with error code 0x80090302, state and establishing a connection with integrated security; 
     The connection has been closed. Reason:acceptsecuritycontext failed. The Windows error code indicates the cause of failure.  

Errors are as follows,

MSSQLServer with studio and other connections are normal, ODBC also tried normal, port normal listening 1433, but the SIM is not connected, and finally found the following link to the answer,

http://h20564.www2.hp.com/hpsc/doc/public/display?docId=mmr_kc-0114705

According to Knowledge base content, you can be sure that SIM will use non-NTLMv2 LM or NTLM to do Windows authentication, as long as the SQL connection string to add usentlmv2=true to solve the problem.

Then how come there's a sudden problem? Usually no one moves the SIM server, so use Rsop.msc to see the relevant policies of NTLM, because backward-compatible such things should not be changed.

The default in explain is as follows,

Windows2003: Send NTLM response onlywindows Vista, Windows Server, Windows 7, and Windows Serv ER r2:send NTLMv2 response only

In general, the authentication is between the server will negotiate what version of the protocol you use, shake hands and then communicate, but the Group Policy is changed to "Refuse LM & NTLM", and SIM call MSSQL connection string By default may be LM or NTLM, This resulted in a protocol error.

[HP SIM] The Systems Insight Manager is not working properly and the database error 0x80090302.