Can I Install SQL Enterprise Edition in XP?

How do I install Microsoft SQL Server on Windows XP?

1. Insert the CD-ROM SQL Server to run the installation automatically, as shown in the following figure

2. Click "Install SQL Server Components".

3. Click "Database Server Desktop Edition", and a new installation interface will appear

4. Select "Local Install Install to the Local Machina" and click the "Next" button

5. Click the "Next" button

6. Click the "yes" button

7. Click the "Next" button

8. You can modify the installation directory of "Program" and "Database", and then click the "Next" button

9. Select "Use the Local System Account" and click the "Next" button

10. Click the "Next" button

11. Now enter the file installation process of SQL Server

12. Click the "Finish" button to complete the installation.

13. Restart your computer.

14. After restarting the computer, click the "mssqlserver" icon in the icon bar in the lower right corner, as shown below

15. Click the triangle button on the right side of "Start and Continue" to start the service of msssqlserver

16. If you select "Auto-start service when auto-OS", the service of mssqlserver can be started automatically when the operating system is started.

No! SQL 2000 Enterprise Edition can be installed only on the server version.

XP can only install the personal version, as if the development version is also fine!

I haven't experimented.,There shouldn't be any problem.,The personal version can be installed.,You can install it on your own machine.,In addition, you can install another system on your machine.,Isn't that okay?!

SQL2000 Enterprise Edition is suitable for Win2000 Server system and Windows 2003 system. But the Enterprise Edition can also be installed under XP systems. Here is an example of how to install SQL 2000 Enterprise Edition under XP for reference

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 straightforward.

Two. Restart the system WindowsXP, and then you can see the icon of the SQL service appear.

Three. Then take out the installation CD of SQL Server Edition, (local disk installation and run) according to the prompts to install, here directly install the client tool.

Four. Open Enterprise Manager and try the SA user to connect it, does the user fail to log in? Because you don't already have a trust sqlserver connection associated with it.

Fortunately, this only needs to modify the system registry slightly: enter regedit in the runtime, open the registry, and find it.

There is a key value loginmode in this item, 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, OK! After installation, Enterprise Manager defaults to a mixed mode of SQL Server and Windows login, open Enterprise Manager, and right-click"SQL Server group"down"(local)windows nt", select"attributes"You can then modify the login mode to will"(local)windows nt"- Security - To log in, double-click on the right"sa"You can change your password (if you didn't set your own password when you installed it).

Enter the password yourself - OK - prompt to confirm the password again.

Open the Query Analyzer and pop up the Connect dialog box at the top"sql server", select"(local)"(Local) on the line. There are two ways to connect, Windows and SQL Server, the second way is to enter the SA and the password you set, if there is a problem, the solution is generally to check the login mode and password entered correctly. That's my summary of the installation and setup process.

Similar information found on the Internet was consulted.

Some ghost systems have only the bridge disk installed on the system, and SQL can't be installed by Huimeng.

The computer company's ghost system disc can be installed with SQL, and the step-by-step installation can also install SQL

Can't afford SQL! Just use MSDE2000! It's the same!

SQL Server 2000 Personal Version can be installed in XP

Install SQL Server 2000 as a basic local installation.

1.Insert the Microsoft SQL Server 2000 installation CD into your CD-ROM drive (or double-click the file in the root directory of the CD if the CD is not running automatically), select SQL Server 2000 components, and then select Install Database Server. The installer prepares to start the SQL Server Setup Wizard.

2.In the Computer Name dialog box, the local computer is the default option, and the local computer name appears in the text box. Click Next.

3.In the Installation Options dialog box, click Create a new instance of SQL Server, or install client tools, and then click Next. Follow the instructions on the User Information, Software License Agreement and related pages.

In the Installation Definition dialog box, click Server and Client Tools, and then click Next.

4.In the Instance Name dialog box, if the default check box is available, you can install either the default instance or the named instance. If the default check box is not available, the default instance is already installed, so only named instances can be installed.

To install the default instance, select the default check box, and then click Next.

To install a named instance, uncheck the default check box, type a new named instance in the instance name box, and then click Next.

5.In the Installation Type dialog box, click Typical or Minimum, and then click Next.

6.In the Service Account dialog box, accept the default settings, type your domain password, and then click Next. In the Authentication Mode dialog box, accept the default settings, and then click Next.

When you have completed all the specified options, click Next in the Start Copying Files dialog box.

7.In the Select License Mode dialog box, make your selections based on your license agreement, and then click Continue to begin the installation. In the Installation Success dialog box, click Yes, I want to restart my computer immediately, and then click Finish.

It can be installed, but there are restrictions, and it can only be installed in the personal version and the standard version. It is recommended that you install the personal version.

Yes. You go for it the usual way!

One of the easiest ways to do this is to install it on the XP computer, copy the Ann Wool Qin folder completely to the Vista computer, and then run it, ignore the incompatible mode, and the answer is added, I haven't used SQL Serve, I've used both VC and VF, if you can't try, just reinstall it to XP, in fact, Vista is quite rubbish, your one is the flagship version, which is the legendary U version, but if you reinstall, you must be ready to drive Lenovo's official you want to see if there is a driver in the XP environment If not, you can install it and go to the Internet**shirt spine a driver wizard on the line I used to use Vista, but now I have changed to XP Vista, the compatibility is really poor, you can use a lot of things, you will gradually find that the long pain is not as good as the short pain, and the early cavity collapses to change it.

If it helps you, please remember to answer for satisfaction, thank you! Have a great day!

Didn't you say that just changing the registry would be fine? Generally, XP is to disturb Xun and Ling Birong SQL, but if it is not the first time to slow down this installation under this system, it may be necessary to change the registry, but because of the DUG installed.

Don't try it, XP can't install the enterprise version, the development version is very easy to use. There's no need to toss around. Installing an MSDE is not as easy to use as the development version.