SQL Server 2005 Installation Illustration tutorial (Windows)

Due to work needs, long time not installed SQL Server2005, today installed a bit, hereby write down the installation steps to leave notes.

Preparation before installation:

Install IIS first, and then install SQL Server2005

First, installation

Click Install, such as:

Select the number of operating system bits

In the start interface of SQL Server 2005, there are 2 options:

x86-based operating systems (8)

x64-based operating systems (6)

x86 here is the meaning of the 32-bit operating system, x64 is the meaning of 64-bit operating system.

In the start interface of SQL Server 2005, you will need to select the appropriate SQL Server 2005 based on the number of bits of your computer's operating system. Because my system is 32-bit XP, I chose "x86 based operating system (8)"

After selecting a version of the operating system, or staying in the "Start" screen, the following options appear

As needed, we only need to select Click Server Components, tools, Books Online, and example (C). Such as:

Go to the End User License Agreement screen, tick the "I accept the license agreement and terms" checkbox and click "Next"

After clicking "Install", continue.

When the component installation is complete, click Next to continue.

At this point the software appears above, stating that the software is starting to install the important components, please click "Next" to continue.
The software starts checking the entire operating environment and is suitable for "SQL2005" operation

When the check is complete, the above screen will appear.

Here I strongly recommend that in this test need to fully meet the requirements!
If you cannot meet the requirements, please review the report and exit the installation of the "SQL2005" software.
After you complete the components that are not installed, install the "SQL2005" software.
Please click "Next" to continue.

Please click "Next" to continue.

Please user select the installation "component" you need, in order to fully explain, I have put so the component selection. If the user also needs detailed component descriptions, you can click on the "Advanced" button and then select. The Advanced button also has the installation directory selection for the software. Users who are in need can choose their own, and this will not unfold.
Please click "Next" to continue.

Please click "Next" to continue.

I also chose the "built-in Account" option.
If you have a user with a DC environment, you can select "Domain user account"
Please click "Next" to continue.

This meeting is more important, this is the password to enter the database management. Please enter the information strictly according to the marked place on the screen.
Special reminder: This password is the database administrator password, very important. If lost, the consequences are unthinkable. Unless the database is not.
When the settings are complete, click Next to continue.

Please click "Next" to continue.

No need to select items, please click "Next" to continue.

Please click "Install" to continue.

The above screen shows that the software has been installed, users please click "Next" to continue.

At this point the software will appear above the information, this is installed after the completion of the report information, in fact, there is no actual things, please click "Done".
The entire installation interface of the software will exit.

The system returns to the desktop.

Second, verify that SQL Server 2005 is installed successfully

1. Click the Start menu, select the Microsoft SQL Server 2005 menu in all Programs, and then click SQL Server Managerment Studio.

2. SQL Server managerment Studio tip: The environment is being configured for the first time use. This may take a few minutes.

3. Go to the "Connect to Server" interface, authentication select "SQL Server Authentication", enter "sa" in the login name, enter the password that you configured when you just installed SQL Server 2005, and then click the Connect button.

4. During the connection process, SQL Server Managerment Studio does not have any error prompts to enter the SQL Server Managerment Studio main interface, stating that SQL Server 2005 installation succeeded!

To this, the database installation is complete and can start normally.

SQL Server 2005 Installation Illustration tutorial (Windows)