Change Database Usr Name and Password

[Robert Morel]

How can I change the way that my HP SIM 1.0 connects to its database?

When I start the service, I get this error in the DomainManager.* files in the LOGS Directory:

Database initialization failed for URL: jdbc:odbc:Insight_v1_0 User: sa pwd: ****** Ex: java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'.

It looks like SIM is trying to access my SQL Server with the SA account... I setup an account on my SQL server that I'd like to use instead of using SA.

MXInitConfig responds with:
6. Database Configuration
- Requisite : Acceptable
- Status : Unconfigured

I have two ODBC connects in Windows that point to the server and connect successfully when I enter the credentials to the new SQL acct.

[Robert Morel]

I also get the following error in the event log:

com.hp.mx.database.DbVerificationException: Error loading database verification handler 'com.hp.mx.database.MsSqlVerificationHandler'
com.hp.mx.database.DbVerificationException: Error accessing database

[Rich_71]

I'm getting this in my event logs. Does it have something to do with the accoutn the services run with?
com.hp.mx.database.DbVerificationException: Error loading database verification handler 'com.hp.mx.database.MsSqlVerificationHandler'
com.hp.mx.database.DbVerificationException: Error accessing database

[Javier Schulman]

I'm getting this in my event logs also. com.hp.mx.database.DbVerificationException: Error loading database verification handler 'com.hp.mx.database.MsSqlVerificationHandler'
com.hp.mx.database.DbVerificationException: Error accessing database

Any idea??

[Stian Svendsen]

Still got no clue? I just received the same error message

"com.hp.mx.database.DbVerificationException: Error loading database verification handler 'com.hp.mx.database.MsSqlVerificationHandler'
com.hp.mx.database.DbVerificationException: Error accessing database"

It occurs with a warning "Restarting MxDomainManager" and the information "Restart was Successful"

It reoccurs at least to times a minute...

[Alan_149]

I am now getting this error

com.hp.mx.database.DbVerificationException: Error loading database verification handler 'com.hp.mx.database.MsSqlVerificationHandler'
com.hp.mx.database.DbVerificationException: Error accessing database

Then it tries the following:
Restarting MxDomainManager of which is successful.

But then I get
com.hp.mx.database.DbVerificationException: Error loading database verification handler 'com.hp.mx.database.MsSqlVerificationHandler'
com.hp.mx.database.DbVerificationException: Error accessing database.

SIM does not start now at all - I also went back to previous backups of the DB to check that it was not corrupt - but nothing works.

SIM is down now - need to get this resolved ASAP

[Joel Rubenstein]

Alan,

A couple of questions to better understand your problem.

1. What version of SIM?

2. What changes did you make that caused this problem to occur?

[Alan_149]

I am using SIM v5.0 and the possible changes are that the October Microsoft Patches where applied two days previous. I uninstalled the patches and went through the Advisory from HP for MS05-051 http://support.microsoft.com/kb/909444

But nothing has worked to fix it.

Any ideas?

[Joel Rubenstein]

Installation of the Microsoft patches should have not created the database access problem. It is typically caused by changing the Windows password used to access the database without updating the password info in SIM.

mxpassword -m -x MxDBUserPassword="newpassword"

[Brion Maciel_1]

I just finished dealing with this problem. Turns out it was related to the account that is used to access the database. It just so happened that my database server got Win2k3 SP1 applied around the same time I was required to change my own account password. After applying Win2k3 SP1, the database was no longer accessible.

I assumed the whole time that the a designated system account was being used to access the database. However, looking further into it, my own account was being used, and when I changed my password - boom -failure to logon to the DB.

To check this, on the CIM server, go to C:\Program Files\HP Systems Insight Manager\Config. Open the Database.props file in Notepad. The third line from the bottom will tell you what account is being used to access the DB. I then used the mxpassword change procedure to change to my new password and things came back fine.

Now I need to figure out how to change the user account accessing the DB so it uses the sys account I created for this purpose!

Hope this helps.

[Joel Rubenstein]

Brion,

It is easy to change the account that accesses the database.

The database.props file is used to specify the username configured for database access and will contain an entry like the following.

hp.Database.username=AETSIM\\Administrator

The are 3 formats for this information.

\\ for domain accounts

\\ for local accounts

for SQL server accounts

[Neyron]

Hello,

I am meeting the same error as described in this topic on my production server with SQL Server 2005 installed. I tried to reset the SIM password with mxpassword -m -x MxDBUserPassword="newpassword" but the error still occurs.

I tried to create a new user for the account that appear in the database.props in my DB but it also had no effect.

The OS is Windows server 2003 R2 SP2 Standard edition.

Thanks for your help.

[SistemasRTVV]

I have the same problem and I've resolved it with command: mxpassword -g (it's a GUI interface very easy).

Look at configuration files looking for sa or other username.

[Alvaro Niebuhr]

It works for me! Thanks!

[sdb_2]

For some reason, our HPSIM server showed also this behaviour:

com.hp.mx.database.DbVerificationException: Error loading database verification handler 'com.hp.mx.database.MsSqlVerificationHandler'
com.hp.mx.database.DbVerificationException: Error accessing database

Followed by a restart of the MxDomainManager (as desribed in the posts above).

All I did to solve this was initiating a telnet session from the hpsim server to the sql-server on the tcp port where the sql instance is running.
I don't have a clue about the reason of this problem.

Does anyone know what could have caused this and why I can solve it by simply initiating a telnet session and restarting hpsim?

Thanks.

[Sabeel Rehman]

My SIM start working now, i have tried the command " mxpassword -g " , now its perfect for me.