The SQL Server 2005 setup.exe allowed the following parameters for unattended installations:
/qb - allows the display of basic Setup dialog boxes. Error messages are also displayed.
/qn - suppresses all Setup dialog boxes and error messages
For SQL Server 2008 R2 however, these parameters are no longer supported but the following are used instead:
/Q - Specifies that Setup runs in a quiet mode without any user interface. This is used for unattended installations.
/QS - Specifies that Setup runs and shows progress through the UI, but does not accept any input or show any error messages.
I have some questions regarding this.
1.Why is there no way to have an unattended installer display error messages like the 2005 /qb switch did?
Imagine that you have an installer written in InstallShield for example that launches an unattended setup. With 2005, the SQL Server installation notified the user that the installation failed and what error message it returned. With 2008 the /QS option does not give any error messages at all but you have to dig into the SQL Server setup logs to determine what went wrong. This is not very user friendly.
2.Why is the /QS installation option in 2008 only available for /ACTION=install and not /ACTION=upgrade? Why would you not want to see the progress of an upgrade just as well as a fresh install?
3.The dialogs that are displayed with the /QS switch are very similar to the dialogs displayed when doing an interactive installation, except that they don't accept input. At the most theare are no less than THREE dialogs beeing displayed to the end user with some saying "click Install to install..." although the install button is disabled (screenshot). This is not the way an unattended installer should behave.
It would be much better if the entire installation just displayed a small windows saying "Installing SQL Server 2008 R2" or similar and then displayed any errors that occurred during installation.
4.Is there any way to prevent the command line window displayed when installing with the /Q option?