Everyone's favorite small-footprint database is finally here!  There are lots of reasons to be excited.  The download locations are listed below: 

SQL Server 2005 Compact Edition Developer SDK

SQL Server 2005 Compact Edition Developer SDK contains the files required for installing SQL Server 2005 Compact Edition on mobile devices, desktop and tablet PC. It also has the Help File, and the Header files for native development, and the Northwind sample application.

SQL Server 2005 Compact Edition Tools for Visual Studio 2005

The download is installed after the installation of Visual Studio 2005 SP1 and updates the Smart Device Development components in Visual Studio 2005 SP1 with the SQL Server 2005 Compact Edition design time UI/Dialogs, device CAB files, and includes new features like Click Once support.

SQL Server 2005 Compact Edition Server Tools

Microsoft SQL Server 2005 Compact Edition Server Tools updates the servers running IIS to support connectivity solutions from SQL Server 2005 Compact Edition database on a mobile device or a desktop or a tablet PC to database servers running SQL Server 2000 SP3a and above versions.

 SQL Server Compact Edition Runtime

Microsoft SQL Server 2005 Compact Edition is the compact database for rapidly developing applications in both native and managed environment that extend enterprise data management capabilities to desktop applications.