When SQL Server 2000 is installed, the installation program fails to configure the server. For more information, see Server Error Log and c: \ winnt \ sqlstp. log.

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


InstallProgramAn error occurred while configuring the server. For more information, see Server Error Log and c: \ winnt \ sqlstp. log.



View the log file. The following problems are found:



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?
Solution:



Select the advanced option during installation, and then select to rebuild the registry key;



More questions:



The following error message is displayed when installing SQL Server 2000:
An error occurred while configuring the server for the installer. Refer to the server error log and c: \ winnt \ sqlstp. Log



When you want to reinstall SQL Server and the prompt "your computer has an instance installed" appears, you can delete the Program Files \ Microsoft SQL Server folder and registry information, then install.
 
XX Dynamic Link file not found



When a dynamic link file cannot be found, try to find the file in the installation file of SQL Server, copy the file 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)



When the installation 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 windowxp, the file is stored in c: \ windows \ sqlstp. log.
The following are three possible errors:


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)

At 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:

When this error occurs, try to reinstall the system file.

My machine is Win2000, and I re-run Win2000 installation under DOS, and then choose to fix it, instead of completely installing

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)

At 13:50:10, the installation program fails to configure the server. For more information, see Server Error Log and c: \ winnt \ sqlstp. log.

13:50:10 action cleanupinstall:

This error occurs when HKEY_LOCAL_MACHINE \ SOFTWARE \ ODBC is deleted from the registry.


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)

At 17:17:45, the installation program fails to configure the server. For more information, see Server Error Log and c: \ windows \ sqlstp. log.

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 or install the ODBC Repair Tool.
ODBC Repair Tool: 211.101.4.50/download/canyin/tools/mdac_typ.exe


Check the sqltp. log file generated on my machine. The second error is found.



I did not find the content for installing ODBC driver 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



By running the preceding command in the doscommand line, the ODBC driver is registered.
ODBC is good, but the re-installation of SQL has the same problem as the first time. I started to feel a little discouraged, and then I put the installation disk into it, I found that there was an advanced option during installation. I clicked it and checked the rebuild registry option. So I backed up the registry and chose this option again, as a result, My SQL can be used this time. I am very happy for several days.



If the installation fails after the "advanced options", we recommend that you run the SQL Server Installation program again. This time, select the "upgrade, delete, or add components to an existing SQL server instance" item, "Add a component to an existing installation ". After the installation is complete, Run "Enterprise Manager". If you select "SQL Server and Windows ", the user-defined secret is entered during the "advanced options" Installation Process (note that the authentication method is not selected during the "add component installation" process) when registering SQL Server, the following problems may occur:
---------------------------
SQL Server Enterprise Manager
---------------------------
Unable to establish connection with Zou.



Cause: User 'sa 'Login Failed ..



Verify that SQL server is running and check SQL Server Registration attributes (by right-clicking the Zou node), and then try again.
---------------------------
OK
---------------------------



If the SA password is blank when you create SQL Server registration, the registration is successful.
Is it because the SA password set during the original installation has been changed during the "add component installation" process and is set to null?


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.