Can SQL2005 be installed in XP system?

No, the SQL series can only be installed on the server system, such as win2003, you can go to my site to post your problem, see if there is a good solution, is there a problem with the computer?

Come and try it out at Zowee International.

sql2005 is divided into five editions, listed below, Enterprise Edition), Development Edition), Working Group Edition), (Standard Edition) Well, let's call it the Easy Edition).

The Enterprise Edition database engine can only be installed on Win2003 Server (or other servers).

If you want to install it on Windows XP Pro system, you should install SQL2005 Development Edition (Development Edition).

So, if you're a beginner, if you just want to learn from home, if your environment is WindowsXP Pro, then you should choose SQL2005DEVELOPMENT instead of SQL2005Enterprise or SQL2005Express (Lite).

Pro, this is because the service of the database in 2005 was discontinued, in SQL

server

In the configuration manager, you can see that you can turn it on, but the landlord has installed 2008, so don't use 2005. 2008 has smart prompts

If you want to install it on the Windows XP Pro system, you should install the development version, and the memory should be large enough, more than 512M memory.

It is recommended to use VM VM to install 2003+ SQL

XP can't be installed, if you're using a virtual machine for learning, it's better to get started.

You uninstall the previous version so that Ann can also be used.

1. Find a SQL Server Server Edition CD, find the directory "msde" on the CD and enter it, run the file, and install it according to the program requirements. Restart your computer when the installation is complete.

2. Run the file in the CD, or let the CD run automatically, after opening the installation interface, click "Install SQL Server 2000 Components (C)" = "Install Database Server (S)" Here the program will prompt you".The server component is not supported on this system ,..Tap OK.

Enter the new installation interface, click "Next", and select the default "Local Computer" = > "Create a new SQL Server" = > "Client Tools Only"...Click "Next" all the way. Until the end of the installation.

Restart your computer.

3. Go to "Start" -- Program "-"Microsoft SQL Server" and open "Enterprise Manager" to "SQL Server Group", change "[lcoal] (Windows NT)" to your own machine name, the machine name can be found in the "computer name" of the system properties, assuming that the complete computer name in our machine is: server, after changing the name, we will get the appearance shown in the figure. Close Enterprise Manager

Fourth, go to "Start" - "Programs" - "Microsoft SQL Server" to open the "Client Network Utility", click "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)" item and alias the server "server", at which point the pipe name will automatically add "server pipe sql query" and we will leave it alone. Click OK to exit.

5. In this step, we need to enter the registration to make some modifications, open the registry, and find [hkey local machine software microsoft

mssqlserver mssqlserver], this item, there is a key value in it loginmode, the default value is "1", now change the value to "2" (when installing msde, the default sql server authentication method is "windows only"The authentication method can not be verified by the SA user, and the authentication method can be changed to SQL Server and Windows mixed authentication by modifying the above registry key value, and the SA user can be used to log in). When the modifications are complete, restart the computer. It worked.

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.