Slim57
Posts: 9
Joined: Fri Sep 12, 2014 10:23 pm

batch that calls sql server installer fails when launched

from AI. The batch runs very nicely when called from the command line, it tests for connection to a SQLServer named instance and if not successful, runs command line call to sql server install.

When running batch from custom action launch file, the test for connection does not find instance, then attempts sqlserver install. The sqlserver install extracts sqlserver install folder structure, then fails in various different ways: at times it will simply hang, other times it will exit silently without finishing.

I seem to recall that installers may call setup.exe type installers, but not .msi type installers. This sort of feels like that's what's happening here.
Eusebiu
Posts: 4964
Joined: Wed Nov 14, 2012 2:04 pm

Re: batch that calls sql server installer fails when launche

Hi,

This may happen if the installation of the SQL Server starts while the main package that launch the batch file is still running. Please keep in mind that two MSI-based installers cannot run at the same time.

Also, there is a well known limitation about the SQL Server installers which cannot run while the "msiexec.exe" process is running. You can find more details about this and also a solution on the "How to install SQL Server Express with your application" article.

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

Return to “Common Problems”