Hello,
I am sorry for the very late reply. But here is the issue,
I am assuming when you install
SQL Server 2019 Developer while
SQL Server 2017 Express, or install with the SQL instance name "MSSQLSERVER", and then you populate the SQL instances it also populates the term "(local)" and that is the first item selected in combo box. However, this may confuse the end-users.
What I required was to only populate the SQL instances listed in this registry key,
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL
This can be achieved by selecting
Local SQL Browser from
Browser type. However, this also populate just "(local)". So in order to prevent it from populating this, I created a VBScript in custom action to read the registry entries of the registry key above and populate using the
Populate combo box custom action to another combo box.
So is there a function in Advanced Installer to populate the SQL instances using
SQL Server Browse and discard certain values?
For example: if the SQL list contained these,
(local)
(local)\SQLEXPRESS1
(local)\SQLEXPRESS2
(local)\SQLEXPRESS3
Then we have the function to only show these instead,
(local)\SQLEXPRESS1
(local)\SQLEXPRESS2