Microsoft SQL Server 2000 Integrated Application (1) -- SQL 2000 Overview and Installation

Microsoft SQL Server 2000 comprehensive application this series of articles mainly write to cute GGT teachers, hope she can feel at ease on the platform, and then teach this series of articles. SQL Server is a high-end database system packaged by micrcoft based on its cooperation with Sybase. Since its launch, it has quickly occupied the database application market. After constant upgrades, it has developed to SQL Server 2000, which has the advantages of high performance, strong functionality, good security, easy operation, and easy maintenance. It is positioned in the Internet background, database applications based on Windows 2000 provide a comprehensive data management and data analysis solution for your web applications. The first chapter mainly describes the overview of SQL 2000 and the specific content of the installation process as follows: the class time is 40 minutes, and the practice is 40 minutes. Remember to leave 5 minutes for each class to summarize.

1. Why Mircrosoft SQL 2000?

(1) extensiveness: currently, large data types include orcal, DB2, MySQL, and Microsoft SQL, choosing Microsoft's database system is mainly to consider that most of the current development environments are based on Microsoft's Windows system.

(2) universality: SQL statements are generally used in different database systems, with only slight differences. SQL statements focus on "understanding a hundred items ", after learning how to use SQL 2000, you can easily get started with other databases.

(3) Simplicity: considering that students should have never played with databases and use SQL Server 2000 in the graphic interface, this will inspire everyone's enthusiasm, because the menu items and usage of SQL 2000 are simpler than those of other database systems.

(4) Conclusion: simple and friendly operation methods, various forms of management architecture, high reliability, scalability and availability, rich programming interfaces, and high compatibility.

2. Which version of SQL 2000 should be selected? (This part can be explained when selecting the version information during the installation process)

SQL Server 2000 includes four common versions:

(1) Enterprise Edition supports all SQL Server 2000 features and can be used as database servers for products such as large web sites, enterprise OLTP (online transaction processing), and data warehouse systems.

(2) Standard Edition is used for small working groups or departments.

(3) Personal Edition is used for stand-alone systems or clients. You can install it on the XP system. Others must be in the server version system.

(4) Developer Edition is used by programmers to develop applications that require SQL Server 2000 as a data storage device.

If you try to install the Personal Edition, try not to install the Enterprise Edition, because the Enterprise Edition may require additional installation environments;

3. How should we learn SQL 2000 well?

(1) If you learn how to install SQL 2000, you must understand the impact of each installation step on the subsequent use of the database system (this will lead to the next installation process ).

(2) You must be familiar with operating the database using graphical interfaces (simple) and SQL statements (knowing and knowing why) (so that the time can be easily spent );

(3) be familiar with the application in the instance and remember to save your labor results for the next use (teach students how to back up the database)

(4) familiar with SQL 2000 in practice.

(5) view more online manuals (similar to the help document of Matlab, you can teach students how to query online manuals)

4. How to Install SQL 2000?

First download SQL 2000 SP4 on the website: http://www.rsdown.cn/downinfo/241.html

(1) Place the Microsoft SQL Server 2000 installation CD into the optical drive. The installation program runs automatically and the version selection page is displayed. Let's select a Personal Edition as an example. For example:

Figure 1 version Selection

(2) Select the "Install SQL Server 2000 component" option in the following interface. For example:

(3) Select "Install database server ". For example:

Figure 3 select to install the Database Server

(4) The Installation Wizard will appear later. Click "Next" and the "computer name" window will appear. "Local Computer" is the default option, and its name is displayed above. Click "Next" by default ". For example:

(5) Next, in the "installation and selection" dialog box, click "create new SQL server instance or install client tool" as the default item.

Figure 5 installation and selection

(6) The next window is the username and company name. After a step through the software license agreement, you will arrive at the "installation definition" dialog box (for example ). Similarly, select the next step based on the default "server and client tools.

(7) In the "Instance name" window, the system generally provides the default check box. We can either install the default instance or customize it. Students should select the default mode as much as possible.

Figure 7 instance name

(8) You can set multiple options in the installation type dialog window. For example, select the number of components installed and the installation path as needed. We recommend that you install data files on other disks. Note that you only need to change the disk symbols. Do not change the entire path, for example, "d:/program files/Microsoft Server ", here we will give you a detailed explanation.

(9) In the "service account" dialog box, select "use local SYSTEM account". We recommend that you also select a local system account, because most students use a single machine.

Figure 9 service account

Note: If you select to specify the account used by the server, you need to specify a user, password, and domain name. It is not recommended for students because it is prone to problems.

(10) In the "Authentication Mode" window, if your operating system is WindowsNT or above, select "Windows Authentication Mode". We recommend that you select "hybrid mode ". This part sets the login password for the database, which is very important. It highlights why some students cannot use the system to download the database. A large part of the information is here to blame, of course, you can change the password after the installation is successful, or you can set a blank password. It must be explained in detail.

(11) after everything is set to OK, the installer starts to copy necessary files to the hard disk and start formal installation. You can explain the current status of SQL Server while waiting.

Figure 11 Installation started

(12) the installation is completed in a few minutes. Click Start> program to view the program components of Microsoft SQL Server 2000, such ). Remember to go to Computer Management> services to query the MSSQL service and explain the Service Startup dialog box in the lower right corner of the desktop.

Figure 12 Microsoft SQL Server 2000 Program component

V. Uninstall SQL 2000

You can use the built-in deletion program and Control Panel methods. In addition, each named Microsoft SQL Server 2000 instance must be deleted separately and individual components of SQL Server 2000 cannot be deleted. To delete a component, you must delete the entire instance.

In addition, before deleting SQL Server 2000, exit all related applications, includes Windows event viewer, Registry Editor, all SQL Server 2000 applications, and all SQL-dependent applications.

Vi. References

[1] SQL Server 2000 Overview: http://www.hncc.net/jpkc/pc/ SQL /ReadNews.asp? Newsid= 515

[2] SQL 2000 installation process: http://www.5school.com/ZhiShiBiBei/2009-03/12688.htm

[3] SQL 2000 installation diagram: http://hi.baidu.com/duqunle/blog/item/5395824536a4ed3f879473a7.html

In this way, the content of the first course is basically like this. The GGT teacher restarts the machine and takes a rest after class. Then, the students are arranged to spend a class to install software. The main content of the next course is to explain how to operate the SQL 2000 client (that is, to introduce menu items and the role of right-click items), and then create a new table to complete the whole day's work.