14,500 questions
still appearing as 12.0.4100.1
Where does it appear? What do
SELECT @@VERSION
return as build number? During installation of SP, have you selected the right instance or did you only update the shared components?
After applying SP3 for SQL Server Express 2014 SP1, version detected is incorrect
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(217.60000000000002, 47%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
DineK
1
Reputation point
I recently applied SP3 for SQL Server Express 2014 SP1 but the SQL Server service version is still appearing as 12.0.4100.1 whereas it should change to 12.0.6024.0. Any ideas of why the Instance would be detected as the older version and how to fix
SQL Server | Other
4 answers
Sort by: Most helpful
-
Olaf Helper 47,441 Reputation points2021-06-10T07:18:24.52+00:00 -
DineK 1 Reputation point
2021-06-10T07:40:36.713+00:00 Version query output is same Microsoft SQL Server 2014 - 12.0.4100.1 (X64) Apr 20 2015 17:29:27 Copyright (c) Microsoft Corporation Express Edition (64-bit) on Windows NT 6.3 <X64> (Build 14393: ) (Hypervisor)
-
DineK 1 Reputation point
2021-06-10T07:49:38.523+00:00 There is only one default instance and selected all
Sign in to comment -
-
Eduard-Doru Wagner 21 Reputation points2021-06-10T07:26:46.15+00:00 Please run the following report, in SQL Server Installation Center (SQL install wizard), choose Tools -> Installed SQL Server features discovery report.
This will show you Version for every Feature and Instance installed on that machine.-
DineK 1 Reputation point
2021-06-10T07:47:28.573+00:00 The Discovery report also shows as
Microsoft SQL Server 2014 SQLEXPRESS MSSQL12.SQLEXPRESS Database Engine Services 1033 Express Edition 12.1.4100.1
Sign in to comment -
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 46%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
AmeliaGu-MSFT 14,006 Reputation points Microsoft External Staff2021-06-10T07:57:37.437+00:00 Hi DineK-5571,
Welcome to Microsoft Q&A.
Have you selected the instance in the Select Features page when installing SP3?
Could you please try to run SP3 for SQL Server 2014 installation file as admin again and see if there are any message?
We also can find SQL Server version information in the top line of Errorlog which is located atProgram Files\Microsoft SQL Server\MSSQL12.\MSSQL\Log.Best Regards,
Amelia-
DineK 1 Reputation point
2021-06-10T09:22:35.86+00:00 Hello,
Thanks for your reply, there is a single default instance, and had selected all on the features page. This is the first time I am installing a Service pack on the Express edition and have never seen such an issue in the Standard or Enterprise edition. Also, I had run the setup as admin, and it had installed successfully but the service version number didn't change. Microsoft SQL Server 2014 SQLEXPRESS MSSQL12.SQLEXPRESS Database Engine Services 1033 Express Edition 12.1.4100.1 -
Erland Sommarskog 121.8K Reputation points MVP Volunteer Moderator2021-06-10T22:07:47.02+00:00 there is a single default instance
But the instance ID seems to be MSSQL12.SQLEXPRESS , so it looks like a named inetance to me.
Sign in to comment -
-
AmeliaGu-MSFT 14,006 Reputation points Microsoft External Staff
2021-06-11T08:09:39.643+00:00 Hi DineK-5571,
I did a test and the installation of sp3 for SQL Server 2014 went well.
Install SP3 for SQL Server:
After installing:
And if we launch SP3 setup file again after successfully installation, we will see the following error message:
Please make sure the setup file you installed is 64-bit.
Please try to download SP3 for SQL Server from here, and install it again.
Best Regards,
Amelia