SQL Server 2008 R2 Service Pack 1 Or Later Is Required For Upgrade

When upgrading Microsoft SQL 2008 R2 to MSSQL 2012, you may get the following error message:

Rule Check Result

Rule “SQL Server 2008 R2 Service Pack 1 or later is required for upgrade.” failed.

The SQL Server 2008 R2 Features that have been selected to be upgraded to SQL Server 2012 are not at the required service pack. To continue with this upgrade, install SQL Server 200 Service Pack 2 or later to the selected instance and the shared features.

This is pretty self explanitory. Before you upgrade to SQL 2012, you have to upgrade to SQL 2008 R2 SP2. It’s a little bit or an odd message, because Windows Update can show that there are no updates available for SQL Server and the message says that SQL 2008 R2 SP1 is supported, but requires you to have SP2.

The fix is to download SQL Server 2008 R2 SP2 from Microsoft and install SP2 before running the SQL 2012 upgrade.

VN:F [1.9.22_1171]
Rating: 7.0/10 (3 votes cast)
SQL Server 2008 R2 Service Pack 1 Or Later Is Required For Upgrade, 7.0 out of 10 based on 3 ratings

Leave a comment

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