There are no SQL Server instances or shared features that can be updated on this computer

Question

David-Mac on Wed, 10 Aug 2011 21:38:39


when trying to install SQL 2008 R2 SP1 I get the error “There are no SQL Server instances or shared features that can be updated on this computer”.
What I have: SQL 2008 R2 64bit (version 10.50.2500) installed on Windows Server 2008 R2 64bit setup in a two-node failover cluster.
What I have done: Downloaded SQLServer2008R2SP1-KB2528583-x64-ENU.exe, ran it, the “System Configuration Check Report” shows all checks passed except for the “Engine_ResourceDLLUPdateRestartCheck” which it shows as “Not applicable”, I click next and check “I accept…” then click next.  Both check boxes are grayed out, but are pre-checked.  When I click “next” it gives the error above.
Possible Unknows: Another coworker is also working on the same project and could have installed something that I am not aware of.
I have seen numerous articles about this error, but they almost all have to do with the improper version of 32 versus 64 bit.  I have double checked to make sure its Windows Server 2008 R2 64bit and SQL 2008 R2 64bit. 
Any input would be greatly appreciated.





Replies

AbedKhooli on Thu, 11 Aug 2011 07:11:08


Try to check the current version of the server - just to make sure it was not patched. Run this query against master db in management studio:
SELECT 
  SERVERPROPERTY('productversion') as 'Product Version',
  SERVERPROPERTY('productlevel') as 'Service Pack', 
  SERVERPROPERTY('edition') as 'Edition',
  SERVERPROPERTY('instancename') as 'Instance',
  SERVERPROPERTY('servername') as 'Server Name'

The result will tell if it is RTM or SP1
AK

David-Mac on Thu, 11 Aug 2011 15:52:03


Thanks for the reply.

Here is the results:

I cant seem to find a page that says what the latest version is.  Are there any updates past 10.50.2500 ??

Thanks

AbedKhooli on Thu, 11 Aug 2011 18:06:29


So you already have SP1 installed and there is nothing to add when you re-run the service pack 1 installer. See http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=26727 which shows the above version.
AK

David-Mac on Thu, 11 Aug 2011 20:39:29


Thanks.

shamsuddinarefin on Mon, 20 Feb 2012 23:10:24


I have also the same problem.

when trying to install SQL 2008  SP1 I get the error “[Error Message]
There are no SQL Server instances or shared features that can be updated on this computer.”because all feature bydefault selected.no one can select or unselect.

What I have done: Downloaded SQLServer2008R2SP1-KB2528583-x86-ENU.ex

this a problem.please help me.

vtsatuk on Fri, 15 Jun 2012 13:40:11


I have also the same problem.

when trying to install SQL 2008  SP1 I get the error “[Error Message]
There are no SQL Server instances or shared features that can be updated on this computer.”because all feature bydefault selected.no one can select or unselect.

What I have done: Downloaded SQLServer2008R2SP1-KB2528583-x86-ENU.ex

this a problem.please help me.

I have similar problem how did you resolve it? though I have the 2008R2 with a different file version of 1600.1

Any information will be helpful

Atamidos on Mon, 21 Jan 2013 17:27:19


So I ran into this issue before. I verified that I had the right level of service pack installed and I had the right architecture of the patch as well (x64 SQL installed for me). So basically the right version was installed and I had the right patch so it should work.... I finally was able to solve the problem by just updating the keys that SQL uses to determine which version is installed. The update then proceeded without a problem. Maybe sometimes SQL does not update those keys properly when SP1 is installed.... I don't know but it fixed it for me. You can find the keys you need to edit for various versions of SQL on this site:

http://support.microsoft.com/kb/321185