
Feel free to copy it if you’d like: SQL Server 2016 Configuration File This is what my configuration looked like.
Also, if you want to install silently, you must remove or comment out UIMODE="Normal" in the file. You cannot have both QUIET and QUIETSIMPLE both set to True. To install silently, you need to set QUIET="True". Optionally, you can specify the SA account password by referencing SAPWD="ENTER_YOUR_PASSWORD". The installer does not create this for you, and the install will fail without this. You must add IACCEPTSQLSERVERLICENSETERMS="True" to your file manually. A few more changesĪ few things you should know about your ConfigurationFile.ini: Once here, if you look at the bottom of the GUI window, it will give you path to the Configuration File that the setup created. Go through the various installation steps using the GUI until you get to the “Ready to InstalL” step. Normal is the default value for non-express editions. Setting /UImode to Normal will present every dialog box that exists in the installer (even ones that do not apply to Express). Please take note that /Action parameter is required.
SQLEXPR_圆4_ENU.exe /ACTION=INSTALL /UIMODE=Normal For this guide, I’m using the 2016 Full Offline installer, which can be found here: 圆4ENU.exe Run the installerĪfter that, you’ll want to run the installer on the package that you downloaded: Start by downloading the SQL Server installer. I’ve only tested this using the offline installer (roughly 400MB), not the bootstrapped version (4MB). Luckily for us, the installer creates the Configuration File for us. The trick to installing this silently is to create a ConfigurationFile.ini and then reference that during the install. I needed to install SQL Server Express 2016 silently, but the documentation out there wasn’t the best.