topic Re: SQL Migration from SQL2005 to SQL2008 in Server Management - Systems Insight Manager

SQL Migration from SQL2005 to SQL2008

David T. — Tue, 01 Mar 2011 22:34:53 GMT

HP SIM ver: 6.2

I was able to upgrade from SQL2005 to SQL2008 without issues, I modified some configuration files on hp sim and everything worked.

My only issue is that the Crystal Report Application which comes with HP SIM, still has the old SQL information. Is there a configuration file I need to modify to get Crystal Report to point to the updated SQL DB?

Do I need to restart a service in regards to Crystal Report?

Thanks,
David

Re: SQL Migration from SQL2005 to SQL2008

Server-Support — Wed, 02 Mar 2011 04:02:29 GMT

Hi David,

I wonder how did you do the Database upgrade from SQL Server 2005 into 2008 ?

Re: SQL Migration from SQL2005 to SQL2008

David T. — Wed, 02 Mar 2011 16:56:20 GMT

Theres a link here I used as reference:

ftp://ftp.compaq.com/pub/products/servers/management/hpsim/sql2005_move_hpsim52.pdf

I added my AD HP SIM SQL service account to the new sql instance on SQL 2008. Made this account owner of the new migrated database.

Ran mxinitconfig command on HP SIM Server, which reinitialize lots of the configurations.

After that everything just worked. Except for the Crystal Report feature on HP SIM, which is not a big deal, but it would be nice to have.

Re: SQL Migration from SQL2005 to SQL2008

Server-Support — Wed, 02 Mar 2011 22:18:55 GMT

ah, very simple :-)
many thanks for the reply, but that document can't be accessed by now ?