Steve.Hipwell
Posts: 9
Joined: Tue Feb 12, 2013 4:14 pm

Re: Installing SQL 2012 Based On A Feature

This really isn't going well is it!?

I asked for a solution and was told to do exactly what I'd explained didn't work!

Then I was told that the software couldn't do what I wanted.

Once I started talking about a refund then I was told that there was a way after all to make it work. However your examples didn't work and obviously hadn't been tested as even after three attempts by yourselves the installer wouldn't even start.

Finally by a long process of trial and error I managed to get the installer to start only to find out that what you had told me about this being a solution was untested and did not work at all.

So far I have been shocked at the standard of you customer support and your lack of knowledge of your own software! I've wasted many hours looking into this problem, most of them at the suggestion that you had a tested solution, which wasn't tested or even a solution. I expect a resolution ASAP!
Daniel
Posts: 8283
Joined: Mon Apr 02, 2012 1:11 pm
Contact: Website

Re: Installing SQL 2012 Based On A Feature

Hello,

I've tested the latest approach (extract files from SQL Server installer, add them in "Files and Folders" page and launch the setup.exe file using a custom action) using the 32-bit and 64-bit version of Microsoft SQL Server 2012 Express on the following test machines: Vindows Vista SP2 x64, Windows 7 SP1 x86 and Windows 8 x64, and SQL Server installed successfully. Can you please try the related approach and see if the behavior still persist? If so, can you please send us the .aip (project file) to support at advancedinstaller dot com so we can investigate it?

All the best,
Daniel
Daniel Radu - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube
tdartt
Posts: 2
Joined: Wed Dec 04, 2013 6:18 am

Re: Installing SQL 2012/prerequisite based on a Feature

I'm looking to do this as well. Thanks for for your admirable patience with us users in trying to help us resolve this issue :)
Daniel
Posts: 8283
Joined: Mon Apr 02, 2012 1:11 pm
Contact: Website

Re: Installing SQL 2012/prerequisite based on a Feature

You're welcome. Thank you for your positive words.

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 2012/prerequisite based on a Feature

Hi
I have been searching the forum, help and documentation on installing SQL express named instance as part of an application, with very little success. I am evaluating this software as a possible substitute for our current solution. Initially I was quite impressed but as I drilled into the specifics of actually building the solution we require, I am getting somewhat disappointed. I would have thought at this present time installing SQL Express as part of a solution would be so common and straight forward that its just click and go.

What is the status of this thread as the outcome may determine weather we purchase or not. Anyone?
Daniel
Posts: 8283
Joined: Mon Apr 02, 2012 1:11 pm
Contact: Website

Re: Installing SQL 2012/prerequisite based on a Feature

Hello and welcome to Advanced Installer forums,

Thank you for your interest in Advanced Installer.

In order to install a named instance of the SQL Server Express, then you can add it as a prerequisite and in the "Install Command Lines" fields from "Prerequisites Setup Files" tab use a command line like this.

Code: Select all

/q /IACCEPTSQLSERVERLICENSETERMS /ACTION=Install /FEATURES=SQLEngine /INSTANCENAME=<your instance name>/UpdateEnabled=False
However, if you want the instance name to be chosen by the user at install time (e.g. by adding the prerequisite as feature-based and using a formatted property reference), then I'm afraid this is not possible by using our prerequisites support. Please take a look on our "Why the SQL Server installation hangs?" faq. As a workaround you can try to install SQL Server Express using a Custom Action.

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 2012/prerequisite based on a Feature

Hi Daniel,

Thank you for your post.

I have read through your reply and can see the workaround in this method, however we distribute supplied content, populated SQL databases that need to be installed to the user selected "/INSTALLSQLDATADIR" with our application. So "User selected" named instances of SQL express need to be installed first, with the "User selected" option of where they want the SQL Databases installed. Then based on the SQL variables, install the application files to the respective locations.

Another point is that the MS SQL Express 2014 redistributable has different behavior to its predecessors and needs to be dealt with differently. How do you handle MS SQL Express 2014?
Daniel
Posts: 8283
Joined: Mon Apr 02, 2012 1:11 pm
Contact: Website

Re: Installing SQL 2012/prerequisite based on a Feature

Hello,
I have read through your reply and can see the workaround in this method, however we distribute supplied content, populated SQL databases that need to be installed to the user selected "/INSTALLSQLDATADIR" with our application. So "User selected" named instances of SQL express need to be installed first, with the "User selected" option of where they want the SQL Databases installed. Then based on the SQL variables, install the application files to the respective locations.
I'm afraid this is not possible. This could be accomplished only by adding the SQL Server prerequisite as feature-based, but this won't work (the SQL installation will hang) due to the SQL Server setup issue.
Another point is that the MS SQL Express 2014 redistributable has different behavior to its predecessors and needs to be dealt with differently. How do you handle MS SQL Express 2014?
The SQL Server Express 2014 prerequisite should be also added only as a pre-install prerequisite, otherwise will manifest the same issue (will hang during install).

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

Return to “Common Problems”