Handle the 3010 reboot required return code as success

[Fazlur Shaikh]

Hi Team,
We're trying to install SQL 200 with more than one instances.
Current scenario involves upgrade of SQL 2014 to 2022. Then new instance is created.
However the new instance creation returns 3010 for reboot. And this is not treated as success.
The installer prompts that the SQL prerequisite was not installed correctly, do you want to proceed with the installation.

This is creating problem for proceeding further in the installation.
Kindly help in getting this through.

Thanks,
Fazlur.

[Catalin]

Hello Fazlur,

From what you are describing, you seem to have the "Continue with the main installation even if the prerequisite is not installed" option checked in the "Prerequisites" page --> your prerequisite --> "Installation" tab, is that correct?

If so, when prompted with this:

The installer prompts that the SQL prerequisite was not installed correctly, do you want to proceed with the installation.

you should be able to continue with the installation. Is that not the case?

Searches from "Condition tab" are performed twice:
- first to determine whether the prerequisite should be installed ( if the conditions are false)
- and second time, after the prerequisite has been installed, to determine whether the prerequisite install was successful ( when the conditions should be evaluated as true )

The reason you are getting this issue is because when your conditions were evaluated second time they failed, because the reboot wasn't performed and most likely the registry hasn't been updated properly (this is a known issue for some other prerequisites such as .NET Framework).

Unfortunately, there isn't much we can do here, besides having the option I mentioned above enabled. We can not really force Windows Installer to see "3010" as success.

For Windows Installer, the only return code for "success" is 0.

Windows Installer return codes

Best regards,
Catalin