Shulou(Shulou.com)05/31 Report--

This article shows you how to install SQL server 2000 Enterprise Edition in the Windows XP system. The content is concise and easy to understand. It will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

The following is the installation and testing process of Haibo:

1. Enter the installation disk or folder where the MSSQL server software is located, enter the MSDE directory, and find setup.exe.

2. Double-click setup.exe in the MSDE directory to install, as shown in the following figure.

3. Restart the system after the installation is completed, and the running icon of SQL will appear in the lower right corner, as shown in the following figure.

4. Enter the installation disk or folder where the MSSQL server software is located, and find the autorun.exe in that directory.

5. Double-click the autorun.exe to enter the installation, as shown in the following figure.

6. Click "install SQLServer2000 components" to proceed to the next step as shown in the following figure.

7. Click "install Database Server" to proceed to the next step as shown in the following figure.

8. After the above picture is completed, there will be a tip, as shown in the following figure.

9. Click OK to enter the figure below.

10. You can only select "Local computer" and click next.

11. You can only select the first "create a new SQLServer instance, or install client tools", and click next.

12. After entering "user Information", click next.

Click "Yes" to proceed to the next step.

14. Select the first "client-only tool" (the server has already been installed ^-^), and click next.

15. Select all the components and click next.

16. if there is no operation, go straight to the next step.

17. In the process of copying the file, the dialog box of "command line parameter error" pops up twice. Just click on it, as shown in figure 3 below.

The program is being installed and the interface is as follows.

19. You don't have to do anything, just wait, and the interface for the installation is as follows.

Click finish, and the installation is complete.

Don't worry, let's test it again. Enter programs-MicrosoftSQLServer-query Analyzer from the start menu to test it.

22. During the installation process, I was not prompted to set the password of the "sa" user, so it is empty. Click OK, and the error of "unable to connect to the server" pops up, as shown in the following figure.

23. Don't worry, because you are not associated with a trusted SQLSERVER connection, you need to modify the registry slightly, select "run" from the "start" menu, enter the "regedit" command, click OK, enter the registry editor, and find the key [HKEY_LOCAL_MACHINE]\ SOFTWARE\ MICROSOFT\ MSSQLSERVER\ MSSQLSERVER.

Find the "LoginMode" key in the right window.

25. Double click "LoginMode".

26. Change "1" in "numerical data" to "2", and click OK.

27. Restart the computer and repeat step 21. Note that you must fill in your computer name at "SQLServer", otherwise it will not succeed, which may have something to do with the setting in step 10.

28. After clicking OK, you will successfully connect and enter the "SQL query Analyzer".

OK, the installation test was successful.

The above content is how to install SQL server 2000 Enterprise Edition in Windows XP system. Have you learned the knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.