SQL installation failed 20, SQL installation failed

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!

There is a problem with the installer, change it.

It looks like there's a bug in the installer.,Maybe it's corrupted.。

However, the landlord said that it had been replaced several times or it was still a problem, which ruled out the problem that the installer was corrupted.

Error encountered when installing sqlserver:

First, the installation version problem: If it is a Windows XP system, you can only install SQL Server Personal Edition.

If it's Windows 2000, it doesn't matter.

Second, the installation file of sqlserver is placed in the Chinese directory. That is, your installation directory folder name has Chinese in it.

Third, delete the "Microsoft SQL Server" folder generated during the previous installation, enter the registry in the start menu - "Run - " regedit", and put hkey current usersoftware microsoft sql server, and hkey local machinesoftware microsoft sql Delete all servers, (note that you need to delete the entire Microsoft SQL Server folder), and then start again.

There should be no problem with reloading!

Fourth, try to patch the operating system sp4.

I've done my best, hehe.

The installation of SQL Server 2012 is completed but fails because the system installation plug-in that comes with the computer is missing or not installed

4.Restart the installation automatically, then wait, and the system will automatically install.

Most likely, it is not enabled. Control panel inside.