Microsoft® SQL Server® 2008 R2 SP1 - Express Edition

Select Language:
Microsoft SQL Server 2008 R2 Express with Service Pack1 is a free and feature-rich database for developing and deploying
  • Note:There are multiple files available for this download.Once you click on the "Download" button, you will be prompted to select the files you need.


    File Name:








    Date Published:


    File Size:

    93.1 MB

    117.5 MB

    106.1 MB

    980.9 MB

    867.0 MB

    329.9 MB

    308.4 MB

      Microsoft SQL Server 2008 R2 Express with Service Pack1 is a free, feature-rich edition of SQL Server that is ideal for learning, developing and powering desktop, web and small server applications, and for redistribution by ISVs.

      Top Features
      • Supports stored procedures, triggers, functions, and views
      • Store all kinds of business data with native support for relational data, XML, FILESTREAM and spatial data
      • Improved performance, usability, visualization, in addition to integration with the Microsoft 2007 Office System in SQL Server Reporting Services
      • Simplify development efforts by leveraging existing T-SQL skills, ADO.NET Entity Framework and LINQ
      • Closely integrated with Visual Studio and Visual Web Developer
      Three Editions of SQL Server 2008 R2 SP1 Express:
      • SQL Server 2008 R2 Express with Tools

      • Core edition of Express that supports development. Includes SQL Server 2008 Database Engine and SQL Server Management Studio Express
      • SQL Server 2008 R2 Express with Advanced Services

      • Extends SQL Server 2008 Express with tools to include support for Integrated Full-text Search and Reporting Services
      • SQL Server 2008 R2 Express (Runtime Only)

      • Includes the SQL Database Engine only and is designed for deployments and ISV redistribution

      SQL Server 2008 R2 SP1 Management Studio Express

      Free, easy-to-use graphical management tool for configuring, managing, and administering SQL Server 2008 R2 SP1 Express. It can also manage instances of the SQL Server Database Engine created by any edition of SQL Server 2008 R2 SP1.
      Download SQL Server 2008 R2 SP1 Management Studio Express: x86 x64

      Note: This separate download is designed for customers who have previously installed SQL Server 2008 Express (Runtime Only). If you are looking to download SQL Server Express and SSMSE for the first time, please download the above bundle: SQL Server 2008 Express with Tools.
      For a list of new features and improvements that are included in SQL Server 2008 R2 SP1, review the What's New section in SQL Server 2008 R2 SP1 Release Notes .
  • Supported Operating System

    Windows 7, Windows Server 2003, Windows Server 2008, Windows Server 2008 R2, Windows Vista

        • Windows Server 2003, Windows Server 2008, Windows Server 2008 R2, Windows 7, Windows Vista, Windows XP
      • Processor
        • Pentium III - 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
        • 2.2 GB of Disk Space

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

      Note: For more information about Hardware and Software Requirements for Installing SQL Server 2008 R2, Please visit SQL Server 2008 R2 Requirement .

    • Note: You must have administrative rights on the computer to install SQL Server Express.
        Step 2: Download SQL Server Express by clicking the SQLEXPR.EXE or SQLEXPR32.EXE link later on this page. To start the installation immediately, click Run. To install SQL Server Express at a later time, click Save.

      Note: SQLEXPR32.EXE is a smaller package that can be used to install SQL Server Express on 32-bit operating systems only. The larger SQLEXPR.EXE package supports installing onto both 32-bit and 64-bit (WOW install) operating systems. There is no other difference between these packages. Step 3: Follow the installation instructions provided in the Readme. For known issues, review the Release Notes.
    • he following describe additional use terms for the software. This supplemental and the license terms for the software apply to your use of the software. If there is a conflict, this supplement applies.

      By using the software as described below, you accept these terms. If you do not accept them, you do not have the rights below.

      1. Term - The term of the software license terms agreement is extended to June 30, 2013, or commercial release of the software, whichever is first.

      2. Time-Sensitive Software - The software may include time-sensitive software. The time-sensitive portions of the software may stop functioning prior to the expiration of the term. Please refer to the software license terms for details.

      3. Other Terms - Except as stated in this supplement, the software license terms apply to your use of the software.

      If you have questions about SQL Server® 2008 R2 SP1, Please visit the SQL Server® 2008 R2 forums on MSDN.
      Your feedback is important. Help improve SQL Server 2008 R2 by submitting bugs to Microsoft® Connect.