Search code examples
sql-serversql-server-expresssql-server-2014

SQL Server 2014 Express Silent install without Choose directory prompt


I would like to do a silent install with /qs command to install sql server 2014 express. I did many installations with 2008 express and it did not have this kind of issue.

When I try to install, by double clicking the setup file or by command line install, it shows Choose directory for extracted files prompt. I have searched alot but I cannot find any information about this.

My question is: Is there a way to specify the path to be extracted along with other commands?

I thought /qs (silent mode) should not accept any user input which looks like it's a flaw in 2014 version. Any ideas?


Solution

  • There was a change in the self-extract Express packages in SQL Server 2014. The default location where payload is extracted was changed. That location can be specified on the UI or on the command line.

    To preset the location on the UI run:
    SQLEXPR_x64_ENU.exe /x:LocationToExtract

    To extract payload to a specific location without prompt use and with the progress bar use: SQLEXPR_x64_ENU.exe /u /x:LocationToExtract

    To extract payload to a specific location without prompt and silent use: SQLEXPR_x64_ENU.exe /q /x:LocationToExtract

    There is an issue that /qs parameter is not recognized and cannot be used the same way as in SQL 2012. That issue will be addressed in SQL Server 2014 Service Pack 1.

    Answered from a official representative from microsoft. Here