Re: Enumerate computers on network running SQL Server

Since SQL server is capable of running on an arbitrary port, the only
reliable way of doing what you want is quering Active Directory (provided
that we are talking about SQL2000 in domain environment). Quering the AD
from .NET CF is painful. You may be able to do it easier via web service

"Ian Williamson" <bmcpeake@nospam.shaw.ca> wrote in message
news:068b01c344de$b51d4a50$a301280a@phx.gbl...
> Greetings,
>
> I would like to be able to enumerate all computers that
> are on the network that have an instance of SQL Server
> running. Any ideas?
>
> Cheers, Ian Williamson
>
>

Fair enough.

How about just enumerating ALL computers on the network
then?


>-----Original Message-----
>Since SQL server is capable of running on an arbitrary
port, the only
>reliable way of doing what you want is quering Active
Directory (provided
>that we are talking about SQL2000 in domain
environment). Quering the AD
>from .NET CF is painful. You may be able to do it easier
via web service
>
>"Ian Williamson" <bmcpeake@nospam.shaw.ca> wrote in
message
>news:068b01c344de$b51d4a50$a301280a@phx.gbl...
>> Greetings,
>>
>> I would like to be able to enumerate all computers that
>> are on the network that have an instance of SQL Server
>> running. Any ideas?
>>
>> Cheers, Ian Williamson
>>
>>
>
>
>.
>