topic How to change db used by HP SIM 5 SP5 during installation in Server Management - Systems Insight Manager

How to change db used by HP SIM 5 SP5 during installation

(VJ) — Mon, 31 Jul 2006 02:07:21 GMT

Hi there

I'm trying to install HP SIM 5 SP5 on Server 2003 with SP1 running SQL 2005 with SP1 and during installation process, at the "Database Configuration" window I want to change the database to be used from "master" to newly created "HP_SIM_DB" or "HPSIMDB" for a number of reasons. However regardless what permissions I give to HP SIM Services Account (and it does have Administrative rights on the local server and SQL is configured to use SQL & Windows authenticationn) I get "Insufficient rights to database" error message!

On the DB level I ended up assigning ownership of following schemas and DB role membership:
-db_accessadmin
-db_backupoperator
-db_datareader
-db_datawriter
-db_owner
-db_securityadmin

Any help would be much appreciated, I just want to install the thing and get it over and done with! :)

Thanks in advance.

Cheers

Re: How to change db used by HP SIM 5 SP5 during installation

Ole Thomsen_1 — Mon, 31 Jul 2006 23:22:22 GMT

Take a look at http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=1038394

Ole Thomsen

Re: How to change db used by HP SIM 5 SP5 during installation

(VJ) — Tue, 01 Aug 2006 23:18:47 GMT

Hi Mate

Have tried everything that was suggested in that particular thread but nothing worked. Still keep on getting the same error message.

I have also tried assigning rights to the ServicesHPSIM account directly, not through group memberships, but still no luck!

Cheers
Vjeko

Re: How to change db used by HP SIM 5 SP5 during installation

Dave Carrion — Wed, 08 Nov 2006 14:32:07 GMT

We had the same issue with a DL385 G1. The issue was resolved by disabling DEP.

You can disable DEP completely or create an exception using the directions in the following MS article:

http://support.microsoft.com/kb/875352/en-us