Moving HP SIM to a new database

04 Aug

One would think that a product like HP SIM would be quite comprehensive and well documented when you want to move its database to another server. However, it had been quite a frustrating affair trying to search for solutions on the Internet, from the help manual of HP SIM and from the HP forum itself. I, however, managed to find a related help document that details changes the HP SIM name and guessed from there what needs to be changed to move the HP SIM database to another server.

Okay, this happened because our DBA has migrated all SQL Server 2000 databases to the 2005 version. I thought that it would be a simple change of the 2 ODBC system DSN: Insight_v50_0 and PMP_V3_0 (I only used these 2 database, you could have more than that). So I quickly launch ODBC and made the changes to the system DSN, restarted HP SIM and trying logging on. Logon was successful and everything looks okay, until I checked with my DBA who told me that I am still hitting the old SQL server.

Searches in the HP forum found a possible solution in the thread: Move HP SIM Database to new SQL Server

One of the links pointed to files you need to modify to change system name. Took a quick look and decided to search the HP program files folder for text containing my old server name. Made the changes and finally got it move to the new SQL server.

Here is what I did… you need to change the database instance values in the following files in C:\Program Files\HP\Systems Insight Manager\config:

  • database.admin
  • database.props
  • databaseadminupd.tpl

As with all changes, make a BACKUP copy before amending the files.


Posted by on August 4, 2007 in Windows



15 responses to “Moving HP SIM to a new database

  1. Dana

    September 18, 2007 at 1:36 pm

    Thank you for posting this issue and resolution. I had the same issue this morning and quickly resolved the issue when I came across your article.
    Thanks for saving me time and extra work.

  2. Steve

    September 19, 2007 at 7:52 pm

    Same issue here. Note to HP Support Staff – Do an FAQ! Thanks for posting.

  3. saltwetfish

    September 20, 2007 at 1:24 am

    You are all welcome. That’s the reason for me to put it here in the first place. 🙂

  4. Edward

    December 22, 2007 at 4:25 pm

    Nice post!

  5. Terry

    February 14, 2008 at 1:42 pm

    Thanks for this great info. Worked for us.

  6. Tote

    March 13, 2008 at 5:19 am

    Thank you, you saved my bacon as well after SIM filled up the MSDE database and needed to be moved to a real SQL server.

  7. Justin

    April 23, 2008 at 12:59 pm

    Curious.. you changed the ODBC settings and the three config files right?

  8. saltwetfish

    May 13, 2008 at 4:18 am


    Yes that is correct.

  9. Lars

    June 19, 2008 at 2:36 pm

    Yeah, it worked. You saved my day.

  10. Mike

    June 26, 2008 at 10:33 pm

    Perfect. All I had to do was edit those three files when I moved my SQL database. Mine says its running JDBC.

    Thanks a bundle for your post!

  11. Jason

    January 15, 2009 at 9:30 pm

    Lifesaver! thanks

  12. Frank

    January 28, 2009 at 8:01 pm

    Thanks! Saved us time and loss of hair….

  13. Prince Henry

    November 22, 2010 at 1:42 pm

    you are a life-saver

  14. Lance

    January 21, 2015 at 5:56 am

    Did you have to restart SQL after this?

    • Lance

      January 21, 2015 at 6:06 am

      Nevermind, Found out i was missing this. I’m on version 7.01 . Hope this helps anyone.

      C:\Program Files\HP\Systems Insight Manager\jboss\server\hpsim\deploy\hpsim-ds.xml


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: