Change Database Connection User?

[John Pilkington]

SIM was installed as Domain Admin. Since then we have changed the Domain Admin password and I have set up a service account for SIM.

I have edited the database.props file to reflect the change in the user logging into SQL. I have added that users as the SIM database owner in SQL.

The problem I am having now it using the mxpassword command to change the DB connection password. I am using the following syntax:

mxpassword -m -x MXDBuserPassword="new password"

I get the following output:

Password key "MXDBuserPassword" is undefined.

Any ideas to how I might be going about this wrong?

Thanks,

John

[ramesh_naik_ · Accepted solution]

Hi John,

Try this in case you have not:

After Changing the Database Password and the HP SIM Password-> If the database password and HP SIM service account passwords are changed, the following steps must be performed to gain access to HPSIM:
1. Stop the HP Systems Insight Manager service.
2. Update the HP Systems Insight Manager Services Properties page, under the Log
On tab, with the new password.
3. Launch the MxPassword GUI by running the following command:
~HP\Systems Insight Manager\bin\mxpassword -g
4. Modify the password of the MxDBUserPassword key to reflect the new password.
5. Start the HP Systems Insight Manager service.

After Changing Only the Database Password
If only the database password is changed, the following steps must be performed to gain access to HPSIM:
1. Stop the HP Systems Insight Manager service.
2. Launch the MxPassword GUI by running the following command:
~HP\Systems Insight Manager\bin\mxpassword -g
3. Modify the password of the MxDBUserPassword key to reflect the new password.
4. Start the HP Systems Insight Manager service.


Hope this works!!!!

Regards,
rmn

[John Pilkington]

Worked perfect, thank you.

[ramesh_naik_]

Hi John,

Nice to know it worked!!!!!

If you feel the responses were of help, http://forums1.itrc.hp.com/service/forums/helptips.do?#33

Regards,
rmn

[John Pilkington]

Solved the described problem perfectly.