Differences between the different installers of SQL Server 2014 Express

Question

I'm trying to understand the differences between the different installers of SQL Server 2014 Express. If you are able to tell me whatever you can or find documentation on them, I'd appreciate it.

https://www.microsoft.com/en-us/download/confirmation.aspx?id=42299

Express 32BIT WoW64\SQLEXPR32_x86_ENU.exe
Express 32BIT\SQLEXPR_x86_ENU.exe
Express 64BIT\SQLEXPR_x64_ENU.exe
ExpressAdv 32BIT\SQLEXPRADV_x86_ENU.exe
ExpressAdv 64BIT\SQLEXPRADV_x64_ENU.exe
ExpressAndTools 32BIT\SQLEXPRWT_x86_ENU.exe
ExpressAndTools 64BIT\SQLEXPRWT_x64_ENU.exe
LocalDB 32BIT\SqlLocalDB.msi
LocalDB 64BIT\SqlLocalDB.msi
MgmtStudio 32BIT\SQLManagementStudio_x86_ENU.exe
MgmtStudio 64BIT\SQLManagementStudio_x64_ENU.exe

score 8 · Answer 1 · answered Dec 02 '15 at 19:18

Express 32BIT WoW64\SQLEXPR32_x86_ENU.exe

This is for installing the 32-bit version of SQL Server Express, just the engine, on a 64-bit OS in WoW64 mode. WoW64 mode is described in excruciating detail here.
Express 32BIT\SQLEXPR_x86_ENU.exe

This is for installing the 32-bit version of SQL Server Express, just the engine, on a 32-bit OS.
Express 64BIT\SQLEXPR_x64_ENU.exe

This is for installing the 64-bit version of SQL Server Express, just the engine, on a 64-bit OS.
ExpressAdv 32BIT\SQLEXPRADV_x86_ENU.exe

This is for installing a 32-bit engine and advanced services on a 32-bit operating system. "Advanced services" are explained here.
ExpressAdv 64BIT\SQLEXPRADV_x64_ENU.exe

This is for installing a 64-bit engine and advanced services on a 64-bit operating system. "Advanced services" are explained here.
ExpressAndTools 32BIT\SQLEXPRWT_x86_ENU.exe

This is for installing a 32-bit engine and tools (most importantly SSMS and Profiler) on a 32-bit operating system. "Express With Tools" is explained here.
ExpressAndTools 64BIT\SQLEXPRWT_x64_ENU.exe

This is for installing a 64-bit engine and tools (most importantly SSMS and Profiler) on a 64-bit operating system. "Express With Tools" is explained here.
LocalDB 32BIT\SqlLocalDB.msi

This is for installing LocalDB on a 32-bit operating system. LocalDB is described here.
LocalDB 64BIT\SqlLocalDB.msi

This is for installing LocalDB on a 64-bit operating system. LocalDB is described here.
MgmtStudio 32BIT\SQLManagementStudio_x86_ENU.exe

This is for installing a standalone Management Studio on a 32-bit operating system.
MgmtStudio 64BIT\SQLManagementStudio_x64_ENU.exe

This is for installing a standalone Management Studio on a 64-bit operating system.

score 6 · Accepted Answer · edited Jun 15 '20 at 09:05

6

Did you refer to Details ? It covers all the details.

MgmtStudio 32BIT\SQLManagementStudio_x86_ENU.exe

MgmtStudio 64BIT\SQLManagementStudio_x64_ENU.exe

These are standalone installations for SSMS - a GUI tool to manage sql server.

edited Jun 15 '20 at 09:05

Community

1

answered Dec 02 '15 at 19:12

Kin Shah

62,545
6
124
245

Differences between the different installers of SQL Server 2014 Express

2 Answers2