SQL Server Installation Error installation program configuration server failure (solution)

Source: Internet
Author: User
Tags driver manager sql server driver odbc sql server driver server error log
This problem was encountered by many people on the Internet. A netizen appeared in the morning and searched for it,
Google has been around for a long time, and many solutions won't work,
This error may occur in many cases. The answer is as follows:
Http://www.blueidea.com/bbs/NewsDetail.asp? Id = 1015901

The original article is reproduced:

/*************************************** **********/

When the MDAC component fails to be installed, try to repair or reinstall Microsoft Office

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 then install

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 installation occursProgramWhen the server configuration fails, 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)
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:
When this error occurs, it is because the SQL Sever

Content
You can fix the registry or install the ODBC Repair Tool.
ODBC Repair Tool: http: // 211.101.4.50/download/canyin/tools/mdac_typ.exe

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. Refer to server error logs and
When this error occurs, you must install the ODBC Repair Tool.
ODBC Repair Tool: http: // 211.101.4.50/download/canyin/tools/mdac_typ.exe

Conclusion: You must carefully check the log file and find the cause of the error. To solve this problem ~~

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.