Solved

HP SIM Installation

Posted on 2014-09-08
5
1,239 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 500 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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

738 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