By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,908 Members | 2,056 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,908 IT Pros & Developers. It's quick & easy.

Enumerating MSDE Named Instances in C#... Re-visited

P: n/a
Hi all,

After a lot of research, I've come to some realizations about enumerating
Named Instances of MSDE. NetServerEnum() Win32 API function doesn't work,
SQL-DMO doesn't work, no standard routines seem to work. SQL-DMO is by far
the most robust solution - since it calls NetServerEnum() first, and
subsequently sends out a broadcast on Port 1433 to locate all SQL Servers on
the network. This does pick up all default instances (as long as you're
connected to a network that is...), but no named instances.

Anyway, to the point of the matter: I read that you can send a UDP
broadcast on Port 1434 that will return all SQL Server and MSDE named
instance info. on a subnet. Is it possible to do this for a Domain, and can
someone point me in the direction of some code to send a UDP broadcast to
Port 1434?

Thanks in Advance,
Michael C.
Nov 16 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.