deenairn
Posts: 6
Joined: Tue May 10, 2016 2:12 pm

Installing SQL Server prerequisite via download and .ini config file

Hello,

I'm trying to use a Configuration.ini file in an installation of SQL Server Express which is downloaded from an external URL. However, there is no option for additional files for this option. Is there any way to work around this?

Thanks,

Donald
Daniel
Posts: 8283
Joined: Mon Apr 02, 2012 1:11 pm
Contact: Website

Re: Installing SQL Server prerequisite via download and .ini config file

Hello Donald,

Welcome to our forums!

I'm afraid we don't have additional file support for URL-based prerequisites. This improvement is already on our TODO list and hopefully it will be available in the future. We will notify you when it will be out.

Until then, as a workaround you can use our "Install Command Lines" fields to pass installation parameters to the SQL Server setup.

All the best,
Daniel
Daniel Radu - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube
deenairn
Posts: 6
Joined: Tue May 10, 2016 2:12 pm

Re: Installing SQL Server prerequisite via download and .ini config file

Hello Daniel,

Thanks for the feedback - I'll keep a lookout for this feature in future. Do you have a feature request we could use to track this?

Thanks again,

Donald
Daniel
Posts: 8283
Joined: Mon Apr 02, 2012 1:11 pm
Contact: Website

Re: Installing SQL Server prerequisite via download and .ini config file

Hello Donald,

We don't have a public platform where you can track the progress of the requested features, but as soon as this improvement will be available we'll update you on this thread.

All the best,
Daniel
Daniel Radu - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube
theVman
Posts: 13
Joined: Wed Nov 05, 2014 8:02 am

Re: Installing SQL Server prerequisite via download and .ini config file

Hi

How is this feature going? I also need to do a similar task. I am evaluating the latest version 13.1 build 71115 now.
What folder does the downloaded SQL Express install file get placed into so I can install my custom config.ini to that location and pass the path to it in the SQL Express command line field in AI?
Dan
Posts: 4530
Joined: Wed Apr 24, 2013 3:51 pm

Re: Installing SQL Server prerequisite via download and .ini config file

Hello,
I am evaluating the latest version 13.1 build 71115 now.
Thank you for your interest in Advanced Installer.
What folder does the downloaded SQL Express install file get placed into
In the Download/extraction folder field from the Predefined Prerequisites tab you can specify the default download or extract folder for prerequisite files. e.g. the default one is:

Code: Select all

[AppDataFolder][|Manufacturer]\[|ProductName]\prerequisites
[...]I can install my custom config.ini to that location and pass the path to it in the SQL Express command line field in AI
You can use the following command line to pass the config file to the SQL prerequisite:

Code: Select all

/ConfigurationFile="[AppDataFolder][Manufacturer]\[ProductName]\prerequisites\SQL Server Express 2012 SP2\ConfigurationFile.ini"
as you can see below:
Prereq - Install Command Line section.png
Prereq - Install Command Line section.png (9.48 KiB) Viewed 16420 times
Please let me know if you need any help.

Best regards,
Dan
Dan Ghiorghita - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube
theVman
Posts: 13
Joined: Wed Nov 05, 2014 8:02 am

Re: Installing SQL Server prerequisite via download and .ini config file

Thank you, much appreciated.

regards
V
artasom
Posts: 5
Joined: Wed Apr 26, 2017 2:32 pm

Re: Installing SQL Server prerequisite via download and .ini config file

Hello,

I reached this post because I was looking for an option of installing the SQL server express 2014 with a configuration file. I tried following the advice posted by Dan,
CommandLine.png
CommandLine.png (7.97 KiB) Viewed 15748 times
But when launching the installer, I get the following error
ErrorSqlServer.png
ErrorSqlServer.png (13.59 KiB) Viewed 15748 times
So, it seems the installer is not resolving the variables. I have tried adding a pipe to the variable, but the pseudo formatted type did not work either.

Any idea why this may be happening?

Best regards,
Miguel A.
artasom
Posts: 5
Joined: Wed Apr 26, 2017 2:32 pm

Re: Installing SQL Server prerequisite via download and .ini config file

Hello,

An update on the issue. So, reading further documentation at http://www.advancedinstaller.com/user-g ... files.html, in the section Install Command Lines, it can be read that:
This field supports Formatted type only if the prerequisite is feature-based.
.

I am trying now to create the installer with the SQL server pre-requisite as featured-based and not as pre-install package. I will update the post to let know whether I am successful or not.

All the best,
Miguel A.
artasom
Posts: 5
Joined: Wed Apr 26, 2017 2:32 pm

Re: Installing SQL Server prerequisite via download and .ini config file

Hello,

I was capable of creating the installer. I needed to add the SkipInstallerRunCheck parameter to the Command Line setting as stated in http://www.advancedinstaller.com/user-g ... uestion108. May I suggest that this information should be included in http://www.advancedinstaller.com/user-g ... press.html?

All the best,
Miguel A.
Daniel
Posts: 8283
Joined: Mon Apr 02, 2012 1:11 pm
Contact: Website

Re: Installing SQL Server prerequisite via download and .ini config file

Hello Miguel,

Thank you for your feedback. We will certainly update the latter article with a note about the "SkipInstallerRunCheck " flag which could be used as a workaround for a feature-based prerequisite. Thank you for your suggestion.

All the best,
Daniel
Daniel Radu - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube

Return to “Common Problems”