theVman
Posts: 13
Joined: Wed Nov 05, 2014 8:02 am

SQL Express 2016 support

Hi

When do you plan to have builtin prerequisite support for SQL Express 2016?
What method or alternative do you recommend to use for version 13.1?
SQL Express 2014 had a direct link to the Microsoft file when you selected the URL option, however Microsoft SQL Express 2016 direct download is no longer supported, what method or alternative do you recommend?

regards
V
Dan
Posts: 4530
Joined: Wed Apr 24, 2013 3:51 pm

Re: SQL Express 2016 support

Hello,

The prerequisite for "SQL Server Express 2016" will be available in the next version of Advanced Installer that will be released these days. I will update this thread as soon as the next version of Advanced Installer will be released.

Until then, you can download the SQL Server 2016 from the SQL Server 2016 Express edition.

Also, I've attached the fragment that includes the SQL Server 2016 Express edition.

Unzip it and copy the folder in the /Fragments folder from the installation path of Advanced Installer e.g. default one is:

Code: Select all

C:\Program Files (x86)\Caphyon\Advanced Installer 13.1\fragments\prerequisites
Let me know if you have any questions.

Best regards,
Dan
Attachments
MSSQL Express 2016 (web).zip
(1.07 KiB) Downloaded 667 times
Dan Ghiorghita - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube
theVman
Posts: 13
Joined: Wed Nov 05, 2014 8:02 am

Re: SQL Express 2016 support

Thank you, much appreciated.

regards
V
Dan
Posts: 4530
Joined: Wed Apr 24, 2013 3:51 pm

Re: SQL Express 2016 support

You're welcome,

If there is anything else I can help you with, please let me know.

Best regards,
Dan
Dan Ghiorghita - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube
Dan
Posts: 4530
Joined: Wed Apr 24, 2013 3:51 pm

Re: SQL Express 2016 support

Hello,

The predefined prerequisite for "SQL Server Express 2016" has been added in version 13.2 of Advanced Installer released on October 6th, 2016.

Best regards,
Dan
Dan Ghiorghita - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube
h.k.foysol
Posts: 17
Joined: Thu Oct 13, 2016 10:34 am
Contact: Skype

Re: SQL Express 2016 support

Dan,

Do you happen to know how can I install SQL Express 2016 silently using the web installer when I have the SQL Express as pre-requisite in pre-install? It looks like the web installer takes following arguments

Code: Select all

SQLServer2016-SSEI-Expr.exe [/ConfigurationFile=C:\Configuration.ini] [/IAcceptSqlServerLicenseTerms] [/MediaPath=C:\SqlServer2016Setup]
The problem is I will have to supply the Configuration.ini file with my installer and the file does not gets copied unless the main installation process gets started. Any idea how I can deal with this?

Thank you
Humayun Kabir Foysol
Team Lead
Enosis Solutions
http://www.enosisbd.com
Daniel
Posts: 8283
Joined: Mon Apr 02, 2012 1:11 pm
Contact: Website

Re: SQL Express 2016 support

Hello Humayun,

If your prerequisite is added as a file from disk (using the "Use file from disk" option from "Prerequisites Setup File Tab"), then you can try to add the config.ini file under the "Additional Files" section. Thus at install time the ini file will be extracted next to the web installer setup of your prerequisite.

Let us know if this helped.

All the best,
Daniel
Daniel Radu - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube
h.k.foysol
Posts: 17
Joined: Thu Oct 13, 2016 10:34 am
Contact: Skype

Re: SQL Express 2016 support

No, it is not added as file from disk. Getting downloaded from web.
Humayun Kabir Foysol
Team Lead
Enosis Solutions
http://www.enosisbd.com
Daniel
Posts: 8283
Joined: Mon Apr 02, 2012 1:11 pm
Contact: Website

Re: SQL Express 2016 support

Hello Humayun,

I'm afraid the only solution would be to add the prerequisite file as a file from disk (i.e. embedded into your main setup package). For web-based prerequisites we do not have support to include additional packages to be deployed alongside the downloaded prerequisite setup.

Thank you for your understanding.

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: SQL Express 2016 support

Hi

I have found some issues installing "Microsoft SQL Server 2016 Express SP1" as a pre-install.

I have used the sample provided project to look at the mechanism but its not helping in this case as it is sql 2014 x86 installed as a feature.

Is there an update or solution to this issue that can be supplied to this thread please? It may help me trouble shoot my issue.

I have found that the "Install Command Lines" do not accept [variables] %variables% like [TempFolder] and %temp%. Hence the above [SETUPEXEDIR] in the "Install Command Lines" may not resolve for the location of the 'SQLSETUP.INI', which may or may not be related to the error posted.

BUG - Chicken or egg?
Futher to this, using default paths, the SQL Express 2016 'Pre-install' package is copied to the systems [TempFolder], likewise for any 'Additional files' like SQLSETUP.ini. Now these files get copied first before the SQL Express 2016 is invoked. You would think this is simple and straight foward, however the MS SQL Express 2016 pagkage extracts its files to [TempFolder]\SQLEXPR_x64_ENU. So the setup.exe in looking for the SQLSETUP.ini file in [TempFolder]\SQLEXPR_x64_ENU, buts it not there as it was copied by AI to [TempFolder]. SQL Express 2016 fails.
So the obvious solution may be to simply set the 'Additional files' to "SQLEXPR_x64_ENU\SQLSETUP.ini", NOPE, because it creates the folder and installs the file before the MS SQL Express 2016 is invoked and MS will no longer extract to that folder as it already exists. So it defaults to use an random created folder name on C:\9b7e5cbc1b59ad010d377144 and fails as it cant find the SQLSETUP.ini file relative to where its run from.

So what is the work around to get AI to either:
1. in the 'Additional files' section to invoke the SQL setup.exe with the appended folder name [TempFolder]\SQLEXPR_x64_ENU\SQLSETUP.ini
2. variables %variables% and [TempFolder]\SQLEXPR_x64_ENU to be resolved on the commandline
3. copy the 'Additional files' SQLSETUP.ini after invoking the SQL Express 2016 extraction so the [TempFolder]\SQLEXPR_x64_ENU already exists
4. Change the execution sequencing in the 'Pre-install' so it runs the SQL Server 2016 Express to extract the files, THEN does the 'Additional files' copy THEN bootstraps the \SQLEXPR_x64_ENU\setup.exe with the 'install command lines'.
5. other?

Further testing proves this to be the case:
While the installation was in progress, as soon as I saw the MS SQL Express 2016 create its default "SQLEXPR_x64_ENU" under %temp%, I manually copyed the 'SQLSETUP.ini' to it from %temp% and it installed successfully.


regards
V
Eusebiu
Posts: 4971
Joined: Wed Nov 14, 2012 2:04 pm

Re: SQL Express 2016 support

Hi,

Please see my response on the "Fatal Error when installing MS SQL Express as prerequisite" thread.

Best regards,
Eusebiu
Eusebiu Aria - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube

Return to “Common Problems”