Home All Groups Group Topic Archive Search About

Discover SQL Servers on network

Author
30 Jun 2006 6:19 PM
Microsoft
In my app I want to create a drop down that lists the available SQL Servers
on the Network. How do I discover what servers are out there?

This is exactly like when you use File/Connect in Query Analyzer, you select
the server you want to connect to then you enter you credentials or use
Windows Auth. I just want the servers though.

Thanks,

Steve

Author
30 Jun 2006 7:17 PM
tlkerns
If you're using .net 2.0, check the SqlDataSourceEnumerator Class.

Tony

Show quoteHide quote
"Microsoft )IntraRELY.com>" wrote:

> In my app I want to create a drop down that lists the available SQL Servers
> on the Network. How do I discover what servers are out there?
>
> This is exactly like when you use File/Connect in Query Analyzer, you select
> the server you want to connect to then you enter you credentials or use
> Windows Auth. I just want the servers though.
>
> Thanks,
>
> Steve
>
>
>