A failure was detected for a previous installation, patch, or repair during configuration for features [SQL_PowerShell_Engine_CNS,SQL_PowerShell_Tools_ANS]. In order to apply this patch package (KB968369), you must resolve any issues with the previous operation that failed.
Posted by Karthick P.K on January 12, 2011
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.
Thanks
Karthick P.K
