SQL Server can't start common faults
- Is there a modified operating system password?
- Modify the operating system password, result in a solution that SQL cannot start:
1. My Computer - Control Panel - Management Tools - Services - Right-Type MSSQLServer - Property - Login - Login Identity - Select Local System Accounts
Or: 2. My Computer - Control Panel - Management Tools - Services - Right-Right-Right-Login - Login Identity - Select "This Account" - Password and Confirm Password Enter your modification Administrator password.
Differences: Select the first way, then modify the Administrator password, no need to adjust (but required to log in the operating system)
Select the second way, and then modify the Administrator password, but also repeat the above operation.
-------------------------------------------------- ----------------------
2. Do you modify the computer name? If you have modified the computer name, put it in the SQL installation CD, perform the installer to fix (the repair process is automatically performed, the prompt operation will do, no data, it is also very fast)
-------------------------------------------------- ----------------------
3. Check if your installation is evaluation version? If so, may have expired, install a formal version. Check method is to install SQL SP3, if it is an evaluation version, there will be error prompts, can not be installed
Related download:
SQL2000 download http://www.bbycn.com/softdown.asp?id=1134
http://61.153.229.54:8000/list.asp?id=134
http://61.153.229.54:8000/download.asp?downid=1&id=134
FTP://202.120.120.240/-- warez ---/BY Company/MICROFT/SQL/SQL Server 2000 4in1cn.iso
ftp://youngcow.net/special/database/databaseServer/msqlserver/2000/sql Server 2000 4in1en.iso
If the above URL cannot be downloaded, search to E.pku.edu.cn
SQL patch: 'All patch location http://www.microsoft.com/downloads/details.aspx?displaylang=zh-cn&familyid=9032f608-160a-4537-a2b6-4cb265b80766
-------------------------------------------------- ----------------------
4. View the operating system log to see if there is a description.