0

I have installed sqlserver 2008R2 service pack 3 on my instance.

The installation went through successfully but the instance still shows version number of SP1 in management studio.

When I start the patch setup again, I see that the main database features are patched correctly but that the shared features are "incompletely applied"

Can someone explain me what to do with this ?

Would a reboot help ?

https://i.imgur.com/xtPce9a.png

https://i.imgur.com/WNibJ3N.png

  • I rebooted the server and it did not change the upgrade status. – A_V Jun 27 '16 at 18:33
  • Have you looked at the setup logs to see what "incompletely" means? Where are you seeing SP1 in Management Studio? If that is from @@VERSION it is likely the operating system service pack level, not SSMS. – Aaron Bertrand Jun 27 '16 at 18:33
  • Also, do you really need to be using such an old version of SSMS? This new version is much better for most things except for managing things like legacy SSIS packages / maintenance plans. – Aaron Bertrand Jun 27 '16 at 18:34
  • Alright I'll give SSMS2016 a try but anyhow I always access this server remotely so the local SSMS doesn't change much. Here is the output of @@VERSION : Microsoft SQL Server 2008 R2 (SP1) - 10.50.2550.0 (X64) Jun 11 2012 16:41:53 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor) – A_V Jun 27 '16 at 18:39
  • So the engine you're connecting to is still SP1, not SP3. And its operating system is a version of Windows with Service Pack 1 applied. Where are you getting that SSMS is at SP1? – Aaron Bertrand Jun 27 '16 at 18:43
1

After running an instance repair, the correct version number is now being displayed.

The shared features are still incompletely installed but at least querying the @@version view will now return the correct patch level.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.