Trace Id is missing

Internet Explorer was retired on June 15, 2022

IE 11 is no longer accessible. You can reload Internet Explorer sites with IE mode in Microsoft Edge.
Internet Explorer is changing to Edge.

Microsoft® SQL Server® 2012 SP1 Express

Microsoft® SQL Server® 2012 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.

Important! Selecting a language below will dynamically change the complete page content to that language.

  • Version:


    Date Published:


    File Name:












    File Size:

    34.8 MB

    29.5 MB

    148.1 MB

    133.1 MB

    128.0 MB

    1.9 GB

    1.8 GB

    1.0 GB

    1.0 GB

    921.6 MB

    939.8 MB

    Microsoft SQL Server 2012 Express with SP1 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 2012 SP1 Express release includes the full version of SQL Server 2012 Management Studio with SP1 instead of SQL Server 2012 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 2012 Management Studio with SP1. 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 2012 Management Studio with SP1, 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 2012 Management Studio with SP1. 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 2012 supported features site.
  • Supported Operating Systems

    Windows 7, Windows 8, Windows Server 2008 R2 SP1, Windows Server 2012, Windows Vista Service Pack 2

    • 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 for the NEW users

    Step 1: Enable Microsoft .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® 2012 Express by clicking the appropriate link earlier, run it, and follow the instructions in the setup wizard to install.

    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® 2012 Express SP1 file to update your current SQL Server 2012 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.

    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® 2012 Express includes both 32-bit and 64-bit versions. SQLEXPR32_x86 is a smaller package that can be used to install SQL Server 2012 Express SP1 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 2012 Express SP1 and supports installation onto only 64-bit operating systems. There is no other difference between these packages. Microsoft® SQL Server® 2012 Express is not supported on IA64 systems.

  • Note: The Microsoft SQL Server 2012 SP1 Express with Advanced Services (SQLEXPRADV_arch_lang id.msi) End User License Agreement (EULA) that is displayed during the setup process is missing terms and conditions related to BING map functionality, which is outlined below for ease of reference. By downloading and installing the .MSI you are accepting these BING map functionality terms.

    "SQL Server Reporting Services Map Report Item. The software may include features that retrieve content such as maps, images and other data through the Bing Maps (or successor branded) application programming interface (the “Bing Maps APIs”). The purpose of these features is to create reports displaying data on top of maps, aerial and hybrid imagery. If these features are included, you may use them to create and view dynamic or static documents. This may be done only in conjunction with and through methods and means of access integrated in the software. You may not otherwise copy, store, archive, or create a database of the content available through the Bing Maps APIs. You may not use the following for any purpose even if they are available through the Bing Maps APIs:
    • the Bing Maps API to provide sensor based guidance/routing, or
    • any Road Traffic Data or Bird’s Eye Imagery (or associated metadata). Your use of the Bing Maps APIs and associated content is also subject to the additional terms and conditions at"

    If you have a specific technical question about Microsoft® SQL Server® 2012 Express SP1 please visit the SQL Server Express Forum .

    - If you have questions about SQL Server Express SP1, visit the SQL Server forums on MSDN .

    - Help improve SQL Server by submitting bugs to Microsoft® Connect .
Follow Microsoft