server| Tutorial SQL Server 2000 is the latest version of Microsoft's large database server, and its performance metrics are in all respects a trend to catch up with Oracle databases. 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, the current domestic some of the Microsoft Platform for 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, blew so many cowhide, also should say 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.
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.
Pentium 166 MHz or higher.
||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
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
Operating system requirements
| Enterprise Edition
||microsoft Windows NT Server 4.0, Microsoft Windows NT Server 4.0 Enterprise Edition, Windows SQL Server, Windows Advanced Server, and Windows \ Data Cen Ter 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 Windows Me, Windows 98, Windows NT Workstation 4.0, Windows Professional, Microsoft Windows NT Server 4.0, Windows SQL Server, and all 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.
Second, the detailed installation process
This article describes the process of installing SQL Server 2000 Enterprise Edition in detail in the Windows Advanced server operating system as an example. All clear first installs Windows Advanced Server. If you don't have a SQL Server 2000 Enterprise version on hand, you can download a trial version of Microsoft's Web site:
Or buy a product from a software company.
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.
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. The author has chosen "Per Seat" and entered 100 as an example. Hee, don't choose too much, the more the more expensive AH! ：）
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!
(End of full text)