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,
Then we have the function to only show these instead,