topic Re: Unable to connect to specified database in Server Management - Systems Insight Manager

Unable to connect to specified database

Steven Baillie — Wed, 20 Jul 2011 17:22:50 GMT

I am trying to install new installation of HP System Insight Manager 6.3 on Windows Windows 2008 R2 SP1 with remote SQL database on Windows 2008 R2 and SQL standard edition 64 bit version 10.0.4064.0.

My sql admin has already created my database called HPCMS and given me the rights of

dbowner.

Every time I try and Install HP sim I get the following error at the database configuration window.

Unable to connect to the specified database. check the specified hostname, instance name, database and port values. Also be sure that the SQL browser Service or SQL agent service is running on the database server.

I have checked the remote sql server and both services are running.

I have read in the forums that the installation wants to create the database itself and that we can not use a new database created for this. Is this correct.

Re: Unable to connect to specified database

caveneyp — Thu, 21 Jul 2011 12:22:43 GMT

this is of interest to me as well, since I am having the same related issue, with the exception that I did not pre-create my DB as I have SQL admin priveleges and was allowing SIM to create the DB itself.

I have a named instance that I have an alias created for and cannot seem to get any of the credentials to work during the install process for SQL information. see below the information that I posted to another board in the improper area on everything that it is that was tried. we both would appreciate any assitance. thank you!

-------------

Trying to install HPSIM to use a remote instance of SQL and does not seem to be working as expected. is this possible? all the instructions state is that it can connect or install SQL express or connect to an existing SQL 2008 install. I would like to attach the HPSIM to a DB server located in an alternative zone that has a named instance. Any assistance would be greatly appreciated.

I have attempted the install in the following methods and have not worked, which is why I am addressing the question as to if it even does work, or I am providing invalid credentials.

user: my domain account that the SQL server is located in

pass: my password

domain: domain the SQL server is in

host: have tried virtual name, hostname, IP, and entire SQL instance name (virtual name\instance name)

instance (use this one): virtual name when IP, hostname or virtual name have been defined, or left blank with entire SQL instance name used.

all fail with:

---------------------------
Install Shell
---------------------------
Unable to get information from the specified database server.
---------------------------
OK
---------------------------"

Re: Unable to connect to specified database

ompee — Fri, 22 Jul 2011 12:51:08 GMT

i had the same issue and to overcome this i let the installation create the database for me and it worked like a charm.

Re: Unable to connect to specified database

markstamp22 — Thu, 04 Aug 2011 19:30:35 GMT

So I have been having the same issue. However when I changed the instance to the Use Existing: MSSQLSERVER I get a new error Insufficient rights to database.

Re: Unable to connect to specified database

Steven Baillie — Fri, 26 Aug 2011 13:17:07 GMT

I had log a call with HP.

HP's answer is that you can not create a database manually and point the HP SIM installer to this database.

You must have rights to create a database and allow the HP SIM installer to create a new database itself.

steven

Re: Unable to connect to specified database

Robblue2 — Fri, 29 Mar 2013 18:51:34 GMT

What worked for me was:

- Open SQL Server Configuration Manager from the Start menu and expand the entry SQL Server Network Configuration in the left window pane.

- Ensure that Named Pipes is set to Enabled.

- Double-click on TCP/IP and go to the IP Addresses tab. Double check the TCP Port for all interfaces (in my case it differed from the usual 1433) and use that value when trying to connect to SQL.

Hope this helps.

Re: Unable to connect to specified database

Joe-B — Fri, 03 May 2013 14:33:08 GMT

Excellent! That worked for me. Under the IP tab for the TCP/IP my port was 47xxx instead of the default.

Thanks.

@Robblue2 wrote:
What worked for me was:

- Open SQL Server Configuration Manager from the Start menu and expand the entry SQL Server Network Configuration in the left window pane.

- Ensure that Named Pipes is set to Enabled.

- Double-click on TCP/IP and go to the IP Addresses tab. Double check the TCP Port for all interfaces (in my case it differed from the usual 1433) and use that value when trying to connect to SQL.

Hope this helps.

Re: Unable to connect to specified database

Kukan — Wed, 31 Jul 2013 15:58:39 GMT

Yes, Robblue2 's solution worked.

Re: Unable to connect to specified database

bdh0001 — Mon, 27 Jan 2014 19:59:32 GMT

Thank you Robblue2, work me me as well!

Re: Unable to connect to specified database

jkn48336 — Mon, 22 Sep 2014 00:39:08 GMT

Worked for me too on a ML350 64bit server 2012 r2

Re: Unable to connect to specified database

HalfPastFive — Fri, 08 Jan 2016 19:59:56 GMT

A Massive THANK YOU! This fixed my problem!!

Thank you again for taking the time to post this and help.

Re: Unable to connect to specified database

kevin_sas — Wed, 29 Jun 2016 09:24:21 GMT

Worked for me too, thanks a lot.

IMC 7.2, SQL express 2008.

Thanks to HP for their great documentation, i loved them (it is a joke)

Re: Unable to connect to specified database

AnkurSrivastava — Thu, 19 Sep 2019 15:19:27 GMT

Thanks Robblue,

It certainly helped me.

Appreciate your help