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 - S
ERVER
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 Enterpri
se
> Manager - sql query analyzer to get a list of them all (name, current stat
us,
> the databases under each of them)? or have to use some other tool to do i
t?
> thank you very much!

No comments:

Post a Comment