locked
SQL Server 2014 Express extract file parameter? RRS feed

  • Question

  • I am working to bundle SQL Server 2014 Express with an application.  I am using the following command line to install via an InstallShield prerequisite:  /qs /INSTANCENAME=MYINSTANCE /ACTION="Install" /FEATURES=SQLEngine,Conn,SSMS /SECURITYMODE=SQL /SAPWD="Password" /TCPENABLED=1 /SQLSVCACCOUNT="NT AUTHORITY\SYSTEM" /IACCEPTSQLSERVERLICENSETERMS

    The installer I am using is SQLEXPRWT_x86_ENU.exe.

    When the installer starts up their is a dialog named:  Choose Directory for Extract Files.  In earlier versions of SQL Server Express this dialog did not require the user to press Ok to continue.  Since it takes several minutes to install SQL Server Express I prefer to show the installation to the user, so they can see that something is taking place.  The /q (Quiet) parameter will suppress this dialog, but nothing is seen for several minutes.  Note:  the Installer documentation does state that:  The /QS switch only shows progress, does not accept any input, and displays no error messages if encountered. The /QS parameter is only supported when /Action=install is specified.  Consequently, I believe the /QS parameter should not be requiring input.

    All that for these questions:

    1) Is there away to suppress this dialog while still using the /qs (Quiet Simple) parameter.

    2) Is there a parameter to tell the installer to extract the files to a specified location?

    Thanks,

    Les

    Friday, May 16, 2014 10:25 PM

Answers

  • Hi,

    After you download the installation package of SQL Server Express 2014, and extracts it to the specified location, the dialog of “Choose Directory for Extract Files” will appear when you install the SQL Server Express. Usually, we need to use the following steps to extract the setup files to a temporary location.

    1.In the Command Prompt window type %USERPROFILE%\Downloads\ SQLEXPRWT_x86_ENU.exe /x

    2.When prompted to Choose Directory For Extracted Files type C:\SQLEXPR and click OK to extract the files.

    Or suppress the dialog to extract the right location in SQL Server Express 2008 or other lower version. Such as

    c:\temp>SQLEXPRWT_x64_ENU.exe /extract: "c:\temp".

    However, in SQL Server Express 2014, I do a test, we could not suppress the dialog or use the parameters directly to extract in command line. For more information about installing SQL Server 2014 from the Command Prompt, you can review the following article.

    http://msdn.microsoft.com/en-us/library/ms144259.aspx

    If necessary, personally, I recommend you can provide Microsoft a feature request at https://connect.microsoft.com/SQLServer so that we can try to modify and expand the product features based on your needs.

    Thanks,

    Sofiya Li


    Sofiya Li
    TechNet Community Support

    • Marked as answer by ldakotaq Tuesday, May 20, 2014 10:53 PM
    Tuesday, May 20, 2014 7:38 AM

All replies

  • Hi,

    After you download the installation package of SQL Server Express 2014, and extracts it to the specified location, the dialog of “Choose Directory for Extract Files” will appear when you install the SQL Server Express. Usually, we need to use the following steps to extract the setup files to a temporary location.

    1.In the Command Prompt window type %USERPROFILE%\Downloads\ SQLEXPRWT_x86_ENU.exe /x

    2.When prompted to Choose Directory For Extracted Files type C:\SQLEXPR and click OK to extract the files.

    Or suppress the dialog to extract the right location in SQL Server Express 2008 or other lower version. Such as

    c:\temp>SQLEXPRWT_x64_ENU.exe /extract: "c:\temp".

    However, in SQL Server Express 2014, I do a test, we could not suppress the dialog or use the parameters directly to extract in command line. For more information about installing SQL Server 2014 from the Command Prompt, you can review the following article.

    http://msdn.microsoft.com/en-us/library/ms144259.aspx

    If necessary, personally, I recommend you can provide Microsoft a feature request at https://connect.microsoft.com/SQLServer so that we can try to modify and expand the product features based on your needs.

    Thanks,

    Sofiya Li


    Sofiya Li
    TechNet Community Support

    • Marked as answer by ldakotaq Tuesday, May 20, 2014 10:53 PM
    Tuesday, May 20, 2014 7:38 AM
  • Hi Les,

    Its a Microsoft issue for sure! The reason is that previous Microsoft SQL Express files supplied from Microsoft were built from the "SFXCAB.EXE" where as Microsoft SQL Express 2014 is built from "boxstub_sql.exe".

    Clearly the 2014 build does not support the command line options or behavior as offered by all of its predecessors.

    So if you had built a nested deployment solution using say the 2012 "SQLEXPR_x64_ENU.exe", you cant simply swap it for the 2014 "SQLEXPR_x64_ENU.exe", like you could for all other SQL express distributions, and have it work the same.

    You will need to run the 2014 "SQLEXPR_x64_ENU.exe" and extract the contents of to a folder of your choice, as the little dialog suggests. Then wrap the contents yourself, to deploy within your installer as the "setup.exe" within does support all the command line options.

    HTH

    I have also posted here where I have received pathetic answers - https://connect.microsoft.com/SQLServer/feedback/details/897589/sql-server-2014-express-install-from-command-line-urgent

    Regards


    • Edited by _theVman_ Wednesday, September 3, 2014 5:51 AM added link
    Wednesday, September 3, 2014 5:41 AM
  • Seems that this works to extract quietly (PowerShell):

    Start-Process -PSPath '.\SQLEXPR_x64_ENU.exe' -ArgumentList '/extract:.\SQLEXPR_x64_ENU /Q' -Wait

    So this should work in CMD:

    c:\temp>SQLEXPRWT_x64_ENU.exe /extract: "c:\temp" /q


    Christopher Scholten 龘龗蘇

    Monday, October 1, 2018 5:58 PM