?
Solved

HP SIM Installation

Posted on 2014-09-08
5
Medium Priority
?
1,371 Views
Last Modified: 2014-09-15
Hi, I am installing HP Systems Insight Manager on a HP Proliant ML350p Gen 8 server with Windows Server 2008 R2 OS.
The server is already configured with SQL express for Symantec Backup Exec 2014.
When I run the HP SIM installation, at the Database configuration screen it pre populates the Instance name with BKUPEXEC.
I guess I need to have a unique name for the HP SIM DB, I have tried MSSQLSERVER plus a random name but neither work.
MSSQLSERVER gives an error of MSSQLSERVER name cannot be used, any other name gives me the error of unable to connect to the specified host.
regards
Rick
0
Comment
Question by:Rick_Penney
[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
  • 3
  • 2
5 Comments
 
LVL 7

Accepted Solution

by:
Milind Koyande earned 2000 total points
ID: 40309748
You will have to check the hostname of your sql server and the instance name. You can use  following to find the SQL Server and instance name:
SQL Server Instance Name :
 
In SQL Server Management Studio->RegisterServers->double click your server to open the Object Explorer -> right click to select the properties window ->General Tab - to see the ServerName (instance name)
 
or Open a new query in SQL Server Management window  and execute the following
 
-- to get the sql server instance name
 
select @@ServerName

Open in new window


The you will have to use the SQL Server name with instance (if any) as DB Host while configuring HP SIM. I think "BKUPEXEC" if you DB HOST name which shouldn't be changed. You will have to create a new Database and provide it.
0
 

Author Comment

by:Rick_Penney
ID: 40309859
Hi, many thanks for your reply.
Please bear with me as I have no experience with SQL.
I have installed the Management Studio and the Server instance name is <hostname>\bkupexec
If I try to install HP SIM leaving the instance name as "use existing" BKUPEXEC it tries to validate but gives error of unable to connect to the specified host. please check database and port values and be sure the target database is running.
I've gone back into the Management studio and right clicked on Database and created a new database called HP_SIM. When I run the HP SIM installer and change the instance name to HP_SIM I get the same connection error message.
regards
Rick
0
 

Assisted Solution

by:Rick_Penney
Rick_Penney earned 0 total points
ID: 40310266
I have managed to resolve this by using the SQL server network configuration tool.
Backup exec had changed the default port number of 1443 to 50443
once I changed this HP SIM installed fine
0
 
LVL 7

Expert Comment

by:Milind Koyande
ID: 40310273
Apologize for the delay in reply.. Glad your issue has been resolved.
0
 

Author Closing Comment

by:Rick_Penney
ID: 40322693
Reason for also accepting my comment as part of the solution was that the comment Milind Koyande  kindly provided steered me in the right direction but after finding the remainder of the information myself using the SQL server network configuration tool, I was then able to proceed with the installation.
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

This article explains how to install and use the NTBackup utility that comes with Windows Server.
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 …
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…
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…
Suggested Courses

777 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