Matt Sigman

Hands-On Software Leader

Matt Sigman - Hands-On Software Leader

Error applying SQL Server 2008 R2 SP2

If you get an error applying Service Pack 2 to SQL 2008 R2:

The patch installer has failed to update the following instance: MSSQLSERVER. To determine the reason for failure, review the log files.

And then if you go to the log file it mentions

Product: SQL Server 2008 R2 SP2 BI Development Studio – Update ‘Service Pack 2 for SQL Server Business Intelligence Development Studio 2008 (64-bit) (KB2630458)’ could not be installed. Error code 1603.

The problem occurs if you have deleted any files with the .log extension, or used the Microsoft Disk Cleanup wizard.  To fix it, go to Start > All Programs > Microsoft SQL Server 2008 R2 >  Configuration Tools > SQL Server Installation Center and run the wizard.  When prompted to choose which instance, select the option titled “<<Repair shared features only>>” and click Next, Next, Repair.  Then re-run the Service Pack and everything should install correctly.

Category: .NET
  • Carsten Eiberg says:

    The problem also occurs when you are low on disk space on the disk from where you are running the serivce pack. The error “low disk space” can be found approx. half way down in the “the log file it mentions”. Since the log file is pretty comprehensive, it’s not easy to spot.

    March 1, 2013 at 2:15 PM
  • Fran says:

    Ok so under Maintenance/ I click Repair. It asks for the installation media.
    Can you be more specific on how to proceed?

    November 5, 2013 at 9:31 AM
    • Fran says:

      I do not see the Select an Instance or any option such as that.

      November 5, 2013 at 9:32 AM
  • Andrey says:

    Had a similar error “Product: Microsoft SQL Server System CLR Types (x64) – Update ‘Service Pack 2 for SQL Server System CLR Types (64-bit) (KB2630458)’ could not be installed. Error code 1603″

    Repairing shared features did the trick, thanks for the tip.

    December 3, 2013 at 10:13 AM
    • madanamohanareddy says:

      Please share the screen shot of 1603 error on apllying sp2 time.

      July 18, 2014 at 1:39 PM
  • Matt says:

    Thank’s so much for posting! I was getting the message about failed installing shared features. I didn’t see the repair shared features only option so I ended up just running the repair on the full installation of SQL. Afterwards I was able to install Service pack 2 for Microsoft SQL Server R2 error free.

    February 11, 2014 at 11:33 AM
  • Uma says:

    Great Help indeed!, SQL 2008 R2 SP2 was failing on my system, with no indication of any corrupted installation!!! The error 1603 said something about permissions – I tried repairing the whole install of R2(dbe,ssrs and ssas) and the shared components- and then re-applied the patch – completed successfully!!
    Many thanks for the post

    May 12, 2014 at 8:40 PM

Your email address will not be published. Required fields are marked *

*