Unfortunately, there are a few bugs in the wrapper executable for SQL Server 2014 RTM. These seem to be exclusive to SQL Server 2014 RTM, and according to Microsoft will be fixed in service pack 1. In previous versions of the SQL Server Express installation sets, the extract folder is randomly generated and the files are automatically extracted.
Because of this, you can run the wrapper in one of two ways.
- Using the same command line parameters as I used in SQL Server 2008 Express and 2012 Express, I am prompted for an extract folder. Once extracted, the Setup.exe is correctly executing using command line parameters passed to the executable. This has the down side of making completely automated installs impossible.
- Using command line parameters exclusive to the wrapper, I can specify an extract folder. This has the down side of ignoring any other command line parameters. So, I'm going to have to extract the files and then run Setup.exe separately.
- /Q - Quiet mode. This is the same as Quiet mode for Setup.exe
- /U - Progress Bar mode. This displays a progress bar as the files are extracted.
- /X:<PATH> - The Extract Folder where the files are extracted. This last parameter has a few caveats.
- The parameter must be the last parameter. Anything after that is considered part of the path.
- The parameter must be followed by a colon and then followed by the path.
- There must be no space between the X and the colon or the colon and the path.
What this means is that anyone wanting to automate the installation of SQL Server will need to first extract the files. Then, run Setup.exe separately. Afterward, any temporary folder and files will need to be cleaned up.
While this isn't a huge burden for developers, it definitely qualifies as annoying. It did involve a couple of extra days worth of testing to make sure I covered all the bases.