Error while applying Security Updates for SQL Server 2005, 2008 and 2008 R2

Posted: February 8, 2013 in SQL Server

The web these days is full with people reporting issues while trying to apply SQL Server related Security updates. A lot of answers is around which are helpful but I couldn’t see any touches the actual issue.
First, when you are trying to apply any security updates, security updates usually requires some per-requisites. So you need to make sure first if you are meeting these pre-requisites like having the latest service pack installed, specific updates or previous security update. To make it easier for you, when a security update released by Microsoft, these is a Security Bulletin associated with these updates, go and read the exact description of the update and the pre-requisites associated with it.

In case you are sure that you are doing everything to the litter according to the book, you will need simply to look at the error code the update produced, common error code related to security updates will be 84B200001 “This error code collected with the KB2716440 security update” so what you will need to do next is to repair your SQL Instances. To update the instances is a simple process, you will need the installation media of SQL Server “Make sure you will use the correct one based on the SQL Server version you have”, to know the SQL Server version you are running, run the following query

Select @@version

For the purpose of the security update KB2716440, make sure your version is 10.50.2500 which indicates SQL Server 2008 R2 SP1

Once you identified the correct installation media you should use, simply follow this article to repair the instances, remember, you should update all instances and on all SQL Server nodes if you are using clustering.
Repair SQL Server 2008 R2 Instance

Basically the instance(s) repair will do the following:

1) All missing or corrupt files are replaced.
2) All missing or corrupt registry keys are replaced.
3) All missing or invalid configuration values are set to default values.

Once you are done. Try to install the SQL Server security update, you should be now rocking easily!!

Hope this read is informative for you, thank you for reading!!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s