SQL Express 2012 Install Error

[mark2015]

I am trying to install SQL Server Express 2012 in my install package. I can manually run the setup using the command switches I need to use, however when I run the same setup media from within the installer I receive an error when it executes. I have attached the error message received. I am not using a file bag for the media,it is just extracted and included on my install media. I have tried using both the "Run Program" and "Run Program As" but both have the same result. I created a new project and have the same issue. Anyone else have this issue?

[FrancescoT]

Dear Mark,

how did you include the "SQL Server Express 2012" RTM with your setup?

did you use SUPPORTDIR location at such purpose?

Why did you not use the "SQL Server Express 2012" application Runtime that comes with IA?

Regards

[mark2015]

I am installing the version with Tools (Management Studio). We are trying to keep the actual installation executable smaller by not using the filebag, which explodes the size of the actual installer executable. There are 4 version of SQL Express used in our installer: SQL Express 2008 R2 x86, SQL Express 2008 R2 x64, SQL Express 2012 x86, SQL Express 2012 x64. This ends up being about 5 GB because these are the versions with Tools.

I have placed the extracted SQL installers in a prerequisite folder and am using $SFXPATH$ to call the installer. It runs the installer, but currently fails. These are the command switches I am using with 2012:

/QUIET
/ACTION=Install
/IACCEPTSQLSERVERLICENSETERMS
/SECURITYMODE=SQL
/SAPWD="SQLP@55w0rd"
/INSTANCENAME="Custom"
/FEATURES=SQLEngine,SSMS,ADV_SSMS
/SQLSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE"
/ADDCURRENTUSERASSQLADMIN="True"
/BROWSERSVCSTARTUPTYPE="Automatic"
/SQLCOLLATION="SQL_Latin1_General_CP1_CI_AS"
/SQLSVCACCOUNT="NT AUTHORITY\NetworkService"
/SQLSVCSTARTUPTYPE="Automatic"
/TCPENABLED=1
/NPENABLED=1
/UPDATEENABLED="False"

I am also trying to run this on machines that may not have internet access, so all the pre-requisites would have to install without access to the internet (such as .Net 3.5) I have also created a project that uses the included SQL Express 2012 with the filebag and it is failing in this respect because even though all of the pre-requisites are included it is trying to access the web.

[FrancescoT]

Dear Mark,

For what concerns the error that you reported with your first post, this seems to me caused by an improper parameter switch passed to the run program command. With your last reply you listed those you intend to use, but not how these are then effectively passed as command line parameters with the run program command.

It also not so clear to me how did you test the "SQL Express 2012" RTM package included with IA, which are exactly the pre-requisites it tries to access from the web?

Please note that by default when you use any of the a "MS SQL Express" RTM packages included with InstallAware, the MS SQL command line parameters are defined with a script variable within the relative "SetupSqlxxxx_xx" script.

For example;

In case you include the "Microsoft SQL Server Express 2014 sp1 (x86 and x64 WOW)" RTM package into your project, the MS SQL command line parameters are defined with the "MSSQL2014_COMMAND_LINE_X86" variable within the "setupsql2014sp1_x86" script.

That said, if you need to pass different switch parameters to the MS SQL installer, it is just necessary to modify the default switch parameters defined with the "MSSQL2014_COMMAND_LINE_X86" variable as you need.

For what I know, the "UPDATEENABLED" switch is not used with the default command line parameter that are passed to any of the MS SQL installer that comes with IA. Maybe it could be this the cause of the un-wanted web access attempt. (?)

Finally, you may also consider to include the RTMs you need as Web Media Blocks. Despite of their name, the WEB MEDIA BLOCK can be also distributed with your setup media. If these are available within the same folder of the setup.exe, the install process will use those available in the EXE folder instead to download them. Of course in this case, it will be necessary to build your package as Compressed WEB EXE.

Hope this helps you.

Regards