Solved

HP SIM Installation

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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This article explains how to install and use the NTBackup utility that comes with Windows Server.
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

831 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