I have a box that lists SQL Server 2014 SP2 (12.2.5000) in both add/remove programs and the registry
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\120\SQLServer2014\CurrentVersion\PatchLevel
However, if I run
SELECT @@VERSION it returns
12.0.2000. If I look at the sqlsrvr.exe it also lists
Doing some testing I can get a machine in this state (not sure if this is how it happened in production).
- Windows 7 SP1 image with SQL Server 2014 RTM (12.0.2000)
- Execute SQL Server 2014 SP2 installer as an upgrade (non-automated)
- Once on the accept license screen, cancel the install
- Reboot the machine
The big problem is that if I execute the SQL Server 2014 SP2 upgrade package against this machine nothing is upgraded. What are my options? Do I just need to tear out SQL Server and install clean? I would love to avoid that if possible as this will have to happen at 200+ locations
EDIT: Okay, so this is where I say I'm not a DBA and I figured out what was happening. Apparently the "Upgrade" option does not upgrade the instance. Still doing some reading on that, but I can "add features to an existing instance" and get things upgraded. Still digging through, I will post an answer once I have everything squared away. Thank you for all the suggestions thus far.
EDIT 2: At current this is the installer that was used. https://www.microsoft.com/en-us/download/details.aspx?id=53167 When running through this upgrade the "Upgrade from SQL Server 2005, 2008, etc. option is chosen. I believe this is the issue at it appears to just updgrade Shared Features? I could use this installer and go through the add features to an existing installation and select the appropriate instances.
I believe this is the installer we should be using as it is a patch to SP2. https://www.microsoft.com/en-us/download/details.aspx?id=53168 Select all instances and go. Seems easier.
Did I break this down about right?