question

BilalKhan-7668 avatar image
0 Votes"
BilalKhan-7668 asked ·

sql server 2014 express upgrade sp0 to sp2

how to upgrade sql server 2014 expree sp0 to sp2 every time i got error feature installed is not avialable

sql-server-general
· 2
10 |1000 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.

Which build version is your SQL Server? You can get it with

 SELECT @@VERSION
0 Votes 0 ·

Microsoft SQL Server 2014 (RTM-CU14) (KB3158271) - 12.0.2569.0 (X64)
May 27 2016 15:06:08
Copyright (c) Microsoft Corporation

Express Edition (64-bit) on Windows NT 6.3 <X64> (Build 14393: ) (Hypervisor)

0 Votes 0 ·
CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered ·

Hi @BilalKhan-7668,

Is there a special purpose let you need upgrade to SP2? We recommend that you can upgrade it for latest version of SQL Server 2014. You can download it from this link, see below, SP 3 is support Microsoft SQL Server 2014 Express.
75671-2014-sp3.png

Best regards,
Carrin


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



2014-sp3.png (62.8 KiB)
·
10 |1000 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.

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered ·

Use the installer SQLEXPR_x64_ENU.exe from
https://www.microsoft.com/en-us/download/details.aspx?id=57473
and try it again.

· 2 ·
10 |1000 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.

why not SQL server 2014 express sp3 .
is there specific reason for sql server 2014 sp3 not express sp3.
does it effect the running enviorment

0 Votes 0 ·

waiting for your kind response

0 Votes 0 ·
TomPhillips-1744 avatar image
0 Votes"
TomPhillips-1744 answered ·
·
10 |1000 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.