We're building a new installer for our software, which consists of installing SQL Server 2014 Express. One thing about SQL Server is that it does not allow you to continue installing if your computer's pending a restart. We run it in silent mode, so it essentially just fails to install SQL Server. More specifically, when the computer's pending restart due to Windows updates.
I found this question, but did not help. Then I found this article, wrote a function, and actually answered on that question.
Then I tested it on a few other systems. It turns out, this function also returns true on a system which is pending any Windows updates, but not necessarily a restart. In fact, this system hasn't had an update since January... But the SQL Server install itself doesn't complain. So one or more of the checks in this function are not necessary.
I disabled two of those checks:
- SOFTWARE\Microsoft\Windows\CurrentVersion\WindowsUpdate\Services\Pending
- Software\Microsoft\Windows\CurrentVersion\Component Based Servicing\PackagesPending
However it's still returning true on the system which SQL doesn't actually have a problem with.
Which of these checks are necessary for us to test to equate to SQL Server's checks, so that we can ensure the SQL installation won't fail later on in the install process?