Changing SQL password

[Daniel Connolly]

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?

[Joel Rubenstein]

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.

[Magne Stenwig]

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?

[Igor Karasik]

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