SQL Server installation error, Setup configuration Server failed solution Summary _mssql2005

Source: Internet
Author: User
Tags driver manager odbc sql server driver mssqlserver odbc sql server driver server error log
Error recurrence: First in the Control Panel uninstall SQL Server Software, all normal, and then reboot (must reboot, otherwise can not reload), execute SQL Server installation program, everything seems to be normal, the next step, installed to the end, suddenly prompted the "Setup configuration server failed."

When the setup configuration server fails, you can try to solve the problem by using a method

Recommended Methods:

When installing SQL Server 2000, the installation is almost complete, to the last hint of an error, as shown above, how to solve it, no hurry, please see the following method:



Delete the Microsoft SQL Server folder that was generated from the last installation, usually in the same path as

C:\Program Files\Microsoft SQL Server
D:\Program Files\Microsoft SQL Server


Note: When you delete a Microsoft SQL Server folder, determine whether the data is backed up, back up and then deleted, and if you accidentally delete it, you can't find it back. The path to the General database folder: D:\Program Files\Microsoft SQL Server\MSSQL\Data is recommended to be backed up first.

Generally can be solved, if not yet resolved, and then follow the following methods:


Click "Start"-"Run, enter: regedit, click OK, open the registry, put HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server and hkey_local_machine\ Software\Microsoft\Microsoft SQL Server All deleted, (note that you want to delete the entire Microsoft SQL Server folder), and then restart. There should be no problem with the reload!


This error message can be found in the system directory, for example, if my system is Win2000, the file is in C:\WINNT\sqlstp.log
Failure One:
Being with the service?
Driver={sql Server};server=zhl; Uid=sa; pwd=;d Atabase=master
[Microsoft] Sqlallochandle on Sql_h of the ODBC Driver Manager driver
Driver={sql Server};server=zhl; Uid=sa; pwd=;d Atabase=master
[Microsoft] Sqlallochandle on Sql_h of the ODBC Driver Manager driver
Driver={sql Server};server=zhl; Uid=sa; pwd=;d Atabase=master
[Microsoft] Sqlallochandle on Sql_h of the ODBC Driver Manager driver
SQL Server configuration?
###############################################################################
13:40:06 Process Exit Code: (-1)
13:40:09 Setup failed to configure the server. Refer to the server error log and C:\WINNT\sqlstp.log for more information.
13:40:09 Action Cleanupinstall:
When this error occurs, try reloading the system file
My machine is Win2000, rerun Win2000 installation in DOS, then choose Fix, not new installation
This error message does not occur after you repair the system files and then install SQL Server
Failure Two:
Being with the service?
Driver={sql Server};server=zhl; Uid=sa; pwd=;d Atabase=master
[Microsoft] [ODBC Driver Manager] does not find a data source
Driver={sql Server};server=zhl; Uid=sa; pwd=;d Atabase=master
[Microsoft] [ODBC Driver Manager] does not find a data source
Driver={sql Server};server=zhl; Uid=sa; pwd=;d Atabase=master
[Microsoft] [ODBC Driver Manager] does not find a data source
SQL Server configuration?
###############################################################################
13:50:07 Process Exit Code: (-1)
13:50:10 Setup failed to configure the server. Refer to the server error log and C:\WINNT\sqlstp.log for more information.
13:50:10 Action Cleanupinstall:
When this error occurs, it is because in the registry you have deleted the HKEY_LOCAL_MACHINE\SOFTWARE\ODBC about SQL sever in the
Content
You can then choose to repair the registry or install the ODBC Repair tool
ODBC Repair Tool: http://www.jb51.net/softs/20587.html
Failure Three:
Being with the service?
Driver={sql Server};server=zhl; Uid=sa; pwd=;d Atabase=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=;d Atabase=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=;d Atabase=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:45 Setup failed to configure the server. Reference server error Logs and
When this error occurs, you must install the ODBC Repair tool
ODBC Repair Tool: http://www.jb51.net/softs/20587.html

failure Four:

Being with the service?
Driver={sql server};server=*****-*********; Uid=sa; pwd=;d Atabase=master
[Microsoft] [ODBC SQL Server Driver] [SQL Server] user ' sa ' log?
Driver={sql server};server=*****-*********; Uid=sa; pwd=;d Atabase=master
[Microsoft] [ODBC SQL Server Driver] [SQL Server] user ' sa ' log?
Driver={sql server};server=*****-*********; Uid=sa; pwd=;d Atabase=master
[Microsoft] [ODBC SQL Server Driver] [SQL Server] user ' sa ' log?
SQL Server configuration?
###############################################################################
13:23:35 Process Exit Code: (-1)
When this error occurs, the following methods are used:
To remove the junk files that Microsoft SQL Server leaves behind when the installation is unsuccessful
1) Click Start--> run--> input regedit
2) expand HKEY_CURRENT_USER\Software\Microsoft\MS SQL Server
3 Select MSSQLServer or MS SQL Server Press the right button to select Delete
4) Expand Hkey_local_machine\software\microsoft\ms SQL Server
5 Select MSSQLServer or MS SQL Server Press the right button to select Delete
6) into C:\Program Files
7 Select folder Microsoft SQL Server Right-click to select Delete
8) into D:\Program Files
9 Select folder Microsoft SQL Server Right-click to select Delete

Note: There are also some common problems, also mentioned:

(1) Try to repair or reinstall Microsoft Office when an MDAC component installation failure occurs during installation.
(2) When you want to reload SQL Server, and install the "You have installed an instance on your machine" prompt, you can remove the Program Files\Microsoft SQL Server folder, and then install.

(3) When a certain dynamic link file is not found, you can try to find this file in the SQL Server installation file, copied to the system directory in the Systems and System32 folder (in general, when this error message, will be prompted which several folders missing this file).
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.