topic MSDE and HP Insight Manager in Server Management - Systems Insight Manager

MSDE and HP Insight Manager

Daniel_262 — Thu, 23 Sep 2004 13:59:11 GMT

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.

Re: MSDE and HP Insight Manager

Joel Rubenstein — Mon, 27 Sep 2004 08:12:34 GMT

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