topic Change Database Connection User? in Server Management - Systems Insight Manager

Change Database Connection User?

John Pilkington — Tue, 17 Oct 2006 10:30:53 GMT

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

Re: Change Database Connection User?

ramesh_naik_ — Tue, 17 Oct 2006 11:40:58 GMT

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

Re: Change Database Connection User?

John Pilkington — Tue, 17 Oct 2006 16:16:12 GMT

Worked perfect, thank you.

Re: Change Database Connection User?

ramesh_naik_ — Tue, 17 Oct 2006 23:03:11 GMT

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

Re: Change Database Connection User?

John Pilkington — Thu, 19 Oct 2006 09:45:53 GMT

Solved the described problem perfectly.