[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

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

Posted on 2011-02-16
15
Medium Priority
?
1,744 Views
Last Modified: 2012-05-11
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
Comment
Question by:jjoz
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 9
  • 6
15 Comments
 
LVL 123
ID: 34915882
What's the issue you are having?

What are the error messages?
0
 
LVL 1

Author Comment

by:jjoz
ID: 34920332
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
 
LVL 123
ID: 34920459
Do you have SQL installed?
0
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 
LVL 123
ID: 34920576
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
 
LVL 1

Author Comment

by:jjoz
ID: 34921383
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
 
LVL 123

Accepted Solution

by:
Andrew Hancock (VMware vExpert / EE MVE^2) earned 2000 total points
ID: 34921651
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
 
LVL 123
ID: 34921671
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
 
LVL 1

Author Comment

by:jjoz
ID: 34921678
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
 
LVL 123
ID: 34921695
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
 
LVL 1

Author Comment

by:jjoz
ID: 34921728
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
 
LVL 123

Assisted Solution

by:Andrew Hancock (VMware vExpert / EE MVE^2)
Andrew Hancock (VMware vExpert / EE MVE^2) earned 2000 total points
ID: 34921744
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
 
LVL 123

Assisted Solution

by:Andrew Hancock (VMware vExpert / EE MVE^2)
Andrew Hancock (VMware vExpert / EE MVE^2) earned 2000 total points
ID: 34921758
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
 
LVL 1

Author Comment

by:jjoz
ID: 34921775
yes as the DOMAIN\Admin in which I'm logging on with it now.

many thanks for your explanation and guidance mr. Hancock
0
 
LVL 123
ID: 34921815
no problems, glad I could help. Any further questions just post them, and I'll be waiting.
0
 
LVL 1

Author Comment

by:jjoz
ID: 34921915
no worries, I always glad that i become the member of this forum.
0

Featured Post

Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
New style of hardware planning for Microsoft Exchange server.
This tutorial will give a an overview on how to deploy remote agents in Backup Exec 2012 to new servers. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as connecting to a remote Back…
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…

649 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question