Legacy Update: Get back online, activate, and install updates on your legacy Windows PC

Microsoft SQL Server 2008 R2 Express with Service Pack1 is a free and feature-rich database for developing and deploying

• 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 .

Files

Status: Deleted This download is no longer available on microsoft.com. The downloads below are archives provided by the Internet Archive Wayback Machine from the Microsoft Download Center prior to August 2020.

File	Size
SQLEXPR32_x86_ENU.exe SHA1: 4785985f257d77b9fa4dde8715d50e6018f11a0c	92.92 MB
SQLEXPRADV_x64_ENU.exe SHA1: 523d36c6d8231ba054ab3ce0fe4cda38ccbb5846	979.50 MB
SQLEXPRADV_x86_ENU.exe SHA1: 613fa2e38ea6508b06e9e60100307ceedfd66078	865.74 MB
SQLEXPRWT_x64_ENU.exe SHA1: f4f6eded68fad918f5976d00dcec87743ef428ce	329.16 MB
SQLEXPRWT_x86_ENU.exe SHA1: 903a2ade29a7183446bc4a33496d477c10a7ee2e	307.78 MB
SQLEXPR_x64_ENU.exe SHA1: 1ebb3cd459e5b8f15acd1d60f3f27a48a7d39427	117.20 MB
SQLEXPR_x86_ENU.exe SHA1: 5c330ff0ea16fff5c93485acfebb6173a0243e84	105.89 MB

• • 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 1: Install Microsoft .NET Framework 2.0 or later from the Microsoft Download Center .
  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.