[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1776
  • Last Modified:

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.
0
jjoz
Asked:
jjoz
  • 9
  • 6
3 Solutions
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
What's the issue you are having?

What are the error messages?
0
 
jjozAuthor Commented:
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 ?
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
Do you have SQL installed?
0
Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
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?
0
 
jjozAuthor Commented:
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.
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
Okay, so you have a production SQL server, that you would like to use. That's good you don't have to install SQL or SQL Express.

What cannot you do that?

 I select MSSQLSERVER and using DOMAIN\Admin account it works of course I don't and can't do that?

If you accept all default database settings the installation process will NOT use master DB, it will create new DB with following name "Insight_v62_0_xxxxxxxxx" where x is a timestamp when the database was created.

As for the account used I alwasy specify same account that the HP SIM is using to start up all services. That account is also used to communicate with all clients reporting to HP SIM so I would suggest that account to be Domain Account with Administrator privileges on all member servers.
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
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.  
0
 
jjozAuthor Commented:
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
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
what don't you create another Admin Account for HP SIM?

This is what we do, we have special Admin accounts, for different Services?
0
 
jjozAuthor Commented:
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 ?
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
We create special service accounts, in their own OU in AD,  the OU is called Service Accounts, and we create accounts like SERVICE_HPSIM, the password is complex, recorded, set to no-expiry, we grant membership to groups that are required.

This is the userid and password that is used the the installation, the password generated is cut and pasted between AD account creation and service account, recorded and locked in the safe.

nobody the knows it, and it's recorded just in case it's needed, we then don't have issues with password expiry, and services breaking.
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
Yes, you must install as a Domain Administrator.

But don't worry about SQL Database, it will create the database, (and create dbos) providing the account you are using has Access to the Master db on SQL.
0
 
jjozAuthor Commented:
yes as the DOMAIN\Admin in which I'm logging on with it now.

many thanks for your explanation and guidance mr. Hancock
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
no problems, glad I could help. Any further questions just post them, and I'll be waiting.
0
 
jjozAuthor Commented:
no worries, I always glad that i become the member of this forum.
0

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

  • 9
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now