topic Re: HP SIM 5.0 - changing SQL username and password in Server Management - Systems Insight Manager

HP SIM 5.0 - changing SQL username and password

Andrew_281 — Tue, 13 Sep 2005 06: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

Re: HP SIM 5.0 - changing SQL username and password

sandu_1 — Tue, 13 Sep 2005 07:36:18 GMT

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

Now restart the service

Re: HP SIM 5.0 - changing SQL username and password

Andrew_281 — Tue, 13 Sep 2005 07:51:38 GMT

That's great - thanks. Is there a similar command to change the user as well?

Re: HP SIM 5.0 - changing SQL username and password

Aravindh Rajaram — Tue, 13 Sep 2005 09:41:22 GMT

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.

Re: HP SIM 5.0 - changing SQL username and password

Andrew_281 — Tue, 13 Sep 2005 09:54:40 GMT

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!

Re: HP SIM 5.0 - changing SQL username and password

Joel Rubenstein — Tue, 13 Sep 2005 10:14:44 GMT

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

Re: HP SIM 5.0 - changing SQL username and password

Andrew_281 — Tue, 13 Sep 2005 10:47:27 GMT

I don't suppose anyone knows which 'special' characters are a 'problem' here? * seems to be OK, but things like ^ ) ! seem to prevent the password utility working

Re: HP SIM 5.0 - changing SQL username and password

Mark Wolf_2 — Tue, 13 Sep 2005 12:34:01 GMT

put the password in single quotes if you are using special characters in password.

Re: HP SIM 5.0 - changing SQL username and password

Andrew_281 — Wed, 14 Sep 2005 03:16:13 GMT

Thanks - single quotes don't seem to help - looking at the error its chopping off all the password after the & that it has in it....The HP Services are runnign as the same user and have no problem with the & - it just seems at the command line to be a problem

Re: HP SIM 5.0 - changing SQL username and password

Joel Rubenstein — Wed, 14 Sep 2005 08:40:40 GMT

Andrew - I did a little testing and found that you can enclose the password within double quotes and specify any character including the &

Re: HP SIM 5.0 - changing SQL username and password

Andrew_281 — Wed, 14 Sep 2005 08:44:38 GMT

Thanks .... I have wimped out and moved to a SQL account for the connection as I cannot get a less secure p/w for a windows account - I tried double quotes but we already have a " in the password - seems to confuse it !