HP SIM 5.0

[Alan Porter_1]

Insight Manager has stopped working, when I look in the event viewer i am seeing the following error:
com.hp.mx.database.DbVerificationException: Error loading database verification handler 'com.hp.mx.database.MsSqlVerificationHandler'
com.hp.mx.database.DbVerificationException: Error accessing database.

How can i rectify this problem?

[Aravindh Rajaram]

Have you changed the password that was used to connect to the database? If yes, then run the following 2 commands

mxpassword -r -x MxDBUserPassword
mxpassword -a -x MxDBUserPassword=

[Alan Porter_1]

Please can you explain what the switches in the commands do and also do i put the new password in the < > or is the a statement to Sql?

[Aravindh Rajaram]

You can enter the first command as it is. It will remove the entry that has the old password that was used to connect to the DB.

And the second command adds a new entry (rather specifies) to HPSIM as to what password should be used to connect to the DB from now on. Replace with your new password that HPSIM should use to connect to the database. (It is NOT a statement to SQL)