topic Moving SIM DB in Server Management - Systems Insight Manager

Moving SIM DB

stefano colombo_1 — Thu, 17 Jul 2008 07:54:25 GMT

Hi ,
I've to migrate the local SQL 2005 EXPRESS DB of HP SIM to a remote SQL2005 Server.

The steps I've taken are :
-stop hp sim services
-detach DB from local SQL2005 Express.
-attach DB to remote SQL 2005 server
-Modified ODBC connection
-Modified database.props fields
hp.Database.hostName=SSHPBLDXC1D4
hp.Database.instance=SSHPBLDXC1D4\D4\

-restart SIM services .

I got the error below and HPSIM Web interface does not start

Can anyone tell me if I'm missing some required step ?
thanks
Event Type: Error
Event Source: HP Systems Insight Manager
Event Category: None
Event ID: 3
Date: 7/17/2008
Time: 10:47:50 AM
User: N/A
Computer: SSEUMG00
Description:
com.hp.mx.database.DbVerificationException: Error loading database verification handler 'com.hp.mx.database.MsSqlVerificationHandler'
com.hp.mx.database.DbVerificationException: Error accessing database

Re: Moving SIM DB

fred Passeron — Fri, 18 Jun 2021 11:10:22 GMT

hi

Please check the following new techncial paper :
ftp://ftp.compaq.com/pub/products/servers/management/hpsim/SQL2005_Move_HPSIM52.pdf

it describes the different steps to move from local to remote DB.

on the HP SIM server, launch the following command :mxpasswd -g to modify the credentials to access the HP SIM DB if the account has changed.

mxpassword -g' or 'mxpassword -m -x MxDBUserPassword=""'.

hope it helps

fred

Re: Moving SIM DB

stefano colombo_1 — Mon, 21 Jul 2008 06:36:19 GMT

Hi ,
I actually solved the issue .
The problem is that the clustered SQL server instances uses , by default , dynamic ports.
So the port 1433 setting in the .props files is not correct anymore .
To solve the issue I fixed the port on the sql server and set it into the .props file

Thanks

Re: Moving SIM DB

stefano colombo_1 — Mon, 21 Jul 2008 06:36:50 GMT

see my comment on the thread