The 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 installed 2000 first, and then applied the sp4 patch after installation. (The sa password should not be too simple)
1. Then install sql2005 and install Just find the setup.exe in the tools directory and install it. After the installation is completed, there will be SQL Server Management Studio, which is the enterprise manager of sql2000.
2. Many people cannot connect to the database of SQL Server Management Studio2005. Start I also tried a lot.
In fact, I just need to select the database engine, and then fill in "machine nameSQLEXPRESS" 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, the database attached in 2005 cannot be attached by 2000.
Q: ms sql 2005 Can the database be imported (restored or restored) into ms sql 2000?
A: You can generate database scripts in SQL 2005. Note that when generating, you must 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. That's it.
Q: How to set the user name and password of SQL Sever2005?
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
Upgrading to SQL Server 2005