question

Atrix370-4384 avatar image
0 Votes"
Atrix370-4384 asked Atrix370-4384 commented

Accidentally upgrade to SQL Server 2014 32-bit

Hi all,

Recently, I have accidentally upgraded from SQL Server 2014 64-bit version 12.0.5223.6 Express Edition to SQL Server 2014 32-bit version 12.0.6024.0

By right, I'm suppose to install using 64-bit unfortunately I made a mistake.

I tried to uninstall the upgraded version from the image below but it gave me an error.

89337-sql-server-2014-issue.png



Regards,
Atrix


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.

1 Answer

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered Atrix370-4384 commented

SQL Server 2014 64-bit version 12.0.5223.6 Express Edition to SQL Server 2014 32-bit version 12.0.6024.0


A cross upgrade 64 bit => 32 bit is not possible.
What exactly did you install? By the build numbers it was just a service pack 3.

· 3
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.

I was able to install the KB4022619 patch SQLEXPR_x32 setup.exe successfully but not SQLEXPR_64 setup.exe. Error shown as " There are no features selected for upgrade". If I were to upgrade to a later build version 12.0.6164.21, it can only install successfully using 32-bit. The 64-bit installer will show error as "There are no SQL server instances or shared features that can be updated on this computer"

0 Votes 0 ·

patch SQLEXPR_x32 setup.exe successfully but not SQLEXPR_64

You have a 32 bit SQL Server and so you can only apply 32 bit service packs; installing SQLEXPR_x32 is quite enough in your enviroment.

1 Vote 1 ·

Yes you are right. I just realized when I query the SELECT @@version

0 Votes 0 ·