4

I have an existing SQL 2008 R2 on SP3. Have another instance in use that is SQL 2008 R2 SP1

I need to update the named instance with sp1 to sp3 but i'm not getting any options. It tells me my version is sp3 which for the named instance is not correct.

How can I accomplish this?

Improve this question
2
  • There are similar posts like this on dba, which might be a better fit for this question.
    – Reaces
    Feb 25, 2015 at 20:58
  • When you run the installer, it should show all instances on the server that match the version, then show check boxes next to the ones that can be patched. DOUBLE CHECK the versions and editions and post both of them back here. SELECT SERVERPROPERTY('ProductVersion'), SERVERPROPERTY('ProductLevel'), SERVERPROPERTY('Edition')
    – Sean Gallardy
    Feb 26, 2015 at 17:23

1 Answer 1

Reset to default
0

Make sure you are running the x64 or x86 version of the update, according to the installed instance. You can download both versions from https://www.microsoft.com/en-us/download/details.aspx?id=44271

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .