Window
The method is 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.
Two. Restart the system Windows XP, this will see the SQL Service icon appears.
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 simply click on the autorun.exe in the root of the disc and not select the MDSN help file when installing
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.
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. Reopen the Enterprise