topic Re: HP SIM 5.0 SP5 SQL Install troubles in Server Management - Systems Insight Manager

HP SIM 5.0 SP5 SQL Install troubles

Stevan Beara — Wed, 23 Aug 2006 23:20:47 GMT

Hi all,
In my lab I am trying to install an HP SIM 5.0 SP5 on the W2K3 SP1, with the SQL2K DB located on the different server (also on a W2K3 SP1 server). They are both VMs on the same ESX3 server (keep in mind that this is a lab install).

I am getting the infamous 'insufficient rights to database' msg. when I am installing the software.

I have read the other threads so I am familiar with the fact that the server role for the domain account should have system administrator or create database privileges (I have chosen the omnipotent SA role). The account I am logging in with is the same one that I have installed the SQL DB in (basically I am using the domain Admin account for everything install wise).

After all this I still can't get it to work. Getting very frustrated. Any help is greatly appreciated.

Cheers,

Stevan

Re: HP SIM 5.0 SP5 SQL Install troubles

Stevan Beara — Wed, 23 Aug 2006 23:45:28 GMT

Basically I found in one of the posts that I shouldn't create a DB ahead of time but let SIM create one for me. What was confusing is that the SIM prior to checking was showing the 'master' DB as the one to write the stuff in, and I didn't want to risk it.

Stevan

Re: HP SIM 5.0 SP5 SQL Install troubles

CA1050774 — Wed, 11 Oct 2006 06:09:51 GMT

Hi,

same problem here with SQL 2005

Re: HP SIM 5.0 SP5 SQL Install troubles

Stevan Beara — Wed, 11 Oct 2006 07:38:50 GMT

Hey Robert,
Basically instead of creating a DB you need to point the installer to the master DB and provide the right credentials (please check other threads for exact privileges you need to have to create the DB within SQL). Don't worry HP SIM does not overwrite (or modify) your master DB in any way, it creates another DB.

Hope this helps,

Stevan