Install SQL Server 2005 Express

Install and setup
A thorough step-by-step guide to install and configure everything you need to run umbraco 4 on Windows Vista. (including IIS7, SQL Server 2005 Express, SQL Server Management Studio Express, and umbraco 4)

Chapters

• Chapter 1: Introduction
• Chapter 2: Install IIS
• Chapter 3: Install ASP.NET AJAX 1.0
• Chapter 4: Install SQL Server 2005 Express
• Chapter 5: Install SQL Server Management Studio Express
• Chapter 6: Copy Umbraco Files
• Chapter 7: Configure SQL Server 2005 Express
• Chapter 8: Configure IIS Website
• Chapter 9: Configure Umbraco
• Chapter 10: Congratulations!

Install SQL Server 2005 Express

Microsoft SQL Server 2005 Express Edition is the free, easy-to-use, lightweight version of SQL Server 2005. SQL Server Express can be seamlessly upgraded to more sophisticated versions of SQL Server.

1. Download Microsoft SQL Server 2005 Express Edition SP2 from the Microsoft web site at:
   http://go.microsoft.com/fwlink/?LinkId=65212
2. Save the SQLEXPR32.EXE file to your desktop.
3. When downloading has finished, double-click the SQLEXPR32.EXE file on your desktop to start the installation process.
4. Click Run if prompted to allow the application to run.
5. Click Continue if prompted for permission to continue.
6. Place a check mark in the box next to "I accept the licensing terms and conditions".
7. Click Next.
   
8. Click Install.
9. Click Next.
10. Click Next.
11. Click Next.
12. Click Next.
13. Enter your Name and Company.
14. Remove the check mark in the box next to "Hide advanced configuration options".
    
15. Click Next.
16. De-select all Client Components.
    
17. Click Next.
18. Select the radio button next to "Default instance".
    
19. Click Next.
20. Select the radio button next to "Use the built-in System account" and choose Network service.
21. Place a check mark in the box next to "SQL Server" to start the service at the end of setup.
    
22. Click Next.
23. Select the radio button next to "Mixed Mode (Windows Authentication and SQL Server Authentication)".
24. Enter and confirm the sa logon password you will use to connect to SQL Server.
    Note: Do not forget this password!
    
25. Click Next.
26. Select the radio button next to "SQL collations (used for compatibility with previous versions of SQL Server)" and select "Dictionary order, case-insensitive, for use with 1252 Character Set."
    
27. Click Next.
    
28. Remove the check mark in the box next to "Enable User Instances".
    
29. Click Next.
30. Click Next.
31. Click Install.
32. Click Next.
    
33. Click Finish.