Preparing the configuration file
Make the following changes to the ConfigurationFile.ini that you took a copy of.
- INDICATEPROGRESS="True" – by default this is set to "False"
- QUIETSIMPLE="True" – by default this is set to "False"
- Remove the line that says UIMODE="Normal". If this line isn’t removed, the installation will fail.
For your reference, I’ve made the default and modified files available for download.
Now that your system is ready, the installation files and configuration files are ready and the changes made, you’re ready to run the installation. From above, remember that I’m assuming you’re installing from C:InstallSQL2008 and that your configuration file is C:Installsql-2008-express.ini – now you just need to run the command below.
C:InstallSQL2008Extractedsetup.exe /CONFIGURATIONFILE=C:Installsql-2008-express.ini /IAcceptSQLServerLicenseTerms
Take note of the /IAcceptSQLServerLicenseTerms switch – it automatically accepts the EULA. Without this switch on the command line, the install will fail.
If you’ve done everything correctly, SQL Server 2008 Express R2 will install without any user interaction. Please note that my requirements aren’t for a completely silent install so this isn’t a 100% silent install. You can make it that way by setting the QUIET parameter to "True", though.
If you have any questions about this, please let me know in the comments. Thanks.