topic Re: Changing User Account for db connection & SSH? in Server Management - Systems Insight Manager

Changing User Account for db connection & SSH?

Rilex — Tue, 11 Jul 2006 13:47:52 GMT

I need to change the user account used for the database connection (remote SQL 2000 db) as well as the SSH account across ~70 servers.

What is the easiest way to do this? I tried mxpassword -g but that seems to just allow you to set the password. Also, if I change the service account (HP Systems Insight Manager) to the new account and set the password, it appears to be using the old account according to the SQL server (I'm seeing failed login events from that account).

Re: Changing User Account for db connection & SSH?

Aravindh Rajaram — Wed, 12 Jul 2006 09:37:00 GMT

If you change the service account credentials then you need to run the following commands:

mxpassword -r -x MxDBUserPassword
mxpassword -a -x MxDBUserPassword=

And for configuring the SSH account access across multiple servers, you can make use of the "Configure or Repair Agents" task.

Re: Changing User Account for db connection & SSH?

Rilex — Wed, 12 Jul 2006 14:04:21 GMT

I ran mxpassword -g to change the password that way before posting yesterday, however it still connects with the old user. I need to retire that old user account hence the need to change it.

Thanks

Re: Changing User Account for db connection & SSH?

Joel Rubenstein — Thu, 13 Jul 2006 08:43:45 GMT

The user account used to access the database is now stored in the database.props file. You must edit this file, use mxpassword to change the database user account password to match the new account and restart the SIM service.

Re: Changing User Account for db connection & SSH?

Rilex — Thu, 13 Jul 2006 10:19:07 GMT

Great, that worked! :)