Server Management - Systems Insight Manager
1827749 Members
3063 Online
109969 Solutions
New Discussion

Re: Problem with HP SIM SQL Install.

 
Hanré Van Rensburg
Occasional Advisor

Problem with HP SIM SQL Install.

Hi,

Everytime I try to install SIM and get to the DBase Config page the install fails with error "Unable to get information from the specified database server."

I've installed SQL Express 2005 SP2 locally on the same machine I'm trying to install SIM on and enabled Named Pipes & TCP/IP connections to it. I'm configuring SIM to use the 'sa' SQL credentials but it just pops back with this error everytime.

Is there some other configuration change I need to make to SQL before I can install SIM on this machine?

Cheers!
19 REPLIES 19
May_11
Advisor

Re: Problem with HP SIM SQL Install.

May be check the local ODBC->System DSN-> insight_v**** Configuration to see either it is matching your setting.
Hanré Van Rensburg
Occasional Advisor

Re: Problem with HP SIM SQL Install.

There is no data source with that value there. There's only 2 data sources that both correspond to the SQL Backup Agents installed on the server.
May_11
Advisor

Re: Problem with HP SIM SQL Install.

If you don't mind either using 'sa' SQL authentication or Window NT authentication for SIM db, just change to Windows network login credentials. Or reinstall SQL express 2005 via SIM package which will configuring everything (Window NT login) for SIM db connnection. Hope it's helps.
Ervinck Kevin
Valued Contributor

Re: Problem with HP SIM SQL Install.

Be sure you have a standard SQL Server Express 2005 SP2 installation. Don't even think about changing the collation.
One chance you have in solving this problem is to try to use Windows Authentication instead of the sa account.
Hanré Van Rensburg
Occasional Advisor

Re: Problem with HP SIM SQL Install.

I have changed to just Windows authentication, it was mixed before with still no luck.

The SQL install is standard, I just ran the installation with all default parameters checked and then started the SIM install.

Any more ideas anyone?
May_11
Advisor

Re: Problem with HP SIM SQL Install.

Probably check the windows firewall settings.
Hope it's helps.
James Kennedy_4
Trusted Contributor

Re: Problem with HP SIM SQL Install.

make sure you don't specify a database name when installing. Leave it as 'master'.
Hanré Van Rensburg
Occasional Advisor

Re: Problem with HP SIM SQL Install.

Windows Firewall is disabled and I'm leaving all default SQL settings.

I get the error:

Install Shell - Unable to get information from the specified database server.
Cristian Hasler
Occasional Contributor

Re: Problem with HP SIM SQL Install.

Hi,

You must enable the "SQL Browser Service" for the SQL 2005 Express server.
Jameson Sow
New Member

Re: Problem with HP SIM SQL Install.


by starting the SQL Server Browser, it works. I have just tested it when installing HP-SIM ver 6.20

The Lord Pakal
New Member

Re: Problem with HP SIM SQL Install.

I tried everything i still can not install
"Unable to connect to the specified host...."
May_11
Advisor

Re: Problem with HP SIM SQL Install.

Not sure the SQL installed and configured with default or customized instance name?
Server-Support
Super Advisor

Re: Problem with HP SIM SQL Install.

Hi Hanre,

How did you go with this problem ? i also face some difficulties in setting up new instance of HP SIM with SQL Server 2005 now.
Best regards,
hafeez.mohammed
New Member

Re: Problem with HP SIM SQL Install.

Hello There,

I had similar issue while installing HPSIM 6.2 with SQL 2008 Express Edition. SQL Browser service was disabled in default install. Enabled and started and all worked fine.

Server-Support
Super Advisor

Re: Problem with HP SIM SQL Install.

wowthat is so good solution Mr. Mohammed.
Best regards,

Re: Problem with HP SIM SQL Install.

Hi,
I am trying install and setup HP SIM on a windows 2008 R2 X64 bit (DL380G5)server. I have my database in a enterprise SQL server (2008 SQL server) in same domain, name of the database is hp_sim. I am able to connect to the database using DSN , but when i try install HP Sim and give the details i am getting all types of error like host not reachable, check the port, Database credentails are not correct , database doesn't exist. Did anyone came across this type of problem ? any inputs much appreciated.
Thanks
May_11
Advisor

Re: Problem with HP SIM SQL Install.

Check SQL network protocol TCP/IP with enabled status. Might be set named pipe protocol enabled too. Hope it's helps.
alaa_atef
Occasional Visitor

Re: Problem with HP SIM SQL Install.

i can not install hp sim 7400 message atachment screenshot

i want install how can i slove this problem

Andrew_Haak
Honored Contributor

Re: Problem with HP SIM SQL Install.

Hello,

 

Is that the screenshot as you tried to install the software? I would guess that you need to type your localhostname in the SQL server name fields.

Kind regards,

Andrew