Monday, March 26, 2012

multi instances of sql server

Hi,
if I have 3 instances of sql server 2000 on a machine, how to use Enterprise
Manager - sql query analyzer to get a list of them all (name, current status,
the databases under each of them)? or have to use some other tool to do it?
thank you very much!
As I gather they are not showing up, check to see if these instances are
using TCP/IP or NAMED PIPES. [Start Programs - Microsoft SQL Server - SERVER
NETWORK UTILITY]. They may not show in the active directory - or at least
not allow connections - if one of these two protocols is not enabled.
Regards,
Jamie
"bangwo" wrote:

> Hi,
> if I have 3 instances of sql server 2000 on a machine, how to use Enterprise
> Manager - sql query analyzer to get a list of them all (name, current status,
> the databases under each of them)? or have to use some other tool to do it?
> thank you very much!
sql

No comments:

Post a Comment