Microsoft Download Center Archive

Microsoft® SQL Server® 2014 Service Pack 2 (SP2) Express

  • Published:
  • Version: 12.0.5000.0
  • Category: Service Pack
  • Language: English

Microsoft® SQL Server® 2014 Express is a powerful and reliable free data management system that delivers a rich and reliable data store for lightweight Web Sites and desktop applications.

  • Microsoft SQL Server 2014 Express with SP2 are a free, feature-rich editions of SQL Server that is ideal for learning, developing, powering desktop, web & small server applications, and for redistribution by ISVs. The SQL Server 2014 SP2 Express release includes the full version of SQL Server 2014 Management Studio with SP2 instead of SQL Server 2014 Management Studio Express. For a complete list of supported features in SQL Server Management Studio, see Features in SQL Server Management Studio.

    LocalDB (SqlLocalDB)
    • LocalDB is a lightweight version of Express that has all its programmability features, yet runs in user mode and has a fast, zero-configuration installation and short list of pre-requisites. Use this if you need a simple way to create and work with databases from code. It can be bundled with Application and Database Development tools like Visual Studio and or embedded with an application that needs local databases.
    Express (SQLEXPR)
    • Express edition includes the SQL Server database engine only. Best suited to accept remote connections or administer remotely.
    Express with Tools (SQLEXPRWT)
    • This package contains everything needed to install and configure SQL Server as a database server including the full version of SQL Server 2014 Management Studio with SP2. Choose either LocalDB or Express depending on your needs above.
    SQL Server Management Studio Express (SQLManagementStudio)
    • This does not contain the database, but only the tools to manage SQL Server instances, including LocalDB, SQL Express, SQL Azure, full version of SQL Server 2014 Management Studio with SP2, etc. Use this if you already have the database and only need the management tools.
    Express with Advanced Services (SQLEXPRADV)
    • This package contains all the components of SQL Server Express including the full version of SQL Server 2014 Management Studio with SP2. This is a larger download than “with Tools,” as it also includes both Full Text Search and Reporting Services.


    To learn more about the features supported by the SQL server, please visit the MSDN SQL Server 2014 supported features site.

Files

Status: Live

This download is still available on microsoft.com. The downloads below will come directly from the Microsoft Download Center.

FileSize
ENU/x64/SqlLocalDB.msi
SHA1: aada8f010011f1b469967a4c9b332e3322dac1cf
41.84 MB
ENU/x86/SqlLocalDB.msi
SHA1: 71988fd0d7de8b8252db12ae211d2f8bd736f9de
35.47 MB
SQLEXPR32_x86_ENU.exe
SHA1: 576cfc6178aeb376225e5833a95063beda462ce6
246.13 MB
SQLEXPRADV_x64_ENU.exe
SHA1: a91eb4caf3c9ede82289a0945252ff6fdcb6a74b
1.45 GB
SQLEXPRADV_x86_ENU.exe
SHA1: fbf09e75fdeeccb5f61ff1e329c5d47ce10a1f98
1.42 GB
SQLEXPRWT_x64_ENU.exe
SHA1: 8bbe398a8a2a9f7b018dcd54addca3b8163d49a4
1.07 GB
SQLEXPRWT_x86_ENU.exe
SHA1: 63d0bffe13baf6aeb11f4d0d72f59e01b4a3d86f
1.10 GB
SQLEXPR_x64_ENU.exe
SHA1: 34d7f2bbaf9452a41164156ec37b9a42f814390c
310.03 MB
SQLEXPR_x86_ENU.exe
SHA1: 43045a8a5163bab7f103411c4d7f9beb70bed225
272.81 MB
SQLManagementStudio_x64_ENU.exe
SHA1: fbbca0b6bfc38db1a4c4954f1e8307733043d040
849.85 MB
SQLManagementStudio_x86_ENU.exe
SHA1: f1623511477870b1612394d19ab86ac4653de8d9
828.67 MB

File sizes and hashes are retrieved from the Wayback Machine’s indexes. They may not match the latest versions of files hosted on Microsoft servers.

System Requirements

Operating Systems: Windows 10, Windows 7 Service Pack 1, Windows 8.1, Windows Server 2008 R2, Windows Server 2008 R2 SP1, Windows Server 2012, Windows Server 2012 R2

      • Processor
        • Intel - compatible processor with a minimum speed of 1 GHz or a faster processor
      • RAM
        • Minimum 512 MB for SQL Server Express with Tools, and SQL Server Express with Advanced Services and 4 GB for Reporting Services that installs with SQL Server Express with Advanced Services
      • Hard Disk Space
        • 4.2 GB of Disk Space

      Limitations : Microsoft SQL Server Express supports 1 physical processor, 1 GB memory, and 10 GB storage

    Installation Instructions

    • Installation for the NEW users

      Step 1: EnableMicrosoft .Net Framework 3.5 SP1. and Download and install Microsoft .Net Framework 4.0.

        Note: SQL Server Express (with database engine only) can work with either .NET 3.5 SP1 or .NET 4, there is no need to have both enabled.

      Step 2: Download Microsoft® SQL Server® 2014 Express by clicking the appropriate link earlier, run it, and follow the instructions in the setup wizard to install.
      Note: If downloading using Microsoft Edge in Windows 10, you may be presented with the “Choose Directory for Extracted Files” dialog with a default/proposed path that includes \System32\. If this occurs, please change this path to another location on your system before clicking ‘OK’.

      Installation for the Existing Users

      If you have an existing installation of Express with Tools, SQL Server Management Studio Express, or Express with Advanced Services, and want to add the complete SQL Server Management Studio feature to your Express instance, do the following:

      Step 1: Download the required Microsoft® SQL Server® 2014 Express SP2 file to update your current SQL Server 2014 Express installation by clicking the appropriate link earlier.

      Step 2: Run the file, and follow the instructions in the setup wizard to install. On the Installation Type page, select Add features to an existing instance of SQL Server, and select the instance you would like to update.
      Note: If downloading using Microsoft Edge in Windows 10, you may be presented with the “Choose Directory for Extracted Files” dialog with a default/proposed path that includes \System32\. If this occurs, please change this path to another location on your system before clicking ‘OK’.

      Step 3: On the Feature Selection page, select the Management Tools – Complete check box, and then proceed to complete the installation.

        Note: Microsoft® SQL Server® 2014 SP2 Express includes both 32-bit and 64-bit versions. SQLEXPR32_x86 is a smaller package that can be used to install SQL Server 2014 Express SP2 onto only 32-bit operating systems. SQLEXPR_x86 is the same product but supports installation onto both 32-bit and 64-bit (WoW) operating systems. SQLEXPR_x64 is a native 64-bit SQL Server 2014 Express SP2 and supports installation onto only 64-bit operating systems. There is no other difference between these packages.