DB Auth errors after upgrading to SIM 5.0

[RHagen_1]

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?

[Aravindh Rajaram]

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=

[RHagen_1]

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

[Aravindh Rajaram]

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

[Stefan Laemmer]

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..

[RHagen_1]

thks