Moving SIM DB

[stefano colombo_1]

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

[fred Passeron]

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

[stefano colombo_1]

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

[stefano colombo_1]

see my comment on the thread