Re: List availalbe SQL Servers?

Chris.Cheney wrote:
Jouni Aro <jouni.aro@xxxxxxxxx> wrote in
news:47e91ee9$1@xxxxxxxxxxxxxxxxxxxxxx:

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.

I tried to search for some hints, but mostly get only .NET stuff.

I found a reference to SQLDMO (http://www.delphi3000.com/articles/article_4052.asp?SK=), but it
seems that support for that is about to be dropped, so I would prefer
to use something that will also work with 2008 and later.

Also the code in the link seems to list servers only and does not find
all available instances.

Any ideas?

BR,

Jouni Aro
Prosys

1. Obsolescent SQL DMO: the ListAvailableSQLServers method of the Aplication object gives network-visible INSTANCES (http://msdn2.microsoft.com/en-us/library/aa238042(SQL.80).aspx).

Yes, I also figured that it's fading away...

2. Current SQL SMO: the EnumAvailableServers method of the .NET SmoApplication class enumerates a list of available INSTANCES of Microsoft SQL Server (http://msdn2.microsoft.com/en-
us/library/microsoft.sqlserver.management.smo.smoapplication.enumavailables
qlservers.aspx).

I am still a novice with .NET - how do you access that from Delphi win32?

"Available" instances is a misnomer - although an instance may be available for making a connection to (if you know its server and instance names), it might not be visible to List/EnumAvailableSQLServers, one reason being that network connections for the instance are disabled.

Should SQLEXPRESS be included in the list from SMO (see my response to Vitali for my server configuration)?
.

Relevant Pages

  • Re: Compromised Server? Anyone recognize the suspect Services?
    ... I would be surprised if default local security policy was wide open. ... We lease a non-managed Web Server running AV software but no IDS. ... right under Network Connections there were 3 other ... to quickly set up VPN access using only a remote connection...such that I ...
    (microsoft.public.windows.server.networking)
  • Re: Compromised Server? Anyone recognize the suspect Services?
    ... Maybe I will create 2 Login Accounts with Admin/RDP priviledges, ... We lease a non-managed Web Server running AV software but no IDS. ... right under Network Connections there were 3 other ... to quickly set up VPN access using only a remote connection...such that I ...
    (microsoft.public.windows.server.networking)
  • Re: Compromised Server? Anyone recognize the suspect Services?
    ... there are a bunch of logins for Website Accounts created by the ... The login accounts are for web sites that are on the ... order to find those files on the Web Server I had to make sure that System ... right under Network Connections there were 3 ...
    (microsoft.public.windows.server.networking)
  • Re: Burn a CD from XP that VMS will mount/read?
    ... This server has no network connections and ... from HP but how can I get the patch to the VMS server? ... VAXman- A Bored Certified VMS Kernel Mode Hacker   ... At least I have a security trail back to a person at a company. ...
    (comp.os.vms)
  • Re: Netman service hanging on startup PLS HELP!! ASAP
    ... tied into 'network connections' service) - even to the extent that any ... service accounts that log onto the server (ok its been tested with an IIS ... > transaction response from the Netman service. ... > to the start or control request in a timely fashion. ...
    (microsoft.public.win2000.general)