How to Install SQL Server 2005 Express

2014/07/18 12:27

SQL Server 2005 Express (32bit) Download

SQL Server 2005 Express (64bit) Download

SQL Server 2005 Express is provided by Microsoft for free. AAMail combined the optimal design of database + files storage structure. The account information and decode content of the mails are stored in the database, but the original mails and attachments are still stored via file storage, which guaranteed performance and greatly reduced the demand for database capacity. Thus, though SQL Server 2005 Express's database physical file size is limited to 4G, and there are some function and performance limitations, it is still suitable for the enterprises which do not have too much users and mails.

You can install SQL Server 2005 Express first, and then upgrade to SQL Server 2005 Standard Edition or Enterprise Edition according to your needs. SQL Server 2005 requires .Net environmental support. If your OS is Windows 2000 or XP, you must install .Net environment before installing SQL Server 2005. If your OS is Windows 2003 or above, then you can install SQL Server 2005 directly.

1) Download SQL Server 2005 Express, double click the installation package, it will pop up the "Microsoft SQL Server 2005 Setup" dialog box, then click the "Next" button (Figure 1-1).

Microsoft SQL Server 2005 Setup

Figure 1-1

2) Wait while the system is checked for potential installation problems, and then click the "Next" button (Figure 1-2).

System Configuration Check

Figure 1-2

3) Type the "Name" and "Company" into their corresponding edit boxes, and then click the "Next" button (Figure 1-3).

Registration Information

Figure 1-3

4) It will pop up the "Microsoft SQL Server 2005 Express Edition Setup - Feature Selection" dialog box, then click the "Next" button (Figure 1-4).

Feature Selection

Figure 1-4

5) Set the authentication mode. Pay attention to select the "Mixed Mode (Windows Authentication and SQL Server Authentication)" radio button, enable the "user name + password" authentication mode, and specify the sa logon password (Figure 1-5).

Authentication Mode

Figure 1-5

6) Keep the default settings, and then click the "Next" button (Figure 1-6).

Configuration Options

Figure 1-6

7) Keep the default settings, and then click the "Next" button (Figure 1-7).

Error and Usage Report Settings

Figure 1-7

8) Click the "Install" button (Figure 1-8).

Ready to Install

Figure 1-8

9) The installation is complete, click the "Finish" button (Figure 1-9).

Finish

Figure 1-9

Up to this point, the installation of SQL Server 2005 Express is complete, and then you can begin installing AAMail. Please note that, for SQL Server 2005 Express data source, you need to change the default "(local)" to "machine name\SQLExpress". This is because the instance name of 2005 Express installed by default is different with SQL Server 2000, and SQL Server 2000 default data source can use "(local)".

For details of SQL Server 2000 installation steps, please refer to "SQL Server 2000".

For details of SQL Server 2008 installation steps, please refer to "SQL Server 2008 Installation Steps".