BigDaveLamb
Posts: 5
Joined: Thu Mar 14, 2019 10:56 pm

SQL Server Browse or Install

Is it possible to use the SQL Server browse functionality and if the user does not select an existing SQL Server or no SQL Server found install SQL Server. Can you please tell me how this is done?
Catalin
Posts: 7845
Joined: Wed Jun 13, 2018 7:49 am

Re: SQL Server Browse or Install

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
Catalin Gheorghe - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube
BigDaveLamb
Posts: 5
Joined: Thu Mar 14, 2019 10:56 pm

Re: SQL Server Browse or Install

Hi Catalin

I did look at the prerequisites. However not sure it works for this.

1. Prerequisites mean it has to be installed on the machine the software is to be installed, there may be a SQL Server on the network that wish to use rather than a local SQL Server instance.

2. The prerequisites specifies a specific version of SQL Server I think, we support SQL Server 2005, so if I were to select in the SQL Server 2016 as prerequisite the user may have SQL2014 installed and wish to install our database on this.

3. Just because the user has SQL Server installed they may wish to install a new instance for our application.



Thanks.
BigDaveLamb
Posts: 5
Joined: Thu Mar 14, 2019 10:56 pm

Re: SQL Server Browse or Install

Don't worry I have this working now, I set SQL Server prerequisite up as a Feature and if the user does not select it I trigger a a browse SQL dialog for them to choose one on the network.

All good!

Thanks.
Catalin
Posts: 7845
Joined: Wed Jun 13, 2018 7:49 am

Re: SQL Server Browse or Install

You are always welcome, Dave.

I am glad you got this working.

Just let us know anytime you have a question.

All the best,
Catalin
Catalin Gheorghe - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube

Return to “Building Installers”