d95pari
Posts: 6
Joined: Fri Sep 09, 2011 9:21 am

Install SQL Server from installer

In my installer I would like to give the user the opportunity to install SQL Server Express. The user may choose to decline this (e.g. install later or use a network server) and therefore I cannot include the server in the prerequisites. The user click a button and the SQL Server installer is launched as a custom action (see this thread).

But the installation process does not work for me, when I run the installer separately it works fine (both with and without a configuration file) but when lunched from within the installer I receive the following error during the “Setup support files” process:

Code: Select all

TITLE: Microsoft SQL Server 2008 R2 Setup
------------------------------

The following error has occurred:

SQL Server Setup has encountered an error when running a Windows Installer file.

Windows Installer error message: The system cannot find the file specified.

Windows Installer file: c:\c716f16600ad91e20e141e175bfb12f1\1033_ENU_LP\x86\setup\sqlsupport_msi\SqlSupport.msi
Windows Installer log file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110920_164101\SqlSupport_Cpu32_1_ComponentUpdate.log

Click 'Retry' to retry the failed action, or click 'Cancel' to cancel this action and continue setup.
Does anyone know what the problem is? Has anyone been able to install SQL Server from an installer?
Last edited by d95pari on Wed Sep 21, 2011 7:17 am, edited 1 time in total.
Cosmin
Posts: 5797
Joined: Tue Jul 10, 2007 6:39 pm
Contact: Website

Re: Install SQL Server from installer

Hi,

Ideally all the SQL Server installations files should be added as temporary files. Then you can use a Launch file as Administrator UI Custom Action to launch its main setup file.

Can you please send us the .AIP (project) file you are using to support at advancedinstaller dot com so we can investigate it?

Regards,
Cosmin
Cosmin Pirvu - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube
d95pari
Posts: 6
Joined: Fri Sep 09, 2011 9:21 am

Re: Install SQL Server from installer

Hello,

Thank's for the reply. I have tried exactly that, i.e. launch the file as administrator using a UI custom action. I will send an email to the address you suggest and refer to this thread.

/d95pari
Cosmin
Posts: 5797
Joined: Tue Jul 10, 2007 6:39 pm
Contact: Website

Re: Install SQL Server from installer

Hi Patrick,

Your custom action is not configured correctly. It doesn't even use the temporary files you added in Files and Folders page, it uses an EXE attached to the MSI. Please try using a Launch file as Administrator custom action and let me know if the problem persists.

Regards,
Cosmin
Cosmin Pirvu - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube
marcoburi
Posts: 13
Joined: Wed Sep 21, 2011 8:37 pm

Re: Install SQL Server from installer

Hi Patrick.

I have found that setting the InstallLevel if the user declines and then adjust the Installation Behavior of the component (i.e. prerequisites) should od the job.

Good Luck

Return to “Common Problems”