Win7 (Windows 7) system installation SQL2005 (SQL Server 2005) graphics tutorial

Because of the work required, today you will install SQL Server 2005 on your computer. Previous projects are using ORACLE,MS database is not really how to use, the installation of Oracle has been pro, but installed SQL Server seems to have a little trouble, so log down to stay in reserve.

-------------------------------------------------------------------------------------------------

Operating system: Microsoft Windows 7 Ultimate Edition (32-bit)

Database version: SQL Server 2005 Simplified Chinese Development Board

Database download Link: http://pan.baidu.com/share/link?shareid=322740&uk=268517599 (address updated 2013-03-09)

-------------------------------------------------------------------------------------------------

The person who installed SQL Server might know that some of its services depend on IIS, so to ensure a smooth installation of the database, enable IIS services first! Win7 is better than XP: The ability to enable IIS does not require the use of the system installation disk, as long as it is enabled in the Control Panel,

Step1

Step2

The third step is to check that the complex options in the red box are "Internet Information Services hosted Web Core", "Web management Tools", and "World Wide Web Services", where I'm not sure if the Web management tool is required, Because I selected their parent node "Internet Information Service" After selecting some of its children, multiple selection is more than the overall selection, you need to select their children all to show as "√", otherwise displayed as "", remember, must be displayed as "√" only line, the effect is just like step3! When you click OK, you will see a line face box.

If we do not enable IIS features, you will encounter the screen when you install SQL Server later

To do this, the IIS feature, even if enabled, starts the installation of SQL Server

installation files after decompression is an ISO image, in fact, is a DVD file, the two discs merged together, so your computer needs to install Virtual CD-ROM, virtual CD-ROM will not be used first Baidu, I will not be here to repeat.

Start the virtual optical drive software first, load the SQL Server image in,

At this point we can see this virtual installation disk in My Computer,

If it does not run automatically, then we click on the H-disk icon to enter the installation

Immediately after entering the following screen

My system is 32-bit, I have natural selection based on x86, then click on "Server components, tools, Books Online and examples (C)"

Immediately after the popup dialog box, click "Run Program (R)"

Then appear, tick, next

The installer will check the required components and click "Install"

Click "Install"

After clicking "Next", the installer will monitor the computer configuration

Jump to Installation Wizard immediately

Click "Next"

We see that all of the projects are successful, and if the IIS feature was not enabled before, the screen that appears is the previous one, click "Next"

After entering your company name, click "Next"

It is important to note that if your interface has only the last check box optional, the others are Gray is not optional, that means you have a problem with the version, not the development version, please immediately discard the installation, from the above I gave the download Development Board to install. Click "Next" after selecting all

The default installation to the system disk, we can click Advanced to modify, click "Browse (R)"

I changed "C" to "D" and clicked "OK".

Click "Next"

I choose "Default instance", or "named instance", click "Next"

All by default, click "Next"

Because other programs may also connect to the database, select "Mixed Mode" and type the sa password and click "Next"

By default, click "Next"

By default, click "Next"

By default, click "Next"

The long installation was just about to start, click on "Install"

It's a time-consuming process, so wait.

Install halfway, encounter the first pop-up window, click "Run Program (R)"

Install for a while, the results pop up again, continue to click "Run Program (R)"

All modules are installed, click "Next"

This is the end of the page, click "Finish (F)"

This interface is logged into the database just installed, because we use the "default instance", that is, the computer name, "ICEWEE-PC" is My Computer name, click the connection to log in to the database.

I personally feel that there are two points to be aware of installing SQL Server, one is the IIS feature is enabled, and the other is to choose to install the version, I first was wrong, under the Enterprise version, the results
You can only install workstation components, Books Online, and development tools.

About the other computers in the LAN to connect to this database I also met a little trouble, toss a half a day to fix.

First, the system firewall and other third-party firewalls, such as 360, QQ computer Butler, anti-virus software, this is common sense

Next, use the Telnet command to connect, if you can connect, then you can definitely access the command format:

Telnet database IP 1433

The following screen will appear when you are not connected

Just to be able to telnet on my database, toss for a half a day Ah! Toss for a half day! Haha, finally solved.

Start-"Microsoft SQL Server 2005-" Configuration Tool-"SQL Server config Manager

In the pop-up window, open the left tree by point

We see that the "TCP/IP" protocol in the Red box is "disabled", and when we turn it on, then restart SQL Server to Telnet!

Win7 (Windows 7) system installation SQL2005 (SQL Server 2005) graphics tutorial