topic Re: Problem with HP SIM SQL Install. in Server Management - Systems Insight Manager

Problem with HP SIM SQL Install.

Hanré Van Rensburg — Tue, 24 Jun 2008 00:09:31 GMT

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!

Re: Problem with HP SIM SQL Install.

May_11 — Tue, 24 Jun 2008 15:01:50 GMT

May be check the local ODBC->System DSN-> insight_v**** Configuration to see either it is matching your setting.

Re: Problem with HP SIM SQL Install.

Hanré Van Rensburg — Tue, 24 Jun 2008 19:54:45 GMT

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.

Re: Problem with HP SIM SQL Install.

May_11 — Wed, 25 Jun 2008 14:40:47 GMT

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.

Re: Problem with HP SIM SQL Install.

Ervinck Kevin — Thu, 26 Jun 2008 06:27:22 GMT

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.

Re: Problem with HP SIM SQL Install.

Hanré Van Rensburg — Thu, 26 Jun 2008 19:41:14 GMT

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?

Re: Problem with HP SIM SQL Install.

May_11 — Fri, 27 Jun 2008 13:19:52 GMT

Probably check the windows firewall settings.
Hope it's helps.

Re: Problem with HP SIM SQL Install.

James Kennedy_4 — Mon, 30 Jun 2008 13:38:33 GMT

make sure you don't specify a database name when installing. Leave it as 'master'.

Re: Problem with HP SIM SQL Install.

Hanré Van Rensburg — Thu, 17 Jul 2008 01:12:29 GMT

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.

Re: Problem with HP SIM SQL Install.

Cristian Hasler — Wed, 06 Aug 2008 20:36:22 GMT

Hi,

You must enable the "SQL Browser Service" for the SQL 2005 Express server.

Re: Problem with HP SIM SQL Install.

Jameson Sow — Wed, 20 Oct 2010 13:49:01 GMT

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

Re: Problem with HP SIM SQL Install.

The Lord Pakal — Thu, 04 Nov 2010 14:25:27 GMT

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

Re: Problem with HP SIM SQL Install.

May_11 — Thu, 04 Nov 2010 18:29:30 GMT

Not sure the SQL installed and configured with default or customized instance name?

Re: Problem with HP SIM SQL Install.

Server-Support — Thu, 17 Feb 2011 03:05:03 GMT

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.

Re: Problem with HP SIM SQL Install.

hafeez.mohammed — Wed, 02 Mar 2011 10:43:12 GMT

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.

Re: Problem with HP SIM SQL Install.

Server-Support — Wed, 02 Mar 2011 22:35:14 GMT

wowthat is so good solution Mr. Mohammed.

Re: Problem with HP SIM SQL Install.

Vijaykumar pandurangan — Wed, 20 Apr 2011 01:04:51 GMT

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

Re: Problem with HP SIM SQL Install.

May_11 — Wed, 20 Apr 2011 20:53:46 GMT

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

Re: Problem with HP SIM SQL Install.

alaa_atef — Wed, 15 Oct 2014 16:38:14 GMT

i can not install hp sim 7400 message atachment screenshot

i want install how can i slove this problem

Re: Problem with HP SIM SQL Install.

Andrew_Haak — Thu, 16 Oct 2014 06:18:29 GMT

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.