Ultra-detailed sql2005 schematic installation of the entire process 1th/2 page _mssql2005

Objective:

[Learn SQL SERVER 2005 Series] prepare to put some of the learning 2005 of the experience sorted out, and you share, learn together to improve.
sql2005 Lite version Download

Microsoft SQL Server 2005 Simplified Chinese Development Edition

SQL Server 2005 Simplified Chinese Enterprise Edition
Installation Preparation:
1. Choose between versions of SQL Server 2005
Most businesses choose between three SQL Server versions: SQL Server Edition, SQL Server Standard Edition, and SQL Server Enterprise Workgrou P Edition. Most businesses choose these versions because only Enterprise Edition, Standard Edition, and Workgroup Edition can be installed and used in a production server environment.
In addition to Enterprise Edition, Standard Edition, and Workgroup Edition, SQL Server 2005 also includes SQL Server, Developer Edition, and SQL Se RVer the Edition Express. The following paragraphs describe each of these versions, and suggest which version should be used when.
2, software and hardware requirements
2, 1 network software Requirements:
Separate named instances and default instances support the following network protocols: Shared Memory, Named pipes, TCP/IP, VIA
2, 2 Internet requirements

Internet Information Services (IIS)

Installing Microsoft SQL Server Reporting Services (SSRS) requires IIS 5.0 or later.

installation program Support software
SQL Server Setup requires Microsoft Windows Installer 3.1 or later and Microsoft Data Access Component (MDAC) 2.8 SP1 or later. You can download the MDAC 2.8 SP1 from this Microsoft Web site.
SQL Server Setup installs the following software components that are required for this product:
Microsoft Windows. NET Framework 2.0
Microsoft SQL Server Native clients
Microsoft SQL Server Installer support files
Hardware requirements
SQL SERVER 2005 hardware requirements relative to 2000来 to improve a grade, remember that 2000 of the enterprise version of memory recommended only 128M, the minimum 64M is enough.

SQL Server 2005 (32-bit)	Processor Type 1	Processor Speed 2	Memory (RAM)3
SQL Server Enterprise Edition 4 SQL Server Developer Edition SQL Server Standard Edition	Requires a Pentium III compliant processor or higher speed processor	Minimum: + MHz Recommendation: 1 GHz or higher	Minimum: MB Recommendation: 1 GB or greater Maximum: maximum memory of the operating system

Operating system with 2005
This table shows whether the operating system can run its server software for each of the 32-bit versions of SQL Server 2005.

	Enterprise Edition1	Developer Edition	Standard Edition	Workgroup Edition	Express Edition	Evaluation Edition
Windows 2000	Whether	Whether	Whether	Whether	Whether	Whether
Windows Professional Edition SP42,4	Whether	Is	Is	Is	Is	Is
Windows Server SP42	Is	Is	Is	Is	Is	Is
Windows Advanced Server SP42	Is	Is	Is	Is	Is	Is
Windows Datacenter Edition SP42	Is	Is	Is	Is	Is	Is
Embedded Windows XP	Whether	Whether	Whether	Whether	Whether	Whether
Windows XP Home Edition SP2	Whether	Is	Whether	Whether	Is	Whether
Windows XP Professional Edition SP24	Whether	Is	Is	Is	Is	Is
Windows XP Media Edition SP2	Whether	Is	Is	Is	Is	Is
Windows XP Tablet Edition SP2	Whether	Is	Is	Is	Is	Is
Windows 2003 Server SP1	Is	Is	Is	Is	Is	Is
Windows 2003 Enterprise Edition SP1	Is	Is	Is	Is	Is	Is
Windows 2003 Datacenter Edition SP1	Is	Is	Is	Is	Is	Is
Windows 2003 Web Edition SP1	Whether	Whether	Whether	Whether	Is	Whether

Coexistence with 2000
Primary attention is given to instance settings at installation time
2, 7 the entire installation process recommended that you turn off antivirus software.
3, installation
2005 technology very long came to us, due to the work of the relationship has not been able to use, today finally have time to enjoy the elegant demeanor of 2005, the following we detailed diagram of 2005 installation and loading SP1 process.
First put in the CD, boot to the installation directory, and then double-click Setup.exe, the following surface appears

Wait a minute. Eject the Setup Wizard interface:

Click the step, the system began to detect the system configuration (my laptop is 512M memory, prompts the hardware warning, hehe)

Click Next to install the Installation Wizard, and then start the preparation before the installation, such as disk space testing and so on ...

If everything is OK, congratulations, your installation has been half done, then eject the registration interface

Enter the registration number, click Next, and make component selections:

Make your own choice according to your needs, you can point to the advanced after the more detailed settings:

This interface is familiar to people who have installed Office, and different items are selected in the pop-up menu, and the installation path can be changed. The next step, the setting of the instance name, note here, if your machine does not have other SQL Server products, direct point next, if your machine has 2005 previous products, select the default instance when 2005 of the installation disk will upgrade your previous product, if you choose named instance, The 2005 will install a new instance where the previous product is still running independently. I'm here. Named instance is selected according to the situation: SQL2005.

Click Next to make the service account settings,

I select and built-in account: Local System. Select the end of Startup service option as needed and click one step to enter the local account password setting:

Click Next to enter the collation settings:

Click Next to go to some settings on the report server:

do not make any changes after a step,

Next, show all the options you have set:

Click on the installation system to start the configuration selection, and then a step after the installation progress interface

Now you can sit down and have a cup of tea, wait a little while, time depends on your configuration until the following interface appears

The installation is almost over, and after the next point,

at this point can be configured for the perimeter configuration, we can use the process will be configured, so here is not too detailed, click Finish.

Current 1/2 page 12 Next read the full text