In order to help a friend solve the problem of being unable to install the SQL server version on the WINDOWS XP system, I had to install a WINDOWS It will be helpful to netizens who need it. Without further ado, the steps are as follows:
1. Find a SQL server server version CD, find the directory "MSDE" on the CD and enter it, run the SETUP.EXE file, and follow the program requirements. Install. Restart the computer after the installation is complete.
2. Run the AUTORUN.EXE file in the CD, or let the CD run automatically. After opening the installation interface, click "Install SQL server 2000 component (C)" => "Install database server (S)" The program will prompt you. ....The server component is not supported on this system,..." Click "OK". Enter the new installation interface, click "Next", select the default "Local Computer" => "Create a new SQL server" => "Client Tools Only"..., and click "Next" all the way. until the installation is complete. Restart the computer.
3. Go to "Start" - "Programs" - "Microsoft SQL Server" and open "Enterprise Manager" under "SQL Server Group" and change "[lcoal] (Windows NT)" to your own machine name. The machine name can be found in the "Computer Name" of the system properties. Assume that the complete computer name in our machine is: SERVER. After changing the name, we will get something as shown in the figure. Close "Enterprise Manager"
4. Go to "Start" - "Programs" - "Microsoft SQL Server" to open "Client Network Utility" and click "Alias". If there is no data in "Server Alias Configuration", we need to manually To add, click the "Add" button. In the "Network Library" option of "Add Network Library Configuration", we select the default "Named Pipes(P)" item and give the server an alias "SERVER". At this time, the pipe name will automatically add "\SERVER pipesqlquery" and let’s leave it alone. Click "OK" to exit.
5. In this step, we need to enter the registration and make some modifications. Open the registry editor and find [HKEY_LOCAL_MACHINESOFTWAREMicrosoft
MSSQLServerMSSQLServer], this item has a key value LoginMode. The default value is "1". Now change the value to "2" (when installing MSDE, the default SQL Server authentication method is "Windows only" identity Authentication method, that is, the sa user cannot be authenticated. After modifying the above registry key value to change the authentication method to SQL Server and Windows mixed authentication, you can log in as the sa user). After the modification is completed, restart the computer.
Successful
Method 2:
Open the registry (regedit), find HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSMQ, modify the value of "ab (default)" to 2``` and restart. Then you can install Microsoft SQL Server.
Not bad.
ab" is the icon, there is only one option
When installing SQL Server, I encountered an error message:
A previous program installation has created pending file operations on the installation computer. You must restart your computer before running the installer!.
After searching for a long time, I couldn't find any program. SQL Server has not been installed on this machine before. Check out what software is installed on the system? 3721 Internet Assistant is there! Delete it!
Still not working, I searched and found this blog to be the most valuable:
3) Open the registry editor and go to HKEY_LOCAL_MACHINESYSTEMCurrentControlSet Find the PendingFileRenameOperations project in ControlSession Manager and delete it. This will clear the installation pending items.