Page 1 of 1

Get all MS SQL Instances, but only on local machine

Posted: Mon Oct 26, 2009 7:27 am
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?

Posted: Wed Oct 28, 2009 3:29 pm
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.