Security Update for SQL Server 2008 R2 Service Pack 1


As a part of security maintenance if your organisation have a scheduled interval of patches to apply to the existing SQL Server 2008 R2 data platform, then it is the time now to apply the important security patch that is applicable for SQL2008R2 SP1 environment only.

However if you have  applied the Service Pack2 for SQL Server 2008 R2, then ignore this patch as it is already included with SP2.

 

KBA2716440 talks about the key security bulletin that is required to apply this patch. Here is the extract:

 

As it states for the Home PCs you will have the Automatic update that runs regularly will download the patch and apply. However, for the Organisations you must go through the  patch download route to obtain the patch files.

Download this security patch from this MSDownloads section page.

 

Just a highlights of known issues from that KBA2716440:

Known issues with this security update

  • When you use the /? switch or the /Help switch with this security update package, you receive an error message.

    This issue occurs because SQL Server 2008 R2 update packages use a new IACCEPTSQLSERVERLICENSETERMS command-line argument that is required for command-line installations. To display Help for these packages, use the following switches:After you install this security update, the Add or Remove Programs entries for this security update do not have “Security Update” in the title of the security update.

    • /IACCEPTSQLSERVERLICENSETERMS /?
    • /IACCEPTSQLSERVERLICENSETERMS /Help

    For example, type the following to view the Help information:

    SQLServer2008R2-KB2716440-x64 /IACCEPTSQLSERVERLICENSETERMS /?
  • Note This is only a cosmetic issue and does not affect the functionality of the security update.

  • After you install this security update, the installation wizard shows the security update as an “Update Program” instead of a “Security Update.”

    Note This is only a cosmetic issue and does not affect the functionality of the security update.

 

 

You can also refer to the SQL Server 2008 R2 specific builds that were released after the SP1 is released.