question

DineK-5571 avatar image
0 Votes"
DineK-5571 asked AmeliaGu-msft answered

After applying SP3 for SQL Server Express 2014 SP1, version detected is incorrect

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-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered

Hi DineK-5571,
I did a test and the installation of sp3 for SQL Server 2014 went well.

104659-image.png
Install SP3 for SQL Server:
104630-image.png

After installing:

104560-image.png

And if we launch SP3 setup file again after successfully installation, we will see the following error message:
104711-image.png

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



image.png (11.0 KiB)
image.png (26.7 KiB)
image.png (14.5 KiB)
image.png (51.9 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered ErlandSommarskog commented

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


· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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

0 Votes 0 ·

there is a single default instance


But the instance ID seems to be MSSQL12.SQLEXPRESS , so it looks like a named inetance to me.

0 Votes 0 ·
EduardDoruWagner-3506 avatar image
0 Votes"
EduardDoruWagner-3506 answered DineK-5571 commented

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.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

The Discovery report also shows as
Microsoft SQL Server 2014 SQLEXPRESS MSSQL12.SQLEXPRESS Database Engine Services 1033 Express Edition 12.1.4100.1

0 Votes 0 ·
OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered DineK-5571 commented

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?

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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)

0 Votes 0 ·

There is only one default instance and selected all

0 Votes 0 ·