SQL Server 2005 SP2 setup might fail with the error Error 29528: The setup has encountered an unexpected error while Updating security settings on HTTP services

Few days back I worked on a case where the sql server SP2 setup was failing to install with an Error 29528 so I thought I should blog this article to address the cause of the failure and how can we resolve the issue. Problem Description: You may see the following error in the SQL…