I am attempting to upgrade SQL Server 2008 R2 Enterprise edition (64-bit) to service pack 1. The product version is 10.50.1600.1, which is, to the best of my knowledge, SQL Server 2008 R2, and also, again, to the best of my knowledge, an RTM version
(when I run query SELECT SERVERPROPERT('productversion', SERVERPROPERTY('productlevel') in SSMS, the results display as "10.50.1600.1" and "RTM". I downloaded SQLServer2008SP1-KB968369-x64-ENU.exe. When I run this application, and get to the "Select
Features" dialogue, no instance specific features are displayed (e.g. Database Engine, Analysis Server), Shared Features are displayed but cannot be selected, and when "Next" is clicked, the error "There are no SQL Server instances or shared features that
can be updated on this computer".
The OS on which I'm installing the service pack is Windows 2008 R2 Enterprise.
What little I have gleaned from similar postings suggests that the installed version of SQL is not an RTM version. How can that be, if, the only version I've ever installed on this new (virtual) server is reporting that it is, in fact, RTM?
By the way, I've tried running "Repair" on the 3 installed named instances and the shared features, then reinstalling SP1, with no luck.
View Complete Post