Hello Dave and welcome to our forums,
First of all, thank you for trying out Advanced Installer.
In what regards your question, I think that you may find useful using our support for "Prerequisites". The check of whether the SQL Server is installed or not on the target machine will be done automatically (because we have a list of predefined prerequisites, already configured, from which you can choose).
In order to add SQL Server as a prerequisite, all you have to do is to go to
"Prerequisites" page --> click on
"Packages" and select the version of SQL Server you want installed on your user's machines.
Also, please have a look on the following articles which I think you may find useful:
Add Prerequisites section from Professional Package tutorial
Prerequisites Page
Hope this helps.
All the best,
Catalin
FOLLOW US
Get the latest news in Application Packaging