1. The 64-bit operating system is incompatible and cannot be installed. solution:
Because the SQL Server 2000 software is 32-bit, it may be incompatible with the 64-bit system. If you install it in another way, this problem will be solved.
If the 64-bit Windows 7 operating system is used, the "incompatible prompt" may pop up to guide you how to install 32-bit SQL Server 2000. If no prompt is displayed, perform the following operations:
My SQL Server 2000 installation package is under "D: \ clsw \ Microsoft SQL Server 2000", which is a four-in-one version, and then enters the version folder you want to install (personal is a personal version; standard is the Standard Edition; developer is the development edition; enterprise is the Enterprise Edition). Here, the Personal Edition is used as an example to go to "D: \ clsw \ Microsoft SQL Server 2000 \ personal \ x86 \ setup, click to run "setupsql. EXE ", and then install it step by step.
If "no response", "The instance has been started", or"ProgramPending. Remember: before installation, uninstall the database program software related to SQL server that has been installed on your computer or has not been fully uninstalled.
2. After the installation is complete, it cannot run. There is no solution to the "server" and "service" to be selected.40375363)
After SQL Server 2000 is installed in a 64-bit win7 operating system, it cannot run. If no "server" or "service" is to be selected, right-click the "Service Manager" shortcut for starting the Database Service and select "Run as administrator.
3. When you connect to the program and database through ODBC/JDBC, the error message "the architecture of the driver and application does not match in the specified DSN" is returned.When you connect to the program and database through ODBC/JDBC, the error "the architecture between the driver and the application does not match in the specified DSN" is returned, it is because you use the 64-bit management tool "Data Source (ODBC)" to create the SQL Server database JDBC connection.
Solution: Run "C: \ WINDOWS \ syswow64 \ odbcad32.exe" and use the 32-bit "Data Source (ODBC)" to create a JDBC connection for SQL Server 2000.
4. When the program service is started, the system reports an error in the background: "[Microsoft] [ODBC sqlserver driver] [SQL Server] user 'xxx \ XXX' Logon Failed"
"Using Windows Authentication" to connect to SQL Server fails because the user "XXX \ XXX" does not exist. solution:
A. Open the Enterprise Manager, expand the server group, and then expand the server
B. Expand "security", right-click "Logon", and click "New Logon"
C. In the Name box, enter builtin \ Administrators
D. on the "server roles" tab, select "System Administrators"
E. Click "OK" to exit
F. Add the "XXX \ XXX" user in the same way.
I finally installed the SQL Server 2000 database software in my 64-bit win7 operating system. I hope to help you with my experience!