Installation of SQL Service Pack 1 (or) Cumulative Pack for SQL Server 2008 it fails with the below error message
A failure was detected for a previous installation, patch, or repair during configuration for features [SQL_PowerShell_Engine_CNS,SQL_PowerShell_Tools_ANS,XXXX,XXXXX]. In order to apply this patch package (KB968369 XYZ), you must resolve any issues with the previous operation that failed.
Look at the Sub-keys for below registry keys and check if Value ‘2’ is set for any components.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSAS10.XY1\ConfigurationState
Replace MSAS10.XY1 with your instance
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.KJ\ConfigurationState
Replace MSSQL10_50.KJ with your instance
Run the Repair for existing setup. Values for all the sub keys will change to 1 after the successful repair.
Re-start the Service pack installation.