RE: How to find available SQL Server on local network

I am getting the following error when i run it on WIN2K

QueryInterface for interface SQLDMO.NameList failed???

"Jakob Christensen" wrote:

> You can do this using SQL-DMO. Add a reference to sqldmo.dll and sqldmo.rll
> to use SQL-DMO. The Application object of SQL-DMO has a ListAvailableServers
> method which will give you all SQL Servers on the network (if you are running
> Windows 2000 and up).
>
> You can also connect to an SQL Server instance and enumerate all objects for
> that server (using the SqlServer object).
>
> Links:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;287737
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmoref_con03_8q44.asp
>
> Of course, the code will be a bit different in VB.net.
>
> HTH, Jakob.
>
>
>
> "Job Lot" wrote:
>
> > Using VB.NET how can I find all available SQL Server on a local network and
> > list all the databases in each server.
> >
> > Thanks
.

Relevant Pages

  • Re: backupRestore progress bar
    ... SQL-DMO is an acronym for SQL Distributed Management Object and is a full ... object model to manage and administer SQL Server.. ...
    (microsoft.public.sqlserver.msde)
  • Re: Problem Executing Stored Procedures
    ... Both SQL Server and Agent are running under the Local System account so they ... should have enough privileges. ... The same application that is having problems with SQL-DMO also uses SQL-DMO ... and both procedures you are mentioning are run with success... ...
    (microsoft.public.sqlserver.msde)
  • RE: How to find available SQL Server on local network
    ... You can do this using SQL-DMO. ... The Application object of SQL-DMO has a ListAvailableServers ... You can also connect to an SQL Server instance and enumerate all objects for ... > Using VB.NET how can I find all available SQL Server on a local network and ...
    (microsoft.public.dotnet.general)
  • Re: "Best Practices" way to distribute MSDE
    ... if SQL-DMO is locally present) and try a connection to the server... ... if you can't connect with that login, ... object privileges... ... Andrea Montanari (Microsoft MVP - SQL Server) ...
    (microsoft.public.sqlserver.msde)
  • RE: How to find available SQL Server on local network
    ... Doesn't it show instances installed on local machine? ... > You can do this using SQL-DMO. ... > You can also connect to an SQL Server instance and enumerate all objects for ... >> Using VB.NET how can I find all available SQL Server on a local network and ...
    (microsoft.public.dotnet.general)