Install SQL Server 2005 Express Edition SP2

Install and setup
A step-by-step guide to install and configure everything you need to run umbraco 3.0.x on Windows XP Pro. (including IIS, MSXML, .NET Framework, AJAX, SQL Server 2005 Express, SQL Server Management Studios Express, and umbraco 3.0.x)

Chapters

• Chapter 1: Introduction
• Chapter 2: Install IIS
• Chapter 3: Install .NET 2.0 Framework
• Chapter 4: Install ASP.NET AJAX 1.0
• Chapter 5: Install MSXML
• Chapter 6: Install SQL Server 2005 Express Edition SP2
• Chapter 7: Install SQL Server Management Studio Express
• Chapter 8: Configure SQL Server 2005 Express
• Chapter 9: Install umbraco 3.0.x Files
• Chapter 10: Configure IIS
• Chapter 11: Configure umbraco 3.0.x
• Chapter 12: Congratulations!

Install SQL Server 2005 Express Edition SP2

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. Place a check mark in the box next to “I accept the licensing terms and conditions”.
6. Click Next.
7. Click Install.
8. Click Next.
9. Click Next.
10. Click Next.
11. Enter your Name and Company.
12. Remove the check mark in the box next to “Hide advanced configuration options”.
    
13. Click Next.
14. De-select all Client Components.
    
15. Click Next.
16. Select the radio button next to “Default instance”.
    
17. Click Next.
18. Select the radio button next to “Use the build-in System account” and choose Network service.
19. Place a check mark in the box next to “SQL Server” to start the service at the end of setup.
    
20. Click Next.
21. Select the radio button next to “Mixed Mode (Windows Authentication and SQL Server Authentication)”.
22. Enter and confirm the sa logon password you will use to connect to SQL Server.
    Note: Do not forget this password!
    
23. Click Next.
24. 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.”
    
25. Click Next.
26. Remove the check mark in the box next to “Enable User Instances”.
    
27. Click Next.
28. Remove both check marks.
    
29. Click Next.
30. Click Install.
31. Click Next.
32. Click Finish.