Cannot find server error after softpaq update on SQL Server

[Rob Buxton]

Hi All,
Our setup for HPSIM is that SIM sits on one Server (W2000), and the SQL Server backend on another (w2003).
All was working well.

I updated the entire softpaq on the SQL Server Server. And rebooted it.
I was logged in to HPSIM from my workstation at the time.

I now cannot conenct to HPSIM. It comes up with "Cannot find Server or DNS error".
I've tried:
Stopping and restarting the Insight Manager Service. The Service is
Connecting to both http://server:280 and https://server:50000.
I can connect to http://server and access pages from our Web server and I can access the Agents on the IM Server.

Any hints or tips appreciated.

[Rob Buxton]

I rebooted the Server and things have come right.
A few odd things happened after the reboot.
There was a file called Program in C: which the post reboot checks suggested be renamed.

The OpenSSH Service did not start.

Started the OpenSSH Service manually and got rid of the program file after checking its contents. I need to try and find out what created it.

But the browser now works okay. I'm hoping that a reboot of the SQLServer server doesn't always mean a reboot of the HPSIM Server.

[James Kennedy_4]

You could be right about having to reboot, but that does somewhat defeat the purpose of having services.

One thing to check is make sure that the SIM server running on Windows 2000 is running MDAC 2.8, you'll find this fixes stupid things with SQL connections.

Another thing you can try, if this happens again, is to open up the ODBC connections and try to connect to the SIM Database using that tool. If that doesn't work, then you have other issues. If it does, and SIM doesn't than you can go back to blaming it on SIM :)

[David Claypool]

Surely this isn't the case, but if you have a file named c:\program its 8.3 name probably would become PROGRA~1 and then possibly make c:\program files turn into PROGRA~2...something to think about...

[Rob Buxton]

Okay, so far MDAC is indeed 2.8.
The file "program" contained SID info for my account, I think I must've created this while I was trying to add my name to the OpenSSH passwd file. Obviously left some quotes off in a command somewhere!

I seem to recall getting an e-mail because a Server was done during this process so my guess is that the SIM to Database connection was okay. But, I'll confirm this if it happens again.