SQL Server 2000 detailed installation process and configuration

Description: This article is a few years ago I published in the NetEase blog original article, but because NetEase blog now to stop operation, so I put this article moved over, although the SQL Server 2000 software is already outdated, but still some people use it, In particular, some college students may use it when they do their graduation design or course design, so keep the software installation process here.

In addition, this SQL Server 2000 software can only be installed and used properly on Windows XP or a lower operating system and requires a lot of complex setup on Windows 7 or later operating systems to be installed and used (and not necessarily smooth). So if you can, we recommend using SQL Server 2005 or a later version of the software to replace it!

——————————————————— Split Line ——————————————————

1. Installation process

Note: Because SQL Server 2000 is installed in a harsh operating system environment, it is best to quit all running software before installation, including anti-virus software and security guard software (preferably installed after the boot, do not run other software), Failure to do so may cause the installation to fail. If you experience a "previous program installation has created pending file operations on the installation computer " prompt during installation, exit the installation, and then download and run the software provided below before you install SQL Server 2000 CAN (Baidu Network address):Http://pan.baidu.com/s/15Qluk first unzip the download to the SQL Server 2000 human version of the compressed file, if not yet this file, can be downloaded to the following URL (I upload the file, that is, the following version of the file, Baidu Network address): http://pan.baidu.com/ share/link?shareid=4009181539&uk=3625167645then open the Unpacked folder and double-click on the file AUTORUN.EXE inside to run:

Click "Install SQL Server 2000 Components" and:

Click "Install Database Server" to:

Click "Next":

Select "Local Computer" and click Next:

Click "Next":

Enter "Name" and "Company", or you can use default or no input, then click Next:

Click "Yes":

Click "Next" below:

There is no need to modify it, take the default value, and then click Next:

Select "Use Local System Account" and click Next:

Select "Mixed Mode (Windows authentication and SQL Server authentication)", then enter the password and enter the confirmation password both SA (you can also set a more complex password, or use "Mixed mode", wait for the software to be installed and then set up later), click Next:

Click "Next":

Wait for the installation:

When the installation is complete, click the "Finish" button so that SQL Server 2000 is installed:

2. SQL Server 2000 configurationafter the installation is complete, SQL Server 2000 needs to be configured appropriately so that the SA user can work properly, or there will be a prompt such as "SA User logon Failure" when connecting to the SQL Server 2000 database in the graduated database management system. before configuring, you need to open SQL Server 2000 Service Manager from the Start menu and run:

Then open SQL Server 2000 Enterprise Manager from the Start menu, then expand the left tree box, in the server name (on some computers with "local", on some computers with "pc-xxxxx") Right click, select "Properties":

Then select SQL Server and Windows (S) from the Authentication tab of the open form, and then click the OK button:

Then right-click the name of the server again and select "Edit SQL Server Registration Properties":

Select Use SQL Server authentication in the open form, and enter both the login and password are SA (you can also set a more complex password), and then uncheck the "Show system databases and System objects" check box to hide the system's database tables when viewing the database tables. To avoid accidental operation), then click the OK button:

Click "Yes" in the pop-up dialog so that SQL Server 2000 is configured and you can close and reopen SQL Server 2000 Enterprise Manager if necessary:

Note: All the articles in this blog are original, welcome reprint, but please indicate the words "Raven Software" when reproduced, thank you!

SQL Server 2000 detailed installation process and configuration