The SQL Server 2000 Service cannot be started, and the system prompts "the system cannot find the specified file" solution and SP4 cannot be installed.

Source: Internet
Author: User

 

Because of the need, SQL2000 has been installed on another computer, and a patch of big SP4. Previously, these patch installation operations had not encountered any problems on your computer, and they were handled smoothly! (Happy!) but today I am trying to solve the problem when installing and patching on someone else's computer. What a little bit more! (That is, a word: miserable) there is no problem with installing SQL2000. All the way to the green light, they are laughing. But the problem lies in the installation process of the next patch. The patch has not been successfully installed. First, I cannot start the 2000 that has been successfully installed. If I have already started the patch, I can't find the file. Baidu just clicked it, the problem turned out to be that the installed files were modified during patching. Symptom: the SQL Server service manager cannot start the SQL statement. The system prompts "the specified file cannot be found ". The cause is:
The sqlservr.exe file in the SQL installation directory (X: \ x. x \ Microsoft SQL Server \ MSSQL \ binn] is missing or the suffix is modified.

Solution:

1. copy the file from another host. The file size is 8.72 MB;

2. Find sqlservr.lin the bindirectory (this should be a malicious modification. If it is incorrect, convert it to sqlservr.exe with a size of 8.72.

 

Okay, this problem has been solved, but my goal is to add the patch and pull the problem again,

Symptom:

The xxx file is not used. What other XXX files do not exist?

Cause:

The patch is incomplete or damaged. The anti-virus software is enabled or the SQL service is not disabled.

Solution:

Download the complete patch (http://www.xdowns.com/soft/38/110/2006/soft_34181.html, which is useful here), disable SQL services, and disable anti-virus software such as 360. Close from task manager. It is best to disconnect the network.

Finally, how can I check whether SP4 is successfully installed?

Use the following command:
Select @ version
The query result is as follows:
Microsoft SQL Server 2000-8.00.2039 (Intel x86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Personal Edition on Windows NT 5.1 (build 2600: Service Pack 2)

This indicates that the operation is successful!
In fact, in c: \ Program Files \ Microsoft SQL Server \ MSSQL \ binn \ sqlservr.exe
You can also right-click to view the version, but the information is simple. 8.00.2039 indicates that SP4. is installed.

 

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.