HPSIM Problem after domain admin password change

[Rob Buxton]

Hi All,
HPSIM 5.0 on W2003 Server, with SQL Server backend.
We changed the password the HPSIM Service runs under and now we cannot get HPSIM to work.
The error seems to be:
Database initialization failed for URL: jdbc:jtds:sqlserver://sqldbpr1:1433/Insight_v50_0_121847406;domain=WCC;instance= Ex: java.sql.SQLException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
I've seen a similar thread but this seems a bit different.
If I run OSQL using the -E parameter while logged into the account the HPSIM Service runs under I can make a conenction to the database.

Is there anything that can be reset in HPSIM to regenerate the connection string to the database.

[Igor Karasik]

Rob,
Did you see Darrin Rawls post (with word file attachment) in this thread
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=948745

Igor

[Joel Rubenstein · Accepted solution]

Rob,

SIM 5.0 now uses a different database access method. If you change the password of the account used to access the DB you must also use the mxpassword command to reset the database user password.

The syntax which is case sensitive is

mxpassword -m -x MxDBUserPassword="newpassword"

[Rob Buxton]

Joel,
Many thanks, that did the trick.

[Bill Norton]

Worked for me too after an admin account password change.