New to HP SIM issue HPSIM install SQL connection Issue

[chrys7]

Been searching these forums and found several things to check but still nothing that solves my issue,

I am new to HP SIM trying to get it going.

Installing HPSIM on a VM/Win 2008 R2 Std

My SQL is Physical, Win2003 R2 Std with Sql 2005 SP4.

Im getting the ol Unable to get information from the specified DB Server.

I checked the Acct im using it has DB Create/ServerAdmin/Sysadmin, SQL browsing is running. WIn Firewall on HP SIM Svr is off.

I am entering the following info

Selecting : Use SQl/SQL Express

username: adminacct

password: ******

domain: mydomain

Host: HIPSIMServer

Instance Name: use this one: SQLSERVERNAME

Port 1433.

I can telnet to the the IP of my sql box on port 1433 from the SIM Server and it connects...

Anyone have any ideas Im at my wits end here.

[KubaL]

same problem here on physical Win 2008 R2 standard with local SQL Express 2008 R2. using windows authentication here.

HP SIM says "Unable to get information from specified database server"

Settings are correct as I can log on to db instance using command prompt sqlcmd ...

what am I missing?

EDIT:

After I enabled SQL Browser it passes credential check, but gives me another error like page cannot be displayed ....

what an annoying piece of software.

[jim goodman]

Jakub it sounds like you are using IE9 or another unsupported browser.

[jim goodman]

Chrys are you using the SIM installer or the Insight Software Integrated Installer?

Are you using domain/acct?

UAC turned off?

Finally double check Browser Service from inside of SQL and not from Services itself - I have seen the Browser Service stopped in SQL but started in Services with SQL2k5

[KubaL]

---

@jim goodman wrote:

Jakub it sounds like you are using IE9 or another unsupported browser.

---

Yes, I tried IE9 as this is what I installed on 2008 R2 server ...

However I also tried Firefox 5.0 and that doesn't work either?

Should I try Google Chrome? does this softare work with any brand of modern browser?

or download some other older version of Firefox? not sure which one works right on x64 R2 though ...

[jim goodman]

Those are all unsupported rolling back to IE8 would be optimum, see this related advisory for details on how to do that. It is pretty painless and would save you having uninstall and reinstall other browsers.

http://h20000.www2.hp.com/bizsupport/TechSupport/Document.jsp?objectID=c02945254

[KubaL]

---

@jim goodman wrote:

Those are all unsupported rolling back to IE8 would be optimum, see this related advisory for details on how to do that. It is pretty painless and would save you having uninstall and reinstall other browsers.

http://h20000.www2.hp.com/bizsupport/TechSupport/Document.jsp?objectID=c02945254

---

OK, thanks!

will downgrade the native browser to IE8 following the advisory.

[Micke_Ch_1]

Hi all!

Please check to see if port 1434 is open at DB server. This is the SQL browser port = must be open.

You can also check the logs in c:\hpic\sql...something.

Best Regards

/Micke Ch

[KubaL]

---

@jim goodman wrote:

Those are all unsupported rolling back to IE8 would be optimum, see this related advisory for details on how to do that. It is pretty painless and would save you having uninstall and reinstall other browsers.

http://h20000.www2.hp.com/bizsupport/TechSupport/Document.jsp?objectID=c02945254

---

just wanted to confirm, that HP SIM installer runs fine on IE8 and I am installing all components as I type. Thanks for pointing out the IE9 incompatibility, it was the culprit (Page cannot be displayed).

[jim goodman]

Jakub - I am glad it was that easy for you, thanks for letting me know

[shocko]

The only way I could get the SIM install to work was to allow the Insight Control Installer to install the DB and not have the DB pre-configured :(

[jim goodman]

Curious Shocko - when you say db preconfigured what do you mean?

In an attempt to explain why one installer worked and the other didn't.

There is a difference in the architecture of the installers - the SIM installer is java and Insight Integrated Installer is .NET. If one works with one and not the other you you have to look at the requisites to 1) support the architecture and 2) the pre-reqs for installation.

For example if SIM installer is not making the SQL Connection but the intregrated installer is you need to consider your Java version, conficts and cache ADDITIONALLY the SIM installer is looking for the SQL Browser Service to be running if looking at an existing SQL Server to host the db the Integrated Installer does not.

Of course there may be other considerations, even changes to the architecture I am not privy to in recent releases.

[shocko]

Hi Jim,

I suppose what I was alluding to was that I was never able to get SIM to install to an existing SQL Express instance. I always had to allow the installer to install SQL EXpress. Perhaps my issue was that when I installed the DB engine manually, the SQL browser service wasn't running and hence the installer could not properly query the DB?

[KubaL]

I actually was able to install HPSIM on a 2008 R2 server running MS SQL Express 2008 R2 (our default SQLexpress instance is occupied by WSUS3).

Just let the HPSIM installer create a new instance (e.g. HPSIM) and it should do it all automatically, but the SQL Server Browser MUST be running. otheriwse it won't work, ah and use IE8.

that's how I installed mine, I think. can't remember actually if I had to manuall create the HPSIM instance,r eset username and password (as well as set to Mixed mode with windows/SA working), maybe I did that too, sorry can't recall details.

[jim goodman]

Yeah - SQL Express is a different creature. To use an existing SQL Express instance you have to manually do some things to meet with the installation requirements of SIM. SQL Express default installs without the Browser Service running, in SQL Authentication mode, etc. So you'd have to do some leg work to meet the installation requirements for SIM to use an existing db.

To get an idea here is a link for SQL Express 2005 - I am not sure of the changes to for Express 2008 R2, but you can google it. I haven't done it since MSDE so I am not current on using existing SE 2008R2 - may be someone else will pipe in.

http://msdn.microsoft.com/en-us/library/ms143722%28v=sql.90%29.aspx

I hope that helps make sense of it a bit.