SQL Server 2000 installation program configuration server failed

Source: Internet
Author: User
Tags driver manager sql server driver odbc sql server driver server error log

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.
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.