When we try to install a patch over SQL Server 2008, we received the following error message.
Work Around:
Open the registry and varify the value at HKEY_LOCAL_MaCHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.MSSQLSERVER\ConfigurationState
The values for all the keys under this should be 1. If it is not 1, then there is some issue in configuring the corresponding feature.
Fix the feature configuration issue or edit the registry to change the value to 1 to install the patch.
I have the same problem! I am still working hard now! Hop this helps!
I’ve been struggling with this all morning; SQL Server Installation Center -> Maintenance -> Repair took our dev instance down for an hour with no gain.
Trying the registry key hack; did you revert the keys back after installing SP1?
Hi
The key value indicates the successful installation of a particular feature or component. If it is not 1 for SQL Server Reporting Services means there is some error occurred in the installation of SQL Server reporting services. You can revert back the key values to original indicating the particular service installation is not done properly. You can also re-install the particular service to fix the installation issue.
Regards
Ambily