HP SIM Installation

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
Rick_PenneyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Milind KoyandeCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Rick_PenneyAuthor Commented:
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
Rick_PenneyAuthor Commented:
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
Milind KoyandeCommented:
Apologize for the delay in reply.. Glad your issue has been resolved.
0
Rick_PenneyAuthor Commented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.