The server version of sql2000 is 8.0, and sql2005 is 9.0.
First, read the required configurations for installation (see the notes below)
1. I installed 2000 first and installed it with the sp4 patch (sa password should not be too simple)
1.then, when installing SQL, you only need to find the setup.exe installation in the toolsdirectory. After the installation, there will be an SQL Server Management Studio, which is the Enterprise Manager of sql2000,
2. Many people cannot connect to the SQL Server Management Studio2005 Database. At the beginning, I tried a lot,
In fact, you only need to select the database engine and enter "machine name SQLEXPRESS" in the server name. If your machine name is haha, then "hahaSQLEXPRESS". The authentication method is based on your needs, point connection can be connected to the SQL database engine. If you have a custom service name, replace SQLEXPRESS with your custom service name.
When I attach a database, the database that is appended with MySQL 2005 cannot be appended with MySQL 2000.
Q: Can ms SQL 2005 databases be exported to (restored or restored) ms SQL 2000?
A: You can generate A database script in SQL 2005. Note that when generating the script, you need to generate the script for SQL 2000 and then use this script in MySQL 2000 to create the target database, import/export the data from 2005 to 2000.
Q: How should I set the user name and password for 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
Precautions for installing SQL Server
Upgrade SQL Server 2005
