Local and network instances SQL servers in one Combobox

[mochalov]

Hello.
Tell me how to get in Combobox local and network instances of SQL Server?

[Eusebiu]

Hi,

In order to achieve this you can go in the "SQL Databases" page and add a new "SQL Browser Servers" operation. For more details you can read the "SQL Browse" article and watch the video it contains.

Also, it is recommended to use the "SQLServerConnectionDlg" dialog as shown in the "SQL Server built-in configurations" video.

Just let me know if you have other questions.

Best regards,
Eusebiu

[mochalov]

You understood me wrong.
The task - to display both local and network instances in the combobox.
In your examples show how to get or local or network, but not both at once.

[Eusebiu]

Hi,

If you choose the "Network SQL Browse" option, all the instances from the network will be displayed, including those from your local machine which is part of that network.

If any of your local instances is missing when you perform a browse for network instances, it may happen if one of the points mentioned in the "Why doesn't SQL Browse work as expected" FAQ applies to you.

Best regards,
Eusebiu