topic Re: How do i change Database Connection User? in Server Management - Systems Insight Manager

How do i change Database Connection User?

Santiago Isidro — Thu, 24 Nov 2005 11:00:17 GMT

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?

Re: How do i change Database Connection User?

Igor Karasik — Thu, 24 Nov 2005 14:27:37 GMT

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

Re: How do i change Database Connection User?

Santiago Isidro — Thu, 24 Nov 2005 14:34:25 GMT

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

Re: How do i change Database Connection User?

Santiago Isidro — Fri, 25 Nov 2005 14:17:08 GMT

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

Re: How do i change Database Connection User?

Aravindh Rajaram — Sun, 27 Nov 2005 22:24:25 GMT

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.

Re: How do i change Database Connection User?

Joel Rubenstein — Mon, 28 Nov 2005 08:53:21 GMT

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.

Re: How do i change Database Connection User?

Santiago Isidro — Mon, 28 Nov 2005 09:55:41 GMT

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

Re: How do i change Database Connection User?

Santiago Isidro — Mon, 28 Nov 2005 09:58:49 GMT

Thread Closed