Install SQL server 2000 Enterprise Edition (graphic version) on Windows XP and SQL

Source: Internet
Author: User
Tags mssqlserver

Install SQL server 2000 Enterprise Edition (graphic version) on Windows XP and SQL

However, the methods on the Internet only contain text instructions, but are not attached with the corresponding instructions. Therefore, it is more intuitive for me to perform the test.

The installation and testing process of Haibo is as follows:

1. Go to the installation disk or folder of the ms SQL Server software, go to the msdedirectory, and find setup.exe.

2. Double-click setup.exe in the msdedirectory to install it.

3. After the installation is complete, restart the system. The SQL running icon appears in the lower right corner, as shown in.

4. Go to the installation disk or folder of the ms SQL Server software, and find autorun.exe under the directory.

5、double-click autorun.exe to enter the installation, as shown in.

6. Click "Install SQL Server 2000 component" to go to the next step, as shown in.

7. Click "Install database server" to go to the next step, as shown in.

8. After completion, a small prompt will be displayed, such.

9. Click OK to go to the page, as shown in.

10. Select "Local Computer" and click Next.

11. You can only select the first "Create a new SQL Server instance or install 'client tools'" and click Next.

12. Enter "User Information" and click "Next.

13. Click "yes" to go to the next step.

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

15. Select all components and click Next.

16. If no operation is performed, go to the next step.

17. During file copying, the "command line parameter error" dialog box is displayed. Click OK, for example, three.


18. The program is being installed. The interface is as follows.

19. You do not need to perform any operations. The installation interface is as follows.

20. Click Finish to complete the installation.

21. Don't worry. Try again. From the "Start" menu, choose "program"> "Microsoft SQL Server"> "query analyzer" for a test.

22. During the installation process, I was not prompted to set the "sa" user password, so it was blank. Click "OK". The error "cannot connect to the server" is displayed, as shown in.

23. Don't worry, because you haven't been associated with a trusted SQL SERVER connection. You need to modify the Registry a little bit, select "run" from the "Start" menu, and enter the "regedit" command, click OK to go to registry editing and find the [HKEY_LOCAL_MACHINE] \ SOFTWARE \ MICROSOFT \ MSSQLSERVER item.

24. In the right window, find the "LoginMode" key.

25. Double-click "LoginMode ".

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

27. Restart your computer and repeat Step 1.

Note that you must enter your computer name in "SQL Server". Otherwise, the computer will not succeed, which may be related to the setting in step 1.

28. Click OK. The connection is successful and the "SQL query analyzer" is displayed ".

OK. The installation test is successful.


How To Install SQL server2000 Enterprise Edition in windows xp

The SQL2000 Enterprise Edition is applicable to WIN2000 Server and Windows 2003 systems. You do not need to select a Personal Edition or development board for Windows XP. However, the Enterprise Edition can also be installed in the XP system. Here we will introduce how to install SQL2000 Enterprise Edition in XP for your reference:
In the installation disk of the SQL Server, find the msdedirectory and click setup.exe to install it. The process is simple and the next step is OK.
2. restart Windows XP and the SQL Service icon appears.
3. Obtain the installation optical disk of the SQL Server version. (install and run autorun.exe on zookeeper.) install the client tool as prompted.
4. Open the Enterprise Manager and try to connect to the sa user. Is login failed? Because you have not been associated with a trusted SQLSERVER connection. Fortunately, you only need to make a slight modification to the system registry: Enter regedit in the operation to open the Registry Editor and find
[HKEY_LOCAL_MACHINE \ SOFTWARE \ MICROSOFT \ MSSQLSERVER]
This item contains a key value LoginMode. The default value is 1. Change the value to 2 and restart the computer.
5. Start enterprise management and try again. OK! After the installation is complete, the Enterprise Manager is logged on in both SQL Server and Windows by default. After opening the Enterprise Manager, right-click "(local) Windows NT" under "SQL Server group ", select "properties" and then you can modify the login mode to expand "(local) Windows NT"-security-login, double-click "SA" on the right to change the password (if you do not set your own password during installation ). Enter your own password-OK-prompt to confirm the password again.
Open the query analyzer and pop up the connection dialog box. In the preceding "SQL Server", select "(local)" (local. The following two methods are available for connection: windows and SQL Server. The second method is to enter the SA and the Self-set password, which is generally OK. If any problem occurs, the solution is to check that the logon mode and password are correct. The above is my summary during installation and setup. Refer to the similar materials found on the Internet.

How To Install SQL Server 2000 on windows XP

Install SQL2000 Enterprise Edition in XP)
The SQL2000 Enterprise Edition is applicable to Windows 2000, and the 2003 and XP systems generally cannot be installed with the individual edition. Of course, if you have worked hard to download the Enterprise Edition, you cannot install it, are you very disappointed? This document describes how to install SQL2000 Enterprise Edition in XP for your reference ~

The method is as follows:

In the installation disk of the SQL Server, find the msdedirectory and click setup.exe to install it. The process is simple and the next step is OK.

2. restart Windows XP and the SQL Service icon appears.

3. Take out the installation CD of the SQL Server version and install the client tool directly? The simplest example is to directly click autorun.exe under the optical disk root directory)

Install the tool as prompted. If you know that the system is not a SERVER version during the self-check process, you will be prompted to only install the client tool. (Haha, I already have the server)

4. Open the Enterprise Manager and try connecting the SA user to see if the SA User Login fails? Because you have not been associated with a trusted SQL SERVER connection. Fortunately, you only need to slightly modify the system registry:

Enter regedit in the running directory to open the Registry Editor and find [HKEY_LOCAL_MACHINE \ SOFTWARE \ MICROSOFT \ MSSQLSERVER ].

There is a key value LoginMode. By default, the value is 1. Change the value to 2 and restart the computer.

5. Start enterprise management and try again. Is it OK!
Reference: www.zjjy.com.cn/txt/list.asp? Id = 109

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.