OptionPower bypasses the installation of SQL even though SQL does not appear on the list of installed products
Cause: User does not have Admin rights.
Solution: Ensure that the user installing OptionPower has full administrative rights. MSSQL will not install without admin privileges
Cause: Another install has a pending reboot
Solution: Other installs (notably Windows Updates) sometimes require a reboot to finish installing. If the OS has a pending reboot flag, MSSQL will fail to install. Reboot the machine to finish installing any previous installations.
Cause: Information about SQL or OptionPower exists in the system registry. This may occur if an application was only partially installed or if something went wrong when an application was uninstalled and the registry failed to update.
Solution:
Double-check to make sure SQL is not installed. (Control Panel, Programs and Features)
OptionPower checks for two keys to determine whether SQL exists or if it should be installed. If either of these exists, it won’t install. The two keys are:.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQLServer\110\Tools\ClientSetup\CurrentVersion\CurrentVersion (with minimum of 11)
- If this key exists, delete the Current Version value (i.e. CurrentVersion REG_SZ 11.0.3000.0)
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQLServer \OTI_SQL2K5
- If this exists, delete the entire OTI_SQL2K5 key.