I. This is the simplest and most direct method, and it is very effective. Please be patient carefully. If it fails, try it several times. When installing SQL, from time to time, I will always prompt that the installation program has been suspended, causing me to install the system for N times, and I will not go to bed until three o'clock a few nights ago, finally, I checked a lot of information on the Internet and summarized it as follows.
I. This is the simplest and most direct method, and it is very effective. Please be patient carefully. If it fails, try it several times. When installing SQL, from time to time, I will always prompt that the installation program has been suspended, causing me to install the system for N times, and I will not go to bed until three o'clock a few nights ago, finally, I checked a lot of information on the Internet and summarized it as follows.
I. This is the simplest and most direct method, and it is very effective. Please be patient carefully. If it fails, try multiple times.
For a long timeInstallSQL always prompts from time to timeInstallThe program was suspended, causing me to install the system for N times. I slept at three o'clock a few nights ago. Finally, I checked a lot of information online and summarized it as follows, hope to help you:
After the SQL server is down on the server today, it is re-installed. You can tell me which dog P program is suspended and you have to look for details.CauseSorry, I finally found out the cause of my illness. K. I want to know that it is so simple that I will no longer install the system ..... the details are as follows. Make a backup so that you can check similar problems in the future!
1. Run yourInstallProgram. When the message is pending, click "OK". Remember not to exitInstallProgram, use ALT + Tal to switch, Click start to run, and enter regedit to open the Registry
2. Find the HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Control/Session Manager directory.
3. Delete "PendingFileRenameOperations" (here, we will describe that the PendingFileRenameOperations file is on the right side of Session Manager, that is, when you click Session Manager, you will see it on the right side)
4. Disable the registry.
5. Start againInstallSQL Server 2000, everything is OK. Easy to use
6. The problem has been solved. Haha (if the above steps fail to solve your problem, please continue later)
2. I am in WIN2003InstallSQL2000, skip "... SQL2000SP2NoInstallIn WIN2003... "prompt, click Continue, and so onInstallAfter that, enter SP3 immediately. No problem!
Just inInstallThis error occurs during the process:
InstallFailed to configure the server. For more information, see server error logs and C:/WINNT/sqlstp. log.
The final error message in sqlstp. log under the WINNT directory is as follows:
Starting?
Chinese_PRC_CI_AS
-M-Q-T4022-T3659
Working with service?
Driver = {SQL server}; server = GH; UID = sa; PWD =; database = master
[Microsoft] [odbc SQL Server Driver] [Shared Memory] A general network error occurs.
[Microsoft] [odbc SQL Server Driver] [Shared Memory] ConnectionRead (recv ()).
Driver = {SQL server}; server = GH; UID = sa; PWD =; database = master
[Microsoft] [odbc SQL Server Driver] [Shared Memory] A general network error occurs.
[Microsoft] [odbc SQL Server Driver] [Shared Memory] ConnectionRead (recv ()).
Driver = {SQL server}; server = GH; UID = sa; PWD =; database = master
[Microsoft] [odbc SQL Server Driver] [Shared Memory] A general network error occurs.
[Microsoft] [odbc SQL Server Driver] [Shared Memory] ConnectionRead (recv ()).
SQL Server configuration?
######################################## ############
09:23:53 Process Exit Code: (-1)
09:24:14InstallFailed to configure the server. For more information, see server error logs and C:/WINNT/sqlstp. log.
09:24:14 Action CleanUpInstall:
09:24:14 C:/WINNT/TEMP/SqlSetup/Bin/scm.exe-Silent 1-Action 4-Service SQLSERVERAGENT
09:24:14 Process Exit Code: (1060) the specified service is notInstall.
09:24:14 C:/WINNT/TEMP/SqlSetup/Bin/scm.exe-Silent 1-Action 4-Service MSSQLSERVER
09:24:14 Process Exit Code: (0)
09:24:14 StatsGenerate returned: 2
09:24:14 StatsGenerate (0x1, 0xf0000000, 0 x, 2052, 303,0 x, 0, 0
09:24:14 StatsGenerate-1, Administrator)
09:24:14 Installation Failed.
Solution:
FirstInstallThe Microsoft SQL Server folder under the Directory and C:/Program Files is deleted and all information about microsoft SQL server under current_user and local_machine/software/Microsoft/is deleted.
1 open the Registry
In "start" -- "run", type "regedit"
2. Click to open in the following order
+ HKEY_LOCAL_MACHINE
+ Softlinks
+ Microsoft
+ Windows
+ CurrentVersion
+ Setup
+ Predictioncomponents
3. delete all the folders under predictioncomponents!
For example, {60BFF50D-FB2C-4498-A577-C9548C390BB9}
{60BFF50D-FB2C-4498-A577-C9548C390BB9}
{60BFF50D-FB2C-4498-A577-C9548C390BB9}
{60BFF50D-FB2C-4498-A577-C9548C390BB9}
.......
4 restart:
5. Try againInstallSQL Server 2000
In addition, the following statement is displayed on a BLOG:
ProblematicCause:
This is a SQL server bug. GetComputerName is used to obtain the name of a local computer. The client network library component (DBMSLPCn. dll) converts the name to all uppercase letters. The server network library component (SSMSLPCn. dll) retains the name returned.
When Windows computer names contain uppercase letters, lowercase letters, or both lowercase lettersInstallA general network error is prompted!
The solution is to change the computer name to uppercase!
I changed the name of my computer to uppercase, and then restarted. The network error problem just now was gone. But I am prompted to log on to sa failed. It's strange. I try again.InstallThe specified password is empty. How can this problem be solved?InstallWhat if the program fails to log on to the sa itself? Later I remembered that the purpose of uninstalling SQL Server was to keep my data, so I was lazy and did not put the original SQL ServerInstallDelete files in the Data folder under the directory. Both master. mdf and master. ldf are located. In the past, the SQL Server had a password. As a result, these two files are quickly deleted. Try againInstallOnce, OK!InstallSuccessful.
Summary:
1. In the future, the computer name must be capitalized to avoid unnecessary troubles.
2. When you reinstall SQL Server, remember to delete master. mdf and master. ldf.
Note: My computer name is also in lowercase, but I did not change it to uppercase, just in SQLInstallIn the process, the username is changed to uppercase, and then the folder is deleted and the Registry is cleared.InstallI think the above statements are worth exploring!
The following also collect some SQL2000InstallSome solutions to program configuration server failure:
1. SQL server 2000InstallError. Unable to find the dynamic link library sqlunirl. dll
InstallFile is certainly not wrong, because the previousInstallYes, it can be used. The host was installed with SQL server 2000 and can be used normally. It was just today that it was suddenly unable to connect to the local database and was intended to be reinstalled, I deleted the ms SQL directory in program files and re-installed the SQL. The result is prompted at the last step, and the configuration cannot be completed. Later, I deleted some SQL server Information in the Registry (with a backup note table ).InstallThis prompt appears. Worse, the backup registry cannot be restored.
======================================
Now the problem has been solved and some experiences have been summarized.
WhenInstallMDAC component appearsInstallWhen a failure occurs, try to repair or reinstall microsoft office.
When you want to reinstall SQL serverInstallThe following error occurs:InstallWhen an "instance" prompt is displayed, you can delete the program files/Microsoft SQL Server folder, and thenInstall
When a dynamic link file cannot be found, tryInstallFind this file in the file and copy it to the system and system32 folders in the system directory. (when this error message is displayed, the system prompts which folders do not contain this file)
WhenInstallWhen the program fails to configure the server, try to solve it
This error message can be found in the system directory. For example, if my system is win2000, the file is stored in C:/WINNT/sqlstp. log.
Failed 1:
Working with service?
Driver = {SQL server}; server = ZHL; UID = sa; PWD =; database = master
[Microsoft] [ODBC driver manager] SQLAllocHandle on SQL _H of the driver
Driver = {SQL server}; server = ZHL; UID = sa; PWD =; database = master
[Microsoft] [ODBC driver manager] SQLAllocHandle on SQL _H of the driver
Driver = {SQL server}; server = ZHL; UID = sa; PWD =; database = master
[Microsoft] [ODBC driver manager] SQLAllocHandle on SQL _H of the driver
SQL Server configuration?
######################################## #######################################
13:40:06 Process Exit Code: (-1)
13:40:09InstallFailed to configure the server. For more information, see server error logs and C:/WINNT/sqlstp. log.
13:40:09 Action CleanUpInstall:
When this error occurs, try to reinstall the system file.
My machine is win2000, and I re-run win2000 in dosInstallAnd then select repair, instead of brand newInstall
After the system file is repaired and SQL server is installed, the error message is not displayed.
Failure 2:
Working with service?
Driver = {SQL server}; server = ZHL; UID = sa; PWD =; database = master
[Microsoft] [ODBC driver manager] No data source found
Driver = {SQL server}; server = ZHL; UID = sa; PWD =; database = master
[Microsoft] [ODBC driver manager] No data source found
Driver = {SQL server}; server = ZHL; UID = sa; PWD =; database = master
[Microsoft] [ODBC driver manager] No data source found
SQL Server configuration?
######################################## #######################################
13:50:07 Process Exit Code: (-1)
13:50:10InstallFailed to configure the server. For more information, see server error logs and C:/WINNT/sqlstp. log.
13:50:10 Action CleanUpInstall:
When this error occurs, it is because the SQL Server Content in HKEY_LOCAL_MACHINE/SOFTWARE/ODBC is deleted in the registry.
You can fix the registry, orInstallODBC Repair Tool.
Failure 3:
In connection with the service?
Driver = {SQL server}; server = ZHL; UID = sa; PWD =; database = master
[Microsoft] [odbc SQL Server Driver] [Named Pipes] connection?
[Microsoft] [odbc SQL Server Driver] [Named Pipes] ConnectionRead (ReadFile ()).
Driver = {SQL server}; server = ZHL; UID = sa; PWD =; database = master
[Microsoft] [odbc SQL Server Driver] [Named Pipes] connection?
[Microsoft] [odbc SQL Server Driver] [Named Pipes] ConnectionRead (GetOverLappedResult ()).
Driver = {SQL server}; server = ZHL; UID = sa; PWD =; database = master
[Microsoft] [odbc SQL Server Driver] [Named Pipes] connection?
[Microsoft] [odbc SQL Server Driver] [Named Pipes] ConnectionRead (GetOverLappedResult ()).
SQL Server configuration?
######################################## #######################################
17:17:41 Process Exit Code: (-1)
17:17:45InstallFailed to configure the server. Refer to server error logs and
Required when this error occursInstallODBC Repair Tool
In additionInstallThis error occurs during the process:
SQL Installation
SQL Redist
Command line option syntax error
Type command /? For help
I don't know what it is.CauseBut it does not affectInstall, Click OK to continue.CauseStill not clear !???
<<
1. Set the SQL statement under Program filesInstallDirectory deletion (if important data exists, back up the data first)
C:/Program Files/Microsoft SQL Server/80/Tools.
C:/Program Files/Microsoft SQL Server/MSSQL.
2. Delete related information in the registry:
HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/MSSQLServer.
HKEY_LOCAL_MACHINE/System/CurrentControlSet/Services/MSDTC.
3. Find the PendingFileRenameOperations project in HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Control/Session Manager and delete it. In this way, you can clearInstallTemporary Projects
4. HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Windows/CurrentVersion/setup
Delete predictioncomponents
There may be a lot of content in this project, and this method can be used only when the above methods are not feasible (Be sure not to delete all)
Before deleting the content, read the description.
5. The Sqlstp. log file in the Windows directory, which is listedInstallDetailed information about the operations performed by the program, includingInstallAll errors encountered during this period. Check this file to learn moreInstallWhere and why.
6. SQLInstallThe error information is stored in a Log file named Errorlog. By default, the file is located in the Program Files/Microsoft SQL Server/Mssql/Log directory. This error log containsInstallErrors encountered by SQL Server when the program tries to start SQL Server. These information can help you thoroughly check errorsCause.
7. Another component to be checked is the Microsoft Data Access Component (MDAC)InstallProgram, which acts as SQL Server 2000InstallStart part of the program. SQL Server 2000InstallProgram MEETINGInstallMDAC 2.6. MDACInstallThe program will create a separate log file named Dasetup. log. You can view this log file and ensure that the MDACInstallThere is no problem with the program.
The following describes how to completely delete an SQL statement:
Http://blog.csdn.net/sxycgxj/archive/2006/04/26/677695.aspx
Http://blog.csdn.net/sxycgxj/archive/2005/09/30/492690.aspx
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>>>>>