How do I install SQL2000 to XP? Urgent! ！

There is no problem with installing it by following the steps below:

1) First install the setup in the msde folder (and then manually restart);

2) Start the installer in the root directory (check the helper items during the installation process).

The tomato garden system can't be installed, I've tried it many times.

Note: You are only under ServicePack4 for SQL Server 2000, not SQL Server 2000 with ServicePack4. This is just a patch service pack, and you didn't have SQL Server 2000 installed, so you can't install sql2ksp4 anymore!

The Enterprise version can also be installed under the XP system.

The installation method is as follows:

1. Find the MSDE directory in the installation disk of the SQL server, and click to install it, the process is simple and the next step is OK. (This is the server side, according to the normal method, the system will be prompted that it is not supported).

Two. Restart the system WindowsXP, and then you can see the icon of the SQL service appear. (If the server chart does not appear, you can also install the client first on the server side).

Three. Then take out the SQL server version of the installation CD and install the client tools directly (don't say more about this, right?). The easiest way to do this is to click directly on the root directory of the disc.

According to the prompts to install, the self-test process knows that the system is not the server version, and will prompt to install only the client tools. (Haha, I already have it on the server).

Four. Open Enterprise Manager, try the SA user and check it out, do you find that the SA user fails to log in? Because you don't already have a trust SQL Server connection associated with it. Fortunately, this only needs to be modified slightly to the system registry:

Enter regedit to open the registry in the runtime, and find [hkey local machine software microsoft mssqlserver mssqlserver], this entry is inside.

There is a key loginmode, by default, the value is 1, now change the value to 2, restart the computer.

Five. Open the enterprise management again, and try to connect again, isn't it ok!

It is recommended to use VM VM to install 2003+ SQL

XP can't be installed, if you're using a virtual machine for learning, it's better to get started.

You uninstall the previous version so that Ann can also be used.

1. Find a SQL Server Server Edition CD, find the directory "msde" on the CD and enter it, run the file, and install it according to the program requirements. Restart your computer when the installation is complete.

2. Run the file in the CD, or let the CD run automatically, after opening the installation interface, click "Install SQL Server 2000 Components (C)" = "Install Database Server (S)" Here the program will prompt you".The server component is not supported on this system ,..Tap OK.

Enter the new installation interface, click "Next", and select the default "Local Computer" = > "Create a new SQL Server" = > "Client Tools Only"...Click "Next" all the way. Until the end of the installation.

Restart your computer.

3. Go to "Start" -- Program "-"Microsoft SQL Server" and open "Enterprise Manager" to "SQL Server Group", change "[lcoal] (Windows NT)" to your own machine name, the machine name can be found in the "computer name" of the system properties, assuming that the complete computer name in our machine is: server, after changing the name, we will get the appearance shown in the figure. Close Enterprise Manager

Fourth, go to "Start" - "Programs" - "Microsoft SQL Server" to open the "Client Network Utility", click "Alias" If there is no data in the "Server Alias Configuration", we need to add it manually, click the "Add" button. In the "Network Library" option of "Add Network Library Configuration", we select the default "named pipes(p)" item and alias the server "server", at which point the pipe name will automatically add "server pipe sql query" and we will leave it alone. Click OK to exit.

5. In this step, we need to enter the registration to make some modifications, open the registry, and find [hkey local machine software microsoft

mssqlserver mssqlserver], this item, there is a key value in it loginmode, the default value is "1", now change the value to "2" (when installing msde, the default sql server authentication method is "windows only"The authentication method can not be verified by the SA user, and the authentication method can be changed to SQL Server and Windows mixed authentication by modifying the above registry key value, and the SA user can be used to log in). When the modifications are complete, restart the computer. It worked.

1. Open the installation package, find the autor file and click. Click on the recommendation to install SQL Server 2000, 2. Click "Install Database Server" in the interface that appears.

4. In the SQL Server 2000 interface, in the computer name window, select "Local Computer" and click "Next".

5. In the Installation Selection window, select Create a new SQL Server instance or install client tools

6. Write your name in "User Information". and company name.

7. In the "Software License Agreement" window. Click "Yes".

8. In the Installation Definition window, select Server Client Tools. Then click "Next".

9. Enter a name in the Instance Name window. Then click "Next".

10. In the "Installation Type", select the directory you want to store. Then click on the OK button. Then click on "Next".

11. In the "Service Account" window, select "Transfer Account Using Local System," and then click the "Next" button.

12. In the "Identity Mode", enter the password of the SA account.

13. In the Start Auxiliary folder, click the Next button.

14. The installation is complete. Then click on the Done button.