Enumerate SQL server list?

[Earl]

Anyone know how to enumerate the SQL Servers on a network using .Net? I can
do this with VB6, but howso in .Net?

 

[Miha Markic [MVP C#]]

Hi Earl,

One way would be:
Q287737
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q287737&

 

[Earl]

Hi Mika,

This is essentially the same thing I'm doing now in VB6, but I was looking
to see if there was another way to not use a COM reference in order to do
this with .Net. Maybe this is the wrong way of looking at this -- what am I
giving up using COM here? Incidentally, I've been on that RightHand site in
the past, good stuff you folks are building over there.

Hi Earl,

One way would be:
Q287737
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q287737&

--
Miha Markic [MVP C#] - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

Anyone know how to enumerate the SQL Servers on a network using .Net? I can
do this with VB6, but howso in .Net?

 

[Earl]

Miha,

Using this VB6 method, I get an invalid cast exception when I try to create
an object for the namelist (Dim oNames As SQLDMO.NameList). Even with a
Try-Catch, I still get the exception: "Query Interface for interface
SQLDMO.Namelist failed." Is this a COM wrapper issue?

Hi Earl,

One way would be:
Q287737
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q287737&

--
Miha Markic [MVP C#] - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

Anyone know how to enumerate the SQL Servers on a network using .Net? I can
do this with VB6, but howso in .Net?

 

[Guest]

I'm going to assume your using SQL Server 2000. You will get this exception if you have not upgraded to SP2. So you want to make sure you're using at least SP2 with this code.

 

[Earl]

Thanks Roy. Yes, SQL Server 2000 for development, although I intend to
attach my interface to an MSDE installation. Not sure about the SP, so I'll
give it a go.

I'm going to assume your using SQL Server 2000. You will get this

exception if you have not upgraded to SP2. So you want to make sure you're
using at least SP2 with this code.

 

[Earl]

No joy even with SP3a installed. Somewhat frustrating, as I've not found
anything on this published anywhere. I mean, how uncommon can it be to have
to enumerate the server list in .Net?? Thanks again for the pointer Roy.

I'm going to assume your using SQL Server 2000. You will get this

exception if you have not upgraded to SP2. So you want to make sure you're
using at least SP2 with this code.