SQL Server 2000 installation program configuration server failed
C651363574 | category: Database
| Browsed 24187 times |
This problem has been merged into> Adoption by netizens
The first method encountered a very BT problem when installing SQL Server 2000 today, prompting that the installation program failed to configure the server. For more information, see Server Error Log and c: \ windows \ sqlstp. log. Just remove the installed directory from the installation directory, but this is the case after the restart five times (I am really patient-_-;) to Baidu, I found a solution in a blog comment. Step 1: remove the prompt "previous installation of a program that has created a pending file on the computer" (otherwise you need to restart the machine) to open the Registry Editor, find the pendingfilerenameoperations project in HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Control \ Session Manager and delete it. In this way, you can clear the temporary installation project. Step 2: Start the installation program. The difference is that when installing, select "advanced options", click "rebuild registry key", and then continue the installation. The directory continues to specify the last installed directory, in this way, the installation is successful. In the second method, "server configuration failed. Please refer to the System Log description" and the installation progress bar are returned. If it is a Windows XP system, you can view sqlstp in the C: \ Windows directory. log File, which contains error information. I have encountered several situations and have referred to some network information. The following is an example of failure: sqlstp. error message in the log file: Is it in connection with the service? Driver = {SQL Server}; server = zhl; uid = sa; Pwd =; database = Master [Microsoft] [ODBC driver manager] sqlallochandle on SQL _hdriver = {SQL Server}; server = zhl; uid = sa; Pwd =; database = Master [Microsoft] [ODBC driver manager] sqlallochandle on SQL _hdriver = {SQL Server}; server = zhl; uid = sa; Pwd =; database = Master [Microsoft] [ODBC driver manager] sqlallochandle on SQL _hsql server configuration of the driver? ###################### 13:40:06 process exit code: (-1) 13:40:09 the installation program fails to configure the server. For more information, see Server Error Log and c: \ winnt \ sqlstp. log. 13:40:09 action cleanupinstall: solution: When this error occurs, try to reinstall the System File: fix the system instead of installing it completely. After the system file is repaired and the SQL Server is installed again, the error message will not appear. My computer is Win2000. Run the Win2000 installation again under DOS, and then select repair, instead of installing and repairing the system files and then installing SQL server, this error message will not fail. Scenario 2: sqlstp. error message in log file: in? 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) the installation program fails to configure the server at 17:17:45. Refer to the server error log and when this error occurs, you must install the ODBC Repair Tool: 211.101.4.50/download/canyin/tools/mdac_typ.exe I did not find the ODBC driver installation content in "Data Source (ODBC)" under "Administrative Tools. This problem occurs because some programs that use the ODBC Data Source will delete the ODBC driver information during uninstallation. Later, we only need to use odbcconf.exe to re-register the ODBC driver. There are several script files in the Windows/system32 directory to complete the registration of the driver: odbcconf.exe/S/LV odbcconf. log/F % SystemRoot % \ system32 \ mdaccore. RSP odbcconf.exe/S/LV odbcconf. log/F % SystemRoot % \ system32 \ sqlclnt. RSP odbcconf.exe/S/LV odbcconf. log/F % SystemRoot % \ system32 \ odbcconf. RSP odbcconf.exe/S/LV odbcconf. log/F % SystemRoot % \ system32 \ redist. RSP registers the ODBC driver by running the preceding command in the doscommand line. Error 3: sqlstp. error message in log file: Driver = {SQL Server}; server = Soyo; 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 (wrapperread ()). driver = {SQL Server}; server = Soyo; uid = sa; Pwd =; database = Master [Microsoft] [odbc SQL Server Driver] [Shared Memory] General Network errors. [Microsoft] [odbc SQL Server Driver] [Shared Memory] connectionread (wrapperread ()). driver = {SQL Server}; server = Soyo; uid = sa; Pwd =; database = Master [Microsoft] [odbc SQL Server Driver] [Shared Memory] General Network errors. [Microsoft] [odbc SQL Server Driver] [Shared Memory] connectionr ########################## ###### 13:50:07 process exit code: (-1) the installation program fails to configure the server at 13:50:10. For more information, see Server Error Log and c: \ winnt \ sqlstp. log. 13:50:10 action cleanupinstall: this problem is said to be a bug in SQL Server, mainly because the computer name contains lowercase letters. Change the computer name to uppercase. You can call the Control Panel to modify the computer name, or call the Registry Editor. For example, if you want to change the computer name from 'holyrong 'to 'holyrong', you can perform the following operations: in the Registry (CMD --> Regedit) open HKEY_LOCAL_MACHINE \ SYSTEM \ currencontrolset \ Control \ computername, and change the value of the primary key named 'computername' from the original 'holyrong 'to 'holyrong ', it takes effect after you log out of the user or restart Windows.
Comment (4) |
Agree with 14
Zhone01
| Level 4 collection rate: 16%
Good at: Database DB
Sort by default | sort by Time
Other 1 answer 2012-05-11 11: 50inhope | level 4
I adopted the first method: Step 1: remove the prompt "Create a suspended file operation on the installation computer of a previous program" (otherwise you need to restart the machine) open the Registry Editor, find the pendingfilerenameoperations project in HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Control \ Session Manager, and delete it. In this way, you can clear the temporary installation project. Step 2: Start the installation program. The difference is that when installing, select "advanced options", click "rebuild registry key", and then continue the installation. The directory continues to specify the last installed directory, the installation is successful.