SQL SERVER 2000 installation tutorial graphics and text detailed _mssql

Note: Windows XP cannot be installed in Enterprise Edition. WIN2000\WIN2003 Server Installation Enterprise Edition

Hardware and operating system requirements

The following table describes the hardware requirements for installing Microsoft SQL Server 2000 or SQL Server client management tools and libraries. Hardware Minimum requirements computer

Pentium 166 MHz or higher.

Memory (RAM) at least MB, recommended 128 MB or more. According to the author's experience, memory capacity and data capacity to maintain a ratio of 1:1, so as to better play its performance. Hard disk space requires about 500MB of program space, as well as a data space monitor that reserves 500M

You need to set 800x600 mode to use its graphical profiling tool

The following table describes the operating systems that you must install to use various versions or components of Microsoft SQL Server 2000.

SQL Server version or component
The operating system requires an enterprise version of Microsoft Windows NT Server 4.0, Microsoft Windows NT Server 4.0 Enterprise Edition, Windows Server, Windows Advanced Ser Ver and Windows Data Center Server. (All versions need to be installed IE5.0 above version Browser) Standard Edition Microsoft Windows NT Server 4.0, Windows Web server, Microsoft Windows NT Server Enterprise Edition, Windows 200 0 Advanced Server and Windows Data Center server. Personal Edition Microsoft Windows Me, Windows 98, Windows NT Workstation 4.0, Windows Professional, Microsoft Windows NT Server 4.0, Wi Ndows Server and all the more advanced Windows operating systems.

Note: Some features of SQL Server 2000 require more than Microsoft Windows Server version to run. So you install Windows Server 2000 (recommended for advanced version), you can learn and use more features to SQL Server 2000, and enjoy better performance.

SQL Server 2000 installation order:

1. Install SQL Server first (servers install Enterprise Edition)
2, Installation SQL2KSP4 (http://www.jb51.net/softs/2188.html)
3, SQL Server sp4+ Simplified Chinese version ③ (fixed Microsoft's a very serious security vulnerability) (Http://xiazai.jb51.net/server/SQL2000-KB948110-v8.00.2050-x86x64-CHS.exe)

Second, the detailed installation process

When you insert the Enterprise installation CD into the optical drive, the following prompt box appears. Select "Install SQL Server 2000 Components" and select "Install Database Server" after the next page appears.

Select Next, and then select Local computer to install.

In the Install Selection window, select Create a new instance of SQL Server .... For the first-time users, you should choose this installation mode and do not need to use the advanced options to install. The contents of the advanced options can be adjusted after the installation is complete.

In the User Information window, enter user information and accept the software license agreement.

In the Installation Definition window, select the Server and Client Tools option to install. We need to install both the server and the client, so that on the same machine, we can complete all the relevant operations, which is useful for us to learn about SQL Server. If you already have SQL Server installed on other machines, you can install only the client tools for access to SQL Server on other machines.

In the Instance Name window, select the instance name for default. The name of this SQL Server will be the same as the name of the Windows 2000 Server. For example, the author's Windows Server name is "Darkroad", and SQL Server's name is "Darkroad". SQL Server 2000 can install multiple instances on the same server, which is how many times you can install them repeatedly. Then you need to select a different instance name. It is recommended that you limit the instance name to 10 characters. The instance name appears in the user interface of various SQL Server and system tools, so the shorter the name, the easier it is to read. In addition, instance names cannot be "Default" or "MSSQLSERVER" and SQL Server reserved keywords.

In the Setup Type window, select the Typical installation option and specify the destination folder. The default installation location for both program and data files is "C:\Program Files\Microsoft SQL Server\". Because C disk is the system area, D disk is the application area, so select D disk. Note that if you have more than 100,000 database data, reserve at least 1G of storage space to cope with the large amount of log space and indexing space required.

Data will increase with time, so it is best not to set the data files and log files on the system disk.

In the Service Account window, select "Use a consolidated account for each service ..." The options. In the service settings, select Use Local System account. If you need to use a domain user account, add the user to the Native Administrators group of Windows Server.

In the Authentication Mode window, select blending mode ... option, and set the password for the administrator "sa" account. If your purpose is only to learn, you can set the password to be blank for easy logging in. If it is a real application system, then you need to set up and take good care of the password! : If higher security is required, you can choose Windows Authentication mode, where SQL Server is available only to local and domain users of Windows Server.

In the Select License Mode window, enter (0 for no quantity limit) according to the type and quantity you purchased. Per Seat represents the maximum number of connections allowed at the same time, and "Processor license" indicates how many CPUs the server can install. (Don't choose too much, the more the more expensive!) ）

Then is about 10 minutes of installation time, after installation, the interface appears, and added the following menu. If you are a beginner, you can first open "Books Online", do a simple study!

SQL Server 2000 download address: http://www.jb51.net/softs/2187.html