[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 206
  • Last Modified:

Retrieving all SQL Server instances on machine

Is there a way to retrieve all SQL Server instances that are running on a machine?
I know you can use the System.Diagnostics library but I dont quite know how to do it.

Thanks.
0
smacca
Asked:
smacca
  • 3
  • 2
4 Solutions
 
Éric MoreauSenior .Net ConsultantCommented:
There is a combo that lists all available servers from the network at http://www.csharphelp.com/archives2/archive345.html
0
 
Chester_M_RagelCommented:
I don't know whether you can use System.Diagnostics to do that. Here is a similar question. Check this.

http://www.experts-exchange.com/Programming/Programming_Languages/Dot_Net/Q_20934019.html
0
 
Chester_M_RagelCommented:
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
Chester_M_RagelCommented:
I think this one can do the trick for you...

http://www.csharphelp.com/archives2/archive342.html
0
 
smaccaAuthor Commented:
Is there any other way without using the SQLDMO object or ODBC to get the list of SQL Servers?
I will award points regardless but really interested to know - some of the articles mention that the interfaces with SQLDMO are very old.

Can you use the OleDBSchema to get them??
0
 
Éric MoreauSenior .Net ConsultantCommented:
>>Is there any other way without using the SQLDMO

I never saw any way.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now