Get all MS SQL Instances, but only on local machine

Got a problem you cannot solve? Try here.
Post Reply
StyX
Posts: 51
Joined: Fri Apr 11, 2008 7:14 am
Location: Stavanger, Norway
Contact:

Get all MS SQL Instances, but only on local machine

Post by StyX »

Is there a way to get the instancename of all available MS SQL Instances on the local machine that the setup is running.

I know it's possible to detect all MS SQL Instances running on the network, but choosing a remote MS SQL Instance would in my case break the install.

I've tried parsing the output based on Server name from the standard Detect MS SQL Instances plug-in but I just can't seem to get it right :-/

Any ideas?
neillans
Posts: 536
Joined: Sat Nov 04, 2006 6:21 am
Location: Scottish Borders, UK

Post by neillans »

The best way is to parse the list and filter on the machine name.

However, you could query the registry -- I believe there is an entry that lists the instance names.
Andy Neillans
Post Reply