jjoz
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.
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.
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 SQL installed?
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?
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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
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?
This is what we do, we have special Admin accounts, for different Services?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
yes as the DOMAIN\Admin in which I'm logging on with it now.
many thanks for your explanation and guidance mr. Hancock
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.
ASKER
no worries, I always glad that i become the member of this forum.
What are the error messages?