topic Re: Changing SQL password in Server Management - Systems Insight Manager

Changing SQL password

Daniel Connolly — Mon, 04 Jul 2005 04:00:39 GMT

How do I change the password that SIM uses to connect to the database?

We have SIM 4.2 running on Windows, connecting to a SQL Server using an SQL login. I've found the config\database.props file which contains database connection info. It also has a password entry but when I change this it doesn't work. I'm guessing that the password is stored in this file encrypted (I hope so anyway).

So how do I change the password?

Re: Changing SQL password

Joel Rubenstein — Tue, 05 Jul 2005 09:54:54 GMT

SIM uses Windows NT authentication when connecting to SQL. It can not be configured to use SQL server authentication. Therefore it uses the Windows credentials the "HP Systems Insight Manager" service is running with.

Re: Changing SQL password

Magne Stenwig — Tue, 11 Oct 2005 04:52:33 GMT

Actually, it looks like SIM 5 use the login account you were logged in as when you installed SIM 5, for database-connectivity.
This is a big problem for me since I need to change password on this account. I tried to change this password, but this resulted in SIM5 loosing connectivity to it's database.

Does anyone know how to change the account sim5 connects to the database with?

Re: Changing SQL password

Igor Karasik — Tue, 11 Oct 2005 05:09:55 GMT

In SIM 5.0 you can use mxpassword command
mxpassword -m -x MxDBUserPassword="newpassword"