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. Before installing MSSQL server 2005 express edition on windows, some prerequisites need to check. First you need to have a windows operating system such as windows vista, windows 7, windows xp pro, or you might have windows 2003 server. If you dont have anyone of those operating system, here some guides how to install windows 2003 server screenshots. Make sure you already install internet information services (IIS) which is your web server to store web pages. After completing install MSSQL server, you may test to create a database name before install cms on your local server. You can install umbraco cms or install dotnetnuke cms which support these database and webserver such as Internet Information Services (IIS). 

How to install SQL server 2005 express edition sp2?

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 build-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!

24 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.”

Click Next.

Remove the check mark in the box next to “Enable User Instances”.

27 Click Next.
28 Click Next.
29 Click Install.
30 Click Next.

Click Finish.