Spectacular Microsoft fail - SQL Server installation

I am stunned, given the robust way that the majority of MS tools which accept both command line and configuration file-driven arguments handle things, i.e. the command line overrides the configuration file, that the installer for SQL Server can be so spectacularly awful!

If you specify the '/Q' argument on the command line and your configuration file also contains an entry for 'UIMode', you will get this error:

Media ScenarioEngine.exe returned exit code: 0x858C001C

Crystal clear, right? Obscure text, meaningless error numbers...SMH...

Luckily, the log written to the bootstrap location (e.g. "C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\Summary.txt") tells you what's happened:

The /UIMode setting cannot be used in conjunction with /Q or /QS

Also luckily, I always use the extracted MSIs to install this junk so am able to work around this nonsense but I just thought I might save some other poor soul the heartache and wasted hours trying to decipher what the Hell prevents it working.


This post is locked

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login


This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ