SQL Server 2008 Express on Windows Server 2003/2008 Howto

SQL Server 2008 Express is a scaled down, free edition of SQL Server 2008. This article describes how to install SQL Server 2008 Express on Windows Server 2003 or Windows Server 2008. Before starting, make sure to install the items listed below.

For Windows Server 2003, you’ll also need

While for Windows Server 2008, you’ll also need

The download links for the editions of SQL Server 2008 Express are listed below.

SQL Server Installation Center

SQL Server Installation Center1. In SQL Server Installation Center, click Installation.
SQL Server Installation Center2. Click New SQL Server stand-alone installation or add features to an existing installation.

SQL Server 2008 Setup

Setup Support Rules1. In Setup Support Rules, click Ok.
Setup Support Files2. In Setup Support Files, click Install.
Setup Support Rules3. Setup Support Rules, click Next.
Product Key4. In Product Key, click Next.
License Terms5. In License Terms, check I accept the license terms and click Next.
Feature Selection6. In Feature Selection, check the features you want to install and click Next.
Instance Configuration7. In Instance Configuration, click Next.
Disk Space Requirements8. In Disk Space Requirements, click Next.
Server Configuration9. In Server Configuration, specify the Account Name and Password for the SQL Server Database Engine service and click Next. Learn how to create a new user account.
Database Engine Configuration10. In Database Engine Configuration, specify the Authentication Method to use and the SQL Server administrators and click Next.
Error and Usage Reporting11. In Error and Usage Reporting, click Next.
Installation Rules12. In Installation Rules, click Next.
Ready to Install13. In Ready to Install, click Install.
Installation Progress14. The setup process will now begin.
Installation Progress15. After the setup process finishes, click Next.
Installation Complete16. Finally, click Close.

Write a Comment

Take a moment to comment and tell us what you think. Some basic HTML is allowed for formatting.

Reader Comments

[…] (IIS) 7 or IIS 6 (for Windows Server 2003). Install any version of SQL Server. You can use the free SQL Server 2008 Express. Install Windows SharePoint Services 3.0. Configure Windows SharePoint Services […]

This is brilliant. LOve the way you have made this idiot proof (i.e. perfect for me).