Enumerating Named Instances of SQL Server/MSDE

[Michael C]

Hi all,

I am currently using a Win32 API call to NetServerEnum to enumerate all SQL
Servers on an NT Domain. The function returns the names of all servers
running SQL Server on the network, but it doesn't return any SQL Server/MSDE
named instances. Does anyone have any ideas on how to enumerate all named
instances of SQL Server/MSDE on a Domain as well as the default instances?

Thanks,
Michael C.

 

[Shiva]

Hi,

Here is an another way to do it:
http://www.codeproject.com/cs/database/LocatingSql.asp

Hi all,

I am currently using a Win32 API call to NetServerEnum to enumerate all SQL
Servers on an NT Domain. The function returns the names of all servers
running SQL Server on the network, but it doesn't return any SQL Server/MSDE
named instances. Does anyone have any ideas on how to enumerate all named
instances of SQL Server/MSDE on a Domain as well as the default instances?

Thanks,
Michael C.

 

[Michael C]

Hi Shiva,

I actually tried that method but it didn't work seem to work for MSDE named
instances for some reason... Oh well, back to the drawing board...

Thanks,
Michael C.

 

[FusionGuy]

http://www.codeproject.com/csharp/CompPickerLib.asp

The best way is to use SQL-DMO.

 

[Michael C]

Even tried that (though I'm a little wary of it since I can't guarantee that
every installation of my app will also have SQL Client Tools installed
also)... It doesn't pick up anything if you disconnect from the network -
even if there are local instances running. Also had some problems with MSDE
named instances with SQL-DMO too. I think SQL Enterprise Manager uses
SQL-DMO, and it doesn't detect named instances automatically either on
server registration.

Strange.

Thanks,
Michael C.

 

[Benny Tordrup]

Michael, se my posting in the thread
Re: Get all sql servers on network from dot net app.. sqldmo or reflection

in microsoft.public.sqlserver.programming

 

[Michael C]

Thanks, but it like NetServerEnum and the other API functions it doesn't
seem to pick up Named Instances which is what I need.

Thanks
Michael C.