Checking HTTP server Status --- non stop.

[Tboy]

Hi All,

I am trying to restart SIM after it has been down for a few weeks, I have all the services running and have set the SNMP traps, read write etc. I get the below error in the logs:

Database initialization failed for URL: jdbc:jtds:sqlserver://SERVERNAME:2431/Insight_v50_0_122358692;domain=EUR;instance= Ex: java.sql.SQLException: Login failed for user ''. The user is not associated with a trusted SQL Server connection.

Any ideas on this would be appreciated. The only thing that changed was the password for the domain acc that runs the SIM services.

Thanks

[fred Passeron · Accepted solution]

Hi

known issue , don't worry ! The hp sim service account is the same account that was used to create and to connect the DB. Therefore, when the service account password changes, it it needs to be changed at the db conncetion level otherwise you end up in :'
Database initialization failed for URL: jdbc:jtds:sqlserver://SERVERNAME:2431/Insight_v50_0_122358692;domain=EUR;instance= Ex: java.sql.SQLException: Login failed for user ''. The user is not associated with a trusted SQL Server connection. "

To fix it :
on the HP SIM server, open a cli prompt and type mxpassword -g ( see here for more details : http://h18013.www1.hp.com/cpq-products/servers/management/hpsim/info-library51/mxpassword.1m.html) and use the ui to modify the db connection password.

Once done restart the HP SIM service, it should be ok.

Hope it helps

Fred

[Tboy]

Thanks Fred,

Just a quick question hopefully as I have never used mxpassword before.

When I type in mxpassword -g and get teh gui up, I select modify and have two options:
MxDBUserPasword
MxSshKeyPassword
Now as none of these are my domain acc for SIM I just want to confirm that it is the MxDBUserPassword acc that I need to change the password for?

Thanks again.

[fred Passeron]

Hi

MxDBUserPasword is te one you need to modify.

hope it helps

fred

[Tboy]

Perfect it's working again, thanks very much