Service packs for previous version of SQL

I did an in-place upgrade from SQL 2012 to SQL 2014. Windows Update is now recommending I install a SQL 2012 service pack. I don't remember seeing such a thing before so maybe something has changed. Surely the upgrade overwrote the SQL 2012 components with SQL 2014 components. Please advise: should I install this service pack and how do you know?

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley ♦♦ commented · Dec 23, 2015 at 10:57 AM

If you run the setup.exe for 2014, click Tools on the left hand side and then choose the 'Installed SQL Server features discovery report', you get a server wide glance of what is installed.

2 ·

ThomasRushton ♦♦ commented · Dec 23, 2015 at 09:48 AM

Alternatively, it might be worth manually launching SQL2012SP2, and seeing what components it can identify as still being installed... Also, take a look in the file system to see what's hanging around. It won't necessarily give you an accurate view, but you should get some idea from looking in C:\Program Files\Microsoft SQL Server\... and the equivalent x86 directory structure. NB: Don't go messing with this stuff manually, though - just use it as a way of getting ideas about what might still be installed.

1 ·

KenJ commented · Dec 22, 2015 at 02:57 PM

what is your current 2014 build and which 2012 service pack is it recommending?

0 ·

David Wimbush commented · Dec 22, 2015 at 03:24 PM

Hi Ken. Its SQL 2014 build 12.0.4100.1. Windows Update has SQL 2012 Service Packs 1 & 2 as important updates.

0 ·

Arcanas commented · Dec 22, 2015 at 04:53 PM

Would it be possible to run the 2014 installer and see if there are any components on the system that still require an update?

0 ·

David Wimbush commented · Jan 08, 2016 at 02:27 PM

This is odd. I had a few things I needed to sort out. Now that I've come back to it, the Windows Update recommendations have gone away. I checked the update history in case it installed them automatically when I wasn't looking but no. No updates outstanding. I definitely didn't imagine this! Thanks anyway, guys.

0 ·

question