Re: Enumerate computers on network running SQL Server

#1

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 (AT) nospam (DOT) shaw.ca> wrote

Quote:

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

#2

Fair enough.

How about just enumerating ALL computers on the network
then?

Quote:

-----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 (AT) nospam (DOT) shaw.ca> wrote in
message
news:068b01c344de$b51d4a50$a301280a (AT) phx (DOT) 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

.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Enumerate computers on network running SQL Server

Dotnet Framework (Compact Framework) microsoft.public.dotnet.framework.compactframework

Re: Enumerate computers on network running SQL Server - 07-07-2003 , 08:14 PM

Re: Enumerate computers on network running SQL Server - 07-07-2003 , 09:11 PM