Re: List availalbe SQL Servers?

Angus Robertson - Magenta Systems Ltd wrote:
In article <47e91ee9$1@xxxxxxxxxxxxxxxxxxxxxx>, jouni.aro@xxxxxxxxx (Jouni
Aro) wrote:

I would need to find out the available SQL Servers (mainly 2005, but possibly 2000 as well, and definitely with 2008 in future) to be able to create and connect to a new database using a selectable database instance.

Microsoft recently published lots of private communications protocols,
suggest you read:

[MC-SQLR]: SQL Server Resolution Protocol Specification

This document specifies the SQL Server Resolution Protocol, a Microsoft
proprietary protocol. The SQL Server Resolution Protocol is an
application-layer request/response protocol that facilitates connectivity
to a database server and provides for:
- Communication endpoint information; for example, the TCP port for
connecting to a particular instance of the database server on a machine.
- Database instance enumeration.

Essentially, you send a UDP packet to port 1434 and it replies with
information about SQL instances on that server.

Thanks Angus,

Looks like this could be used to retrieve the info, although not very easily (as I have already figured out with this issue in general). I did not quite get which versions of SQL Server support this, though...
.

Relevant Pages

  • Re: List availalbe SQL Servers?
    ... be able to create and connect to a new database using a selectable ... This document specifies the SQL Server Resolution Protocol, ... - Database instance enumeration. ...
    (borland.public.delphi.database.ado)
  • Re: MSDE Database move to a new Server - any SQL gurus out there?
    ... Which version of SQL server did you migrate the instance to? ... I have a client that has a MSDE 2000 database on their old server and want to move it to the new server. ... I created a database instance on the new server with the same database instance name as the old server. ...
    (microsoft.public.windows.server.sbs)
  • Re: Collation in SQL Server
    ... You can set the collation for a database only on SQL Server 2000, ... > rather that on the whole Database Instance. ...
    (microsoft.public.sqlserver.server)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)