How to install the SQL Server Enterprise version on WinXP Systems _ Application Tips

First things to NOTE: You must enable file and print sharing to successfully install MSDE. Otherwise, the installation process may continue until it is almost complete, and then unexpectedly rolled back, unable to complete the installation of MSDE.

That's why my last installation failed, I always shut down the server service, and there's nothing to share. Incidentally, it is said that you try to change the computer name to uppercase, it will not fail to install SQL, but I did not verify!

An enterprise version can also be installed under the XP system

Installation methods are as follows:

A Locate the MSDE directory on the SQL Server installation disk and click Setup.exe to install it, and the process is simple and the next step is OK. (This is the server, the normal method will prompt the system does not support)

Two. Restart the system Windows XP, this will see the SQL Service icon appears. (The server diagram does not appear or the client is installed on the installation service side)

Three. Then take out the SQL Server version of the installation CD-ROM, directly install the client tool (this do not say more?) The easiest way to do this is to click the Autorun.exe in the root of the disc directly.

When prompted to install, you will be prompted to install the client tools only if you know that the system is not a server version during the self-test. (Haha, I already have the service side)

Four. Open Enterprise Manager, try the SA user to see, is not found that the SA user failed to log in? Because you are not yet associated with a trusted SQL Server connection. Okay, so just make a few changes to the system registry:

In Run enter Regedit open Registry Editor, find [HKEY_LOCAL_MACHINE\Software\Microsoft\MSSqlserver\MSSqlServer], this item inside

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

Five. Again open Enterprise Management, and then connect to try, is not OK!

The following are additional users:

Find a SQL Server version of the CD, locate the directory "MSDE" on the CD and enter it, run the SETUP.EXE file, and install as required by the program. Setup completes restarting your computer.

Second, the operation of the CD-ROM, AUTORUN. EXE file, or let the CD run automatically, after opening the installation interface,
Click "Install SQL Server 2000 component (C)"--> "Install Database server (S)"
Here the program will prompt you ".... Server components are not supported on this system, ... "point OK".
Enter the new installation interface and click "Next" to select the default "local computer"-->
Create a new SQL Server "-->" client-only tool ... and click "Next".
Until the installation is complete. Restart your computer.

To start--"Programs"-"Microsoft SQL Server", open Enterprise Manager to SQL Server group, change [Lcoal] (Windows NT) to its own machine name, and the machine name can be found in the computer name of the system's properties. , assuming that the full computer name in our machine is: SERVER, after renaming, close "Enterprise Manager"

Four, to "start"--"programs"-"Microsoft SQL Server" Open "Client Network Utility", point "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) and give the server an individual name "server", when the pipe name is automatically added "\\SERVER\pipe\sql\query" let's leave it. Click OK to exit.

Five, this step we have to enter the register for a change, open Registry Editor, find [hkey_local_machine\software\microsoft\
Mssqlserver\mssqlserver], this entry, which has a key value loginmode the default is "1" and now changes the value to "2" (the default SQL Server Authentication mode is "Windows only" authentication when you install MSDE, That is, the SA user cannot verify that the authentication mode is changed to SQL Server and Windows mixed authentication by modifying the above registry key value, and can be logged on with the SA user. After the modification, restart the computer.

It worked!

Method 2

Open the Registry (REGEDIT), locate the HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\MSMQ, and modify the "AB (default)" Value of 2 ' to reboot. Then you can install Microsoft SQL Server.
It's not bad.

AB "is an icon, with only one option

Installing SQL Server encountered an error message:

A previous program installation has created a pending file operation on the installation computer. You must restart your computer before running Setup!.
Looking for a long time, did not find a program, the machine has not previously installed SQL Server. See what software is installed on the system? 3721 Internet Assistant or something impressively in the eye! Erase it!

Or not, search for a moment, found that this blog the Most Valuable:

3 Open Registry Editor and locate the PendingFileRenameOperations project in HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager , and delete it. This allows you to clear the installation pending items.