SQL Server 2008 Installation Steps

When you install SQL Server 2008 on Windows 2008 OS (If you haven't installed Microsoft.NET Framework 3.5), then there will be the following error (Figure 1-1).

Figure 1-1

For details of Microsoft.NET Framework 3.5 installation, please refer to "Microsoft.NET Framework 3.5 Components".

The SQL Server 2008 installation steps are as follows.

1) Double click the "setup" in SQL Server 2008 installation package.

2) In the pop up "Program Compatibility Assistant" dialog box, click the "Run program" button (Figure 1-2).

Figure 1-2

3) In the pop up "SQL Server Installation Center" dialog box, you can choose the items which need to be detected according to your own needs (Figure 1-3).

Figure 1-3

4) Click the "Installation", and then click the "New SQL Server stand-alone installation or add features to an existing installation" on the right side of the dialog box (Figure 1-4).

Figure 1-4

You can also upgrade from SQL Server 2000/2005 to SQL Server 2008 here.

5) In the pop up "Program Compatibility Assistant" dialog box, click the "Run program" button (Figure 1-5).

Figure 1-5

6) In the pop up dialog box, click the "OK" button (Figure 1-6).

Figure 1-6

If there are any errors during the detection processes, then the prompt will not be the "Failure 0". Please pay attention to find the errors and then solve them.

7) Specify a free edition or enter the product key, and then click the "Next" button (Figure 1-7).

Figure 1-7

8) Select the "I accept the license terms" check box, and then click the "Next" button (Figure 1-8).

Figure 1-8

9) In the pop up dialog box, click the "Install" button (Figure 1-9).

Figure 1-9

10) Wait for the installation.

11) Confirm the detection items all passed, and then click the "Next" button (Figure 1-10).

Figure 1-10

12) In the pop up "Feature Selection" dialog box, select SQL features (Figure 1-11, the check boxes in red frames must be selected). Click the "..." button to select the installation path, and then click the "Next" button.

Figure 1-11

13) In the pop up "Instance Configuration" dialog box, normally select the "Default instance" radio button, and then click the "Next" button (Figure 1-12).

Figure 1-12

14) In the pop up "Disk Space Requirements" dialog box, view the required disk space for installing SQL Server 2008, and then click the "Next" button (Figure 1-13).

Figure 1-13

15) In the pop up "Server Configuration" dialog box, set the "SQL Serve Agent" and "SQL Server Database Engine" account names as the System account (NT AUTHORITY\SYSTEM), and then click the "Next" button ( Figure 1-14).

Figure 1-14

16) In the pop up "Database Engine Configuration" dialog box, select the "Mixed Mode (SQL Server authentication and Windows authentication)" radio button, and then enter the password, and click the "Next" button (Figure 1 - 15).

Figure 1-15

Click the "Add Current User" button to add the system account.

17) In the pop up "Error and Usage Reporting" dialog box, normally keep the default settings, and then click the "Next" button (Figure 1-16).

Figure 1-16

18) Check the factors which prevent the SQL Server 2008 installation, after confirmed, click the "Next" button (Figure 1-17).

Figure 1-17

19) Check the required features of SQL Server 2008, after confirmed, click the "Install" button (Figure 1-18).

Figure 1-18

20) The installation progress of SQL Server 2008 (Figure 1-19).

Figure 1-19

21) After the installation is complete, click the "Next" button (Figure 1-20).

Figure 1-20

22) Click the "Close" button to exit the SQL Server 2008 Setup (Figure 1-21).

Figure 1-21

23) Up to this point, the installation of SQL Server 2008 is complete.

24) Click the "Start" button -> "All Programs" -> "Microsoft SQL Server 2008" -> "SQL Server Management Studio". It will open the SQL Server 2008 Management Studio Express (Figure 1-22).

Figure 1-22

25) SQL Server 2008 Management Studio interface (Figure 1-23).

Figure 1-23

It is very easy to install SQL Server 2008. You can follow the above installation steps.

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

For details of SQL Server 2005 installation steps, please refer to "How to Install SQL Server 2005 Express".

Related: