Upgrade problem from 4.1 to 4.2

[Dustin Bunyan]

When trying to upgrade Insight Manager from version 4.1 to 4.2 on a Windows 2000 server, I choose "Typical Install" and at the "Account Authentication and Database Selection" page I type the correct password. On clicking "Next", there is a pause and then the error message "Unable to connect to the specified database server." appears. I have tried performing the upgrade when logged in as both my own Domain Admin account and also the local Administrator account, neither of which has worked.

The server has HPSIM4.1 along HP WebJetAdmin, PMP and RDP server plug-ins.

Could this be a problem with named instances? nfortunately I know nothing about MSDE and wouldn't know how to check if we are using named instances. There is nothing else installed on this server.

[Antony Villa · Accepted solution]

Dustin,
I had this problem too and this is what fixed it for me:

1. Look in :\Program Files\Microsoft SQL Server\80\Tools\Binn
2. Locate Svrnetcn.exe and run it.
3. When you look in there, you should see that there are no enabled protocols.
4. Add "Named Pipes" and "TCP/IP" to the list and ok it.
5. Stop and start your MSSQL service.
6. You should be OK now.

Don't know what this will do for your security settings, but anyway.

Good luck!

Tony

[Dustin Bunyan]

That worked a treat. Thanks for your time Tony.