Problem with HP SIM SQL Install.

[Hanré Van Rensburg]

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!

[May_11]

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

[Hanré Van Rensburg]

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]

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]

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]

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]

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

[James Kennedy_4]

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

[Hanré Van Rensburg]

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]

Hi,

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

[Jameson Sow]

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

[The Lord Pakal]

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

[May_11]

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

[Server-Support]

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.

[hafeez.mohammed]

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]

wowthat is so good solution Mr. Mohammed.

[Vijaykumar pandurangan]

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]

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

[alaa_atef]

i can not install hp sim 7400 message atachment screenshot

i want install how can i slove this problem

[Andrew_Haak]

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.