How To Install SQL Server2000 Enterprise Edition in Windows XP

The SQL2000 Enterprise Edition is applicable to Windows 2000 Server and Windows 2003. You do not need to use the 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:
1. Find the msdedirectory in the installation disk of the SQL Server and click setup.exe to install it. The process is simple and the next step is simple.
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 SQL server 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 modify the logon mode. 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 again to confirm the password.
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.