Link to home
Start Free TrialLog in
Avatar of jjoz
jjozFlag for Australia

asked on

Need help in Configuring HP Systems Insight Manager with SQL Server 2005/2008 DB ?

Hello Everyone,

I'm unable to proceed in the DB setup / configuration wizard here.

Can anyone share your configuration or any pointer to get the documentation regarding setting up SQLServer 2005/2008 DB for the HP SIM ?

Thanks.
Avatar of Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)
Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)
Flag of United Kingdom of Great Britain and Northern Ireland image

What's the issue you are having?

What are the error messages?
Avatar of jjoz

ASKER

Thanks for your reply I've no clue at all Of what database and The credentials to create in sql server before i install SIM ?
Do you have an SQL server installed to use for the database, or do you want to use the SQL Express included with HP SIM?
Avatar of jjoz

ASKER

yes i do have Production SQL Server 2005 ready in place but don't know whatto set during the initial DB selection criteria ?

but when I select MSSQLSERVER and using DOMAIN\Admin account it works of course I don't and can't do that.
ASKER CERTIFIED SOLUTION
Avatar of Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)
Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
You cannot pre-create the DB and then give HP Sim a DB-Owner account. HP SIM wants to create the DB and therefore needs an account that has appropriate access to "master" to do so.  
Avatar of jjoz

ASKER

ah, so in this case everytimethe DOMAIN\Admin account is changed, then I must schedule the downtime for this SIM server and agent domainwide because the CMS server communication will also use the DOMAIN\Admin credentials ?

ah great, i thought that it would create MSSQLSERVER as the database instance
what don't you create another Admin Account for HP SIM?

This is what we do, we have special Admin accounts, for different Services?
Avatar of jjoz

ASKER

ok, so this HPSIM Admin account needs to be the member of the DOMAIN\Administrator ? as wel las the dbowner in the SQL Server right ?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jjoz

ASKER

yes as the DOMAIN\Admin in which I'm logging on with it now.

many thanks for your explanation and guidance mr. Hancock
no problems, glad I could help. Any further questions just post them, and I'll be waiting.
Avatar of jjoz

ASKER

no worries, I always glad that i become the member of this forum.