SQL server2000 Installation Tutorial

SQL Server 2000 is the latest version of Microsoft's large database server, and its performance metrics have a tendency to overtake Oracle databases in every way. After experimenting with SQL Server 6.5 and 7.0 two versions, Microsoft has finally begun to embark on a major business segment. Remember in the previous articles on SQL Server, will be positioned as a small and medium-sized applications, this feeling is naturally extended to the 2000 version. In fact, this is a misunderstanding. Over a long period of time, Microsoft has taken the world's finest database experts and a geographic information system that is unprecedented in information, and is trying to take off this hat on its head. With powerful performance and functional support, and with its always-praised ease of use, SQL Server can be said to be a tool in the hands of developers!

In addition, some of the current domestic Microsoft platform on the database programming tutorials, like to use Access as a database platform case, and expand the relevant content. This actually does not have the direct help to the development real database application, only then lets everybody stay in the application the initial stage. SQL Server 2000 provides a very stupid default installation and usage model that is not as easy to use as access. In addition, SQL Server 2000 can accommodate small, medium, and large-scale applications, with a much greater scalability than access. Therefore, it is suggested that everyone should be inferior to one-step, starting from a high starting point directly, which is also good for the continuous development of personal skills.

The author has been working on the Platform application development based on SQL Server 2000 system for some time and accumulated some experience. In order to share these experiences with you, a series of tutorials closely related to SQL Server will be introduced in the coming years.

Xi hee, blowing so many cowhide, it is time to talk about the topic:). This article describes the hardware and software configuration requirements for installing SQL Server 2000 Enterprise Edition, detailed steps for the installation process, and matters to be noted.

First, 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 reserving 500M of data space
Display	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	operation The system requires
Enterprise Edition	microsoft Windows NT Server 4.0, Microsoft Windows NT Server 4.0 Enterprise Edition, Windows Server, Windows Advanced Server, and Windows 2000 Data Center Server. (All versions need to be installed IE5.0 above version browser)
Standard Edition	microsoft Windows NT Server 4.0, Windows SQL Server, Microsoft Windows NT Server Enterprise Edition, Windows Advanced Server, and Window S Data Center Server.
Personal edition	microsoft Wind oWS Me, Windows 98, Windows NT Workstation 4.0, Windows Professional, Microsoft Windows NT Server 4.0, Windows 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.

[1] [2] [3] [4] [5] [6] [7] [next page]