topic Re: DB Auth errors after upgrading to SIM 5.0 in Server Management - Systems Insight Manager

DB Auth errors after upgrading to SIM 5.0

RHagen_1 — Mon, 10 Oct 2005 18:20:53 GMT

After upgrading to SIM 5.0 from 4.2 with single seperate SQL db, with the local admin account, I follow any of the instructions in this thread that impacted SIM5 upgrage but I'm still Hanging at "checking HTTP server status" window when starting SIM 5.0..I'm also geting this error in the App log of the SIM svr "com.hp.mx.database.DbVerifcationException. Error loading database verifcation handler 'com.hp.ms.database.MsSqlVerificationHandler' - com.hp.mx.database.DBVerifcationException. Error accessing the database.

It's a DB authentication issue but there is no previous fix listed in this thread. Does anyone know the fix? edit the db.props file?

Re: DB Auth errors after upgrading to SIM 5.0

Aravindh Rajaram — Tue, 11 Oct 2005 03:47:25 GMT

Did you use a different user account during upgrade? If yes, then you need to run the following commands (even otherwise you can try the running the following commands and see it works)

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

Re: DB Auth errors after upgrading to SIM 5.0

RHagen_1 — Wed, 12 Oct 2005 23:28:33 GMT

Yes the password changed... where do I run this command at? on the remote sql server or on the SIM server?

Re: DB Auth errors after upgrading to SIM 5.0

Aravindh Rajaram — Thu, 13 Oct 2005 04:52:37 GMT

You'll have to run this command on the SIM server at the command prompt.

Re: DB Auth errors after upgrading to SIM 5.0

Stefan Laemmer — Thu, 13 Oct 2005 10:24:43 GMT

Actually, you could run mxpassword -g which brings up the Gui (the -r MxDBUserPassword didnt work for me on the command line). And in the GUI is a modify for the the SSH or the DBUser password..

Re: DB Auth errors after upgrading to SIM 5.0

RHagen_1 — Thu, 15 Oct 2009 21:46:16 GMT

thks