Solved

HP SIM Installation

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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
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 locating and launching the BEUtility application and how to execute it on the appropriate database. Log onto the server running the Backup Exec database. In a larger environment, this would generally be …
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…

743 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now