Re: List availalbe SQL Servers?

Vitali Kalinin wrote:
I meant replace:
ProgIDToClassID('SQLOLEDB Enumerator')
with
ProgIDToClassID('SQLNCLI Enumerator').

OK, now I got it - and yes that makes it return the exact list I was looking for (all local and available servers from the network)!

Do you have any links to other examples related to browsing the DB information, in case I would like to find out which versions the servers are and such? The docs at MSDN do not reveal anything very easily...

Also have you checked that MS SQL Server Management Studio can list yours 2005 Server instance from remote computer without manual registration.

I did not check, but in principle, I will need to find out which servers are available to be used. Local ones have more priority as they can also be used to create new databases - and for that especially, I need to know which server to use.

Thanks a lot,

Jouni Aro
Prosys
.

Relevant Pages

  • Re: Dcidag errors
    ... Port blockage between servers ... Other sorts of networking issues (lack of connectivity between the points ... These errors are typically a result of a network connectivity issue of some ... > replicating this nc. ...
    (microsoft.public.windows.server.active_directory)
  • Re: I need Job Blobb
    ... > Windows and Network administratation. ... > In a job I would like to administrate servers, ... > Title: ISP Network Administrator ... > o Building, installation, configuration and tuning ...
    (microsoft.public.cert.exam.mcse)
  • Re: I need Job Blobb
    ... > Windows and Network administratation. ... > In a job I would like to administrate servers, ... > Title: ISP Network Administrator ... > o Building, installation, configuration and tuning ...
    (microsoft.public.cert.exam.mcse)
  • Event Viewer Networking Connectivity
    ... What we need is a very solid working network. ... Here's what lead up to this scenario of BDC replacement. ... On the corporate side I can see our servers. ... Registration of the DNS record ...
    (microsoft.public.windows.server.networking)
  • Help with initial small org AD setup convention when using DMZ network
    ... firewall which then connects the public IP dmz network to a private IP ... domain name for such subnets based on the nearest airport code, ... Yahoo to manage my externally-visible DNS names on the acme.com domain. ... and servers that use this domain, ...
    (microsoft.public.win2000.active_directory)