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
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
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?
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)
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.
The Discovery report also shows as
Microsoft SQL Server 2014 SQLEXPRESS MSSQL12.SQLEXPRESS Database Engine Services 1033 Express Edition 12.1.4100.1
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 at Program Files\Microsoft SQL Server\MSSQL12.\MSSQL\Log.
Best Regards,
Amelia
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
there is a single default instance
But the instance ID seems to be MSSQL12.SQLEXPRESS , so it looks like a named inetance to me.
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
16 people are following this question.