Common failures that SQL Server cannot start

Common failures that SQL Server cannot start

-- Has the operating system password been changed?

-- Solve the problem that SQL cannot be started due to changing the operating system password:

1.
My computer -- control panel -- Administrative Tools -- service -- Right-click MSSQLServer -- properties -- login identity -- select "Local SYSTEM account"

Or:
2.
My computer -- control panel -- Administrative Tools -- service -- Right-click MSSQLServer -- properties -- login identity -- select "this account" -- enter your modified administrator password in the password and Confirm Password.

 

Differences between the two:
Select the first method. The administrator password will be changed later. You do not need to adjust the password (but the system administrator is required to log on to the operating system)

Select the second method, modify the administrator password later, and repeat the above operation.

------------------------------------------------------------------------

2. Have you modified the computer name?
If the computer name is modified, place it on the SQL installation disc and execute the installation.ProgramRepair (the repair process is automatically performed. Follow the prompts to perform the operation without damaging the data)

------------------------------------------------------------------------

3. Check whether your installed version is evaluated? If yes, it may have expired. install an official version.
The check method is to install SQL SP3. If it is an evaluation version, an error will be prompted, and it cannot be installed.

Related downloads:

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? Downloads = 1 & id = 134

FTP: // 202.120.120.240/--- ++ warez ++ ---/by % 20 Company/Microsoft/SQL/SQL % 20 server % 202000% 204in1cn. ISO

Ftp://youngcow.net/Special/Database/DatabaseServer/MSSQLServer/2000/ SQL %20Server%202000%204in1en.iso

If the preceding URL cannot be downloaded, go to e.pku.edu.cn to search

SQL patch:
'Location Of All Patches
Http://www.microsoft.com/downloads/details.aspx? Displaylang = ZH-CN & familyid = 9032f608-160a-4537-a2b6-4cb265b80766

------------------------------------------------------------------------

4. Check the operating system log to see if there are any instructions.