How to install SQL 2005 SQL Server 2005 installation diagram tutorial

The third step is to check the checkbox in the red box, respectively, "Web Core that Internet Information Services can host", &ldquo Web management tools "Web services", here I am not sure "Web management tools & rdqu o; whether it is needed, because I selected their parent node "Internet Information Service" and selected some of its sub-items, multiple choices are more comprehensive than the selection, all of their children need to be selected to display as "&radi" ;”, otherwise it is displayed as “■”, remember, be sure to display it as “√”, the effect is the same as step3! Click OK and the line box will appear.
Open IIS service

If we do not enable IIS function, we will see the following interface when installing SQL Server:
Unable to open IIS service will result in failure to complete SQL Server installation

to this, IIS Even if the function is enabled, let's start installing the SQL Server database software.

The SQL Server 2005 installation file is an ISO image after decompression. It is actually a DVD file. The two CDs are merged together, so your computer needs to install a virtual CD-ROM drive. The virtual CD-ROM drive will not be used first. Baidu, I will not go into details here.

First start the virtual CD-ROM software, load the image of SQL Server 2005, as shown in Figure
Load SQL Server 2005 image

At this point we can see this virtual installation in my computer Disk, as shown in Figure
SQL Server 2005 installation diagram

If it does not run automatically, then we click on the H disk icon to enter the installation, as shown below:
Figure SQL Server 2005 installation interface

Then enter the following screen
Figure for SQL Server 2005 installation next interface

This article navigation

Because the author's computer system is 32-bit, naturally choose x86-based, then click “ server components, tools , Books Online and examples (C) & rdquo;, as shown below:
SQL Server 2005 installation schematic solution

then pop up the dialog box, click & ldquo; Program (R) & rdquo;, as shown:
select the running program

then appears, check the "Introduction License Agreement" and then click Next, as shown in the figure:

The installation program will check the office Need components, click “ Install & rdquo;
Click “Install & rdquo; component installation is complete Click Next

Click “Next” After the installation program will monitor the computer configuration, as shown below:
SQL Server 2005 monitoring computer configuration

This article navigation

The following is the jump to the SQL Server 2005 installer wizard interface, as shown below:
Figure for SQL Server 2005 Setup Wizard

Click “Next&rdquo Enter the system configuration check, as shown below:
SQL Server 2005 system configuration check

We see that all projects are successful, if not enabled II before If the S function is used, the picture that appears will be the same as before. After the above is completed, we continue to click “Next” & rdquo;, as shown below:
SQL Server 2005 system personalization interface

After entering the company name, after completing, continue to click <; next & rdquo; operation Enter the component selection installation interface, as shown below:
SQL Server 2005 component installation selection

This article navigation

It is important to note that if your interface has only the last checkbox, all others are grayed out. That means there is a problem with your version, not the development version, please give up the installation immediately, download the development board from the download address I gave above to install. After selecting all, click “Next”
SQL Server 2005 function selection

Installed to the system disk by default, we can click Advanced to modify, click “Browse(R)”, we can ;C” modified into "D”, click “ OK” can be, as shown below:
Modify the installation of SQL Server 2005 to the D drive

Click “Next”

I chose the default instance”, you can also choose “name instance", click “Next”
Select SQL Server 2005 default instance

every default, click &ldquo The next step is as shown below:
SQL Server 2005 service account settings

Because other programs may also connect to the database, select “mix mode”, type sa password, click “Next ”, as shown below:
SQL Server 2005 authentication mode settings

The following has been the default, all the way to choose the next step, as shown below:
SQL Server 2005 ready to install

#SQL Server 2005 installation completed #e#

The long installation is just about to start, click “Install", as shown below:
SQL Server 2005 installation process begins

The above installation process will be very time consuming, please wait slowly. In the middle of the installation, the first pop-up window encountered, click & ldquo; Run the program (R) & rdquo;, as shown below:
select the running program

installed for a while, the results pop up, continue to click & ldquo; run the program (R)”
Select to continue running the program

All modules are installed, click “Next”, as shown below:
SQL Server 2005 installed

to Here SQL Server 2005 installation is coming to an end, click “Complete (F)”, as shown below:
SQL Server 2005 installation completed

#SQL Server 2005 installation and use details #e#

The following picture shows the interface of the running program after the installation is successful.
SQL Server 2005 program interface

This interface is logged in to the database just installed, because we installed the default instance & rdquo; It is the computer name, “IceWee-PC” is my computer name, click on the link to log in to the database. I personally feel that there are two points to pay attention to when installing SQL Server. One is to enable the IIS function, and the other is to select the installation version. The first time I made a mistake, the next enterprise version, the result can only be installed. Workstation components, Books Online, and development tools & rdquo;.

About other computers in the LAN to connect to this database I also encountered a little trouble, toss for a long time to get it. First of all, system firewalls and other third-party firewalls, such as 360, QQ computer housekeeper, anti-virus software, etc., this is common sense. Secondly, use the telnet command to connect. If you can connect, you can definitely access it. The command format: telnet database IP 1433

will not appear on the following screen, as shown below:
Telnet database IP

in order to telnet my database, toss for a long time! Toss for a long time! Haha, finally finally solved. From the beginning - "Microsoft SQL Server 2005 -" configuration tool - "SQL Server Configuration Manager, in the pop-up window, click the following picture to open the left tree, as shown below:
SQL 2005 how to install SQL Server 2005 installation diagram Tutorial

We see the "TCP/IP" protocol in the red box is "disabled" status, we can enable it, and then restart SQL Server to telnet!

This article navigation