MSDE and HP Insight Manager

[Daniel_262]

While setting up for HP Insight Manager...

Microsoft provided documentation is leading me to believe that MSDE 2000 SP3 and previous versions of MSDE could coexist on one box.

Is that true?

I installed MSDE 2000 SP3 on one of my servers which had a previous MSDE version with existing active databases. The result was that though databases were still running, I had difficulty seeing the certain databases through Enterprise Manager.

[Joel Rubenstein]

The version of MSDE (sp3a) released with SIM 4.1 implements additional security by turning off network protocols. The result is that the databases are not visible to SQL enterprise manager.

To re-enable the TCP/IP protocol so the databases are visible go to:


C:\Program Files\Microsoft SQL Server\80\Tools\Binn

and run svrnetcn.exe. Then able the TCP/IP protocol for each database instance

For more information see:

http://support.microsoft.com/default.aspx?kbid=814130