PC with Insight Mgr Install keeps locking AD Account

[Craig McInnes]

I have HP System Insight Mgr 5.0 SP5 installed and today I change the password to my user account. Now my account keeps on getting locked and when you look at the event log on the SIM Server it appears to be the one causing it, because if I shutdown that Server the problem goes away.

Below are the two entries.

Logon Failure:
Reason: Unknown user name or bad password
User Name: cmm
Domain: nzrc
Logon Type: 2
Logon Process: Advapi
Authentication Package: Negotiate

Logon Failure:
Reason: Account locked out
User Name: cmm
Domain: nzrc
Logon Type: 2
Logon Process: Advapi
Authentication Package: Negotiate

Has anybody come cross this problem?

Thanks it advance for any help.
Craig

[NJK-Work]

Hi Craig,

I think you need to change the password used by SIM using this post:

HP SIM 5.0 - changing SQL username and password

I am looking for the exact URL...

Nelson

[NJK-Work]

I can't find the original post anymore - perhaps its was stale and they removed. I save the entire post in case this happened, so I will paste it here:

Sep 13, 2005 11:04:28 GMT

--------------------------------------------------------------------------------
I upgraded SIM 4.2 to 5.0 some weeks ago - no problems. However, I just changed the password on my admin account, and SIM subsequently died. It appears that I initially set up the SIM services to run as my admin ID, rather than our usual admin service account. I changed the service to log in as this user, but the connection still tries to use the old account. Looking in database.probs its buried in there. How can I chnage the account/password it uses?

Thanks

Andrew
____________________________________________

Run the following command
mxpassword -r -x MxDBUserPassword
mxpassword -a -x MxDBUserPassword=

Now restart the service
____________________________________________

SIM uses Windows authentication when connecting to SQL. It can not be configured to use SQL server authentication. Now that you have reset the password, edit the globalsettings.props file and change the entry named "WindowsServiceUserName". After doing this I think u also should edit all the HPSIM and it's plug-in related DSN's to reflect the Username change and then try start the service.
____________________________________________

I'm actually trying to use a different domain account .... thanks for the info on globalsettings.props ... but now it appears it does not like some of the 'special' characters in the password!
____________________________________________

The database user is now defined in the database.props file. SIM 5.0 can now be configured to use SQL server authentication in addition to Windows NT authentication.

To configure to use the sa user you would edit the following line in database.props to read

hp.Database.username=sa

Of course you will also need to use the mxpassword command to set the password.

mxpassword -m -x MxDBUserPassword=yourpassword
____________________________________________


Credit to:
AMicSys
Joel Rubenstein
Sandu

Nelson

[Craig McInnes]

Hi Nelson,

Thanks for the info, but in the meantime I did a re-install with the latest version and a different service account.

Regards
Craig