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

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

• Microsoft SQL Server 2008 R2 Express with Service Pack 2 is a free, feature-rich edition of SQL Server that is ideal for learning, developing, powering desktop, web & small server applications, and for redistribution by ISVs.
  
  Key Features Offered By SQL Server 2008 R2 SP2 Express:
  • 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
  
  SQL Server 2008 R2 SP2 Express Editions:
  • 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 SP2 Management Studio Express
  
  Free, easy-to-use graphical management tool for configuring, managing, and administering SQL Server 2008 R2 SP2 Express. It can also manage instances of the SQL Server Database Engine created by any edition of SQL Server 2008 R2 SP2.
  
  Customers looking to download SQL Server Express and SQL Server Management Studio Express for the first time, please download the bundle: SQL Server 2008 Express with Tools.
  
  KB article 2630458 provides additional information about key fixes in SQL Server 2008 R2 SP2 for all SQL Server Editions. To learn more about SQL Server 2008 R2 SP2 please review SQL Server 2008 R2 SP2 Release Notes.
  
  

Files

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

File	SHA1 Hash	Size
SQLEXPR32_x86_ENU.exe	2646a04848d46113d5fe6e54254e07878473a3c5	97.16 MB
SQLEXPRADV_x64_ENU.exe	70cfb80a66f507a6229030b14acfcfeeb38701eb	1,007.17 MB
SQLEXPRADV_x86_ENU.exe	bd4fc2e4994c4c235910eb1bb36998fd3dec94da	892.82 MB
SQLEXPRWT_x64_ENU.exe	68b9ba1c47800e4fac30e1a1b0d40495599f2c71	339.78 MB
SQLEXPRWT_x86_ENU.exe	609728bba7048b575c14a33bf9c3e7168a415d51	317.69 MB
SQLEXPR_x64_ENU.exe	e768a3b70e3f3b596effa9f57d812f95c0a0506b	122.11 MB
SQLEXPR_x86_ENU.exe	6ce34f57a13e0ded95caf4405fad133e859ade30	110.15 MB
SQLManagementStudio_x64_ENU.exe	d6a9411063f4e150546bf63a8a229a55a11af055	160.84 MB
SQLManagementStudio_x86_ENU.exe	7d022e4da0b340af5049ae6edcfbdb66ffa21a5b	158.08 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 Memory:
  • 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:
  
  
  • 2.2 GB of Disk Space
  
  
  • Processors:
  
  X86:
  
  • Pentium III-compatible processor or faster (Processor Speed - 1.0 GHz or faster)
  
  X64:
  
  • Minimum: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support (Processor Speed - 1.0 GHz or faster)
  
  IA64:
  
  • Itanium processor or faster (Processor Speed - 1.0 GHz or faster)
  Limitations : SQL Server Express supports 1 physical processor, 1 GB memory, and 10 GB storage

• Prerequisites
  To install or update SQL Server 2008 R2 SP2 one will need adminstrative rights on the computer.
  
  
  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 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 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. Known issues may be found in the SQL Server 2008 R2 SP2 Release Notes.