Codename K
Posts: 402
Joined: Fri Jan 29, 2010 3:04 pm

Combo box populating wrong SQL Server instances?

Fri Jun 04, 2021 6:03 pm

Hello,

In SQL Databases section you can add in the SQL Server Browse to populate SQL Server instances to a combo box. This works fine. But in one computer, it also populates the term "(local)" and that is the first item selected in combo box. Because of this reason, when you go to the SQLServerConnectionDlg it shows an error message. How to fix this?

Also in combo box with SQL Server instances populated, how to make it always show specific server name?

:?:
K

Catalin
Posts: 4229
Joined: Wed Jun 13, 2018 7:49 am

Re: Combo box populating wrong SQL Server instances?

Mon Jun 07, 2021 7:15 pm

Hello K,

I am not quite sure I understand what the issue is here.

The output of the server query should look something as it follows:

LOCATION\INSTANCE_NAME

in your case, (local) meaning that the instance name is on the local machine. It shows the same output on my machine as well (I only have one SQL Server Instance):
local.png
local.png (80.94 KiB) Viewed 2443 times
Because of this reason, when you go to the SQLServerConnectionDlg it shows an error message
Could you please give me some more details about this? What is the encountered error?

Best regards,
Catalin
Catalin Gheorghe - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube

Return to “Common Problems”