SQL Server 2005 Installation Illustration tutorial (Windows)

Source: Internet
Author: User
Tags microsoft sql server 2005 administrator password

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)

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.