Install SQL Server 2000 Enterprise Edition (graphical version) on Windows XP system _mssql

But online methods are only text description, and no corresponding screenshots, I was in the process of testing in the way of screenshots, so more intuitive.

The following is the installation and testing process for the waves:

1, into the MS SQL Server Software installation disk or folder, into the MSDE directory, and find Setup.exe.

2, double-click the Setup.exe in the MSDE directory to install, the following figure appears.

3, after the installation of the reboot system, in the lower right corner of the SQL will appear in the running icon, as shown below.

4, then enter the MS SQL Server Software installation disk or folder, to find the directory under the Autorun.exe.

5, double click the Autorun.exe, enter the installation, the following figure.

6, click "Install SQL Server 2000 Components", go to the next picture below.

7, click "Install Database Server", and enter the next step as shown below.

8, after the completion of the figure, there will be a small hint, the following figure.

9, click OK, enter the following figure.

10, only select "Local Computer", click Next.

11, you can only select the first "create a new instance of SQL Server, or install the ' client Tools '", click Next.

12, enter "User Information", click Next.

13, click "Yes" and go to the next step.

14, select the first "client-only Tool" (the server has already been installed ^ ^), click Next.

15, the component Select all, click Next.

16, no operation, direct next.

17, in the process of copying files, pop-up 2 "command line parameter Error" dialog box, direct point to determine on it, the following figure 3.

18, the program is installed, the interface is as follows.

19, what do not operate, only and so on, the installation of the completion of the interface is as follows.

20, click to complete, the installation is complete.

21. Don't worry, just test it again. From the Start menu, go to Programs-Microsoft SQL Server-Query Analyzer for a test.

22, the installation process did not prompt me to set the "sa" user password, so is empty, click OK, then pop-up "unable to connect to the server" error, the following figure.

23, don't worry, because you haven't been associated with trusting SQL Server connections, this requires a little modification of the registry, select "Run" in the "Start" menu, enter "regedit" command, click OK, go to registry edit, find [hkey_local_machine]\ Software\microsoft\mssqlserver\mssqlserver items.

24, in the right window to find the "LoginMode" key.

25, double click "LoginMode".

26, modify the "Value data" in the "1" to "2", click OK.

27, restart the computer, repeat the 21st step.

Note that "SQL Server" must fill in your computer name, otherwise it will not succeed, which may be related to the setting of step 10th.

28, click OK, connect successfully, into the "SQL Query Analyzer."

OK, the installation test was successful.