Re: List availalbe SQL Servers?

Chris.Cheney wrote:
"Chris.Cheney" <Chris.CheneyXXNOSPAMXX@xxxxxxxxx> wrote in
news:Xns9A6D8C70DA2D6ChrisCheneytesconet@xxxxxxxxxxxxx:

FWIW I have run that code on a computer where there is a default
instance of SQL Server 2000 and a (network-disabled) named instance of
SQL 2005 Express, and it only finds the SQL Server 2000 instance,
whereas SQL Service Manager finds both.

SQLPing3 (http://www.sqlsecurity.com/Tools/FreeTools/tabid/65/Default.aspx) found all (AFAICT) instances on my computer.

Thanks for the link, it might become handy as well some time.


.

Relevant Pages

  • change a named instance to default instance
    ... Produced By Microsoft MimeOLE V6.00.2800.1441 ... even though there is only one SQL Server ... | Is there anyway I can make my named instance behave like the default? ... Configure an Alias by Using TCP/IP Sockets ...
    (microsoft.public.sqlserver.connect)
  • Re: What is the server name for a standalone XP SP2?
    ... How should one uninstall a Named instance in a clean fashion? ... Configuration Manager of SQL Server 2005. ... I checked the menus in the Configuration Manager and connot figure out how ... You can uninstall Named and Default instances if you do not need them. ...
    (microsoft.public.sqlserver.setup)
  • Re: x64 2003 Cluster - SQL2000 named instance fail
    ... one the settings are not detected by the setup. ... > in the cluster log you will notice the a connection to the SQL Server ... > named instance cannot be established. ... >> Microsoft highly recommends that users with Internet access update their ...
    (microsoft.public.sqlserver.clustering)
  • RE: Cluster Configurations
    ... MCTS: SQL Server 2005 ... "Mohit K. Gupta" wrote: ... Named Instance -> Failover to Node 4 ...
    (microsoft.public.sqlserver.clustering)
  • Re: Cannot connect to second cluster node w/instance name
    ... Is the SQL Server Browser Service running to provide the tcp port number for the named instance? ... When I attempt to connect to node2 remotely I get an error basically stating "An error has occurred while establishing a connection to the server. ... When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. ...
    (microsoft.public.sqlserver.connect)