Install sql2000 and sql2005 at the same time, experience_PHP tutorial

The server version of sql2000 is 8.0, and sql2005 is 9.0
First of all, you must read the required configuration for installation (see postscript)
1. I installed 2000 first, and then applied the sp4 patch after installation, (the sa password should not be too simple)
1. Then install sql2005. When installing, just find the setup.exe in the tools directory and install it. After the installation is completed, there will be a SQL Server Management Studio, which is the enterprise manager of sql2000.
2, many people I can't even connect to the database of SQL Server Management Studio 2005. I tried a lot at the beginning.
In fact, I just need to select the database engine, and then fill in the "machine name SQLEXPRESS" in the server name. If your machine name is haha, then "hahaSQLEXPRESS", the verification method is selected according to your needs. Click connect to connect to the sql database engine. If you customize the service name, replace SQLEXPRESS with your custom service name
When I attached the database, it was 2005 The attached database cannot be attached by 2000
Q: Can the database of ms sql 2005 be imported (restored or restored) into ms sql 2000?
A: The database script can be generated in sql 2005, please note When generating, you need to choose to generate the sql 2000 version of the script and then use this script to create the target database in 2000, and then use data import/export to import the data from 2005 to 2000.
Q: The user name of SQL Sever2005 and How should the password be set?
A:--Replace chinawn with the user you want to create
sp_addlogin 'chinawn','a','pubs'
go
EXEC sp_adduser 'chinawn', 'chinawn', 'db_owner '
Postscript:
Hardware and software requirements for installing SQL Server 2005
http://msdn2.microsoft.com/zh-cn/library/ms166016.aspx
Security precautions for installing SQL Server
Upgrade to SQL Server 2005

http://www.bkjia.com/PHPjc/631067.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/631067.htmlTechArticleThe server version of sql2000 is 8.0, and sql2005 is 9.0. First, you must read the installation and configuration requirements (see postscript) 1. I am Install 2000 first, then apply sp4 patch after installation, (sa password should not be too simple) 1. Then install sql...