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

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

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

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.