How to find all sql servers in a domain

Hi,
Is there a way to find all available SQL Servers in a particular domain or
subnet?
Thanks.
- Rob.At the DOS prompt enter "OSQL -L" The -L option show all the servers that
are broadcasting on the network.
"Rob" wrote:
> Hi,
> Is there a way to find all available SQL Servers in a particular domain or
> subnet?
> Thanks.
> - Rob.|||ISQL /L from a machine that has the client tools installed or use SQL DMO.
Just be aware that within the server network utility you have the ability to
hide the server so this may not be conclusive.
"Greg Larsen" wrote:
> At the DOS prompt enter "OSQL -L" The -L option show all the servers that
> are broadcasting on the network.
> "Rob" wrote:
> > Hi,
> >
> > Is there a way to find all available SQL Servers in a particular domain or
> > subnet?
> >
> > Thanks.
> >
> > - Rob.|||osql /L will most likely not give you all the SQL servers in a domain unless
you have a tiny domain that has nothing routed and every machine is
broadcasting--an unlikely scenario.
The only reliable way I've found is to enumerate all the machines in a
domain and systematically test each machine for the presence of SQL server
instances.
Linchi
"Greg Larsen" wrote:
> At the DOS prompt enter "OSQL -L" The -L option show all the servers that
> are broadcasting on the network.
> "Rob" wrote:
> > Hi,
> >
> > Is there a way to find all available SQL Servers in a particular domain or
> > subnet?
> >
> > Thanks.
> >
> > - Rob.|||You can query the registry on your severs to get a definative answer the path
is:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
This will list all instances installed on your server.
Ray
"Linchi Shea" wrote:
> osql /L will most likely not give you all the SQL servers in a domain unless
> you have a tiny domain that has nothing routed and every machine is
> broadcasting--an unlikely scenario.
> The only reliable way I've found is to enumerate all the machines in a
> domain and systematically test each machine for the presence of SQL server
> instances.
> Linchi
> "Greg Larsen" wrote:
> > At the DOS prompt enter "OSQL -L" The -L option show all the servers that
> > are broadcasting on the network.
> >
> > "Rob" wrote:
> >
> > > Hi,
> > >
> > > Is there a way to find all available SQL Servers in a particular domain or
> > > subnet?
> > >
> > > Thanks.
> > >
> > > - Rob.