HPE Community read-only access December 15, 2018
This is a maintenance upgrade. You will be able to read articles and posts, but not post or reply.
Hours:
Dec 15, 4:00 am to 10:00 am UTC
Dec 14, 10:00 pm CST to Dec 15, 4:00 am CST
Dec 14, 8:00 pm PST to Dec 15, 2:00 am PST
Server Management - Systems Insight Manager
cancel
Showing results for 
Search instead for 
Did you mean: 

HPSIM 5.1 SP1 Upgrade to 5.3 SP1 failure

 
Gary Tonkins
Advisor

HPSIM 5.1 SP1 Upgrade to 5.3 SP1 failure

Hi there

I wonder if anyone can help or point me in the right direction. I planned to upgrade our installation of HPSIM from 5.1 SP1 to 5.3 SP1 on a windows 2003 SP2 server. The database sits on a SQL 2005 SP2 backend server in it's own instance remote to the HPSIM software server. When I performed the upgrade I entereed the correct credentials for SQL authentication and the upgrade went through ok until we had restarted the HPSIM server and brought up HPSIM. We found that the database was empty and on further investigation it looks like a new databse was created in the SQL Master server rather than upgrading the seperate instance.
Any ideas why this would be and what I can do to make sure we upgrade the exisitng database and not create a new one?
We had to restore from backups and manually clean out anything created in the master SQL instance.

Thanks in advance
1 REPLY
Gary Tonkins
Advisor

Re: HPSIM 5.1 SP1 Upgrade to 5.3 SP1 failure

Ensured odbc pointed to instance of hpsim database and granted CMS service account sysadmin rights on database instance.