How do i change Database Connection User?

[Santiago Isidro]

When i installed SIM, i accidentally used my user account for the database connection. And now everytime i change my password (because of domain policy), i get database connection error in SIM, and i´m forced to use the mxpassword to update the password change.

The question is, is there any way to have HPSIM to use another account for the database connection? How can i do that?

[Igor Karasik]

Try mxuser command
http://h18013.www1.hp.com/products/servers/management/hpsim/info-library5/mxuser.1m.html
Example section:
This command adds user "jane", a new Database Administrator, and grants her Full Rights privilege.
mxuser -a jane -d "Database Administrator" -p full

[Santiago Isidro]

I´ve already done that, however SIM is still using my account to connect to the database.

[Santiago Isidro]

Well, i think im just going to reinstall SIM, since i couldn´t find a way to do that

[Aravindh Rajaram · Accepted solution]

This is possible. You should edit the database.props file and the DSN's used by HPSIM and its plugins appropriately and then run the mxpassword command.

[Joel Rubenstein]

The database.props file is used to specify the username configured for database access and will contain an entry like the following.

hp.Database.username=AETSIM\\Administrator

The are 3 formats for this information.

\\ for domain accounts

\\ for local accounts

for SQL server accounts

The mxpassword command is used to configure the password used for database access with the following syntax

mxpassword -m -x MxDBUserPassword="password" the password can contain special characters but not the double-quote character. This command is case sensitive.

[Santiago Isidro]

AMicSys and Joel: Thank you very much! Without your help i wouldn´t have been able to solve this problem. Official HP support told me i had to reinstall the server...

[Santiago Isidro]

Thread Closed