SQL Server Installation Error

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

Error re-occurrence: firstly, the sqlserver software is uninstalled on the control panel, everything is normal, and then restart (you must restart it; otherwise, you cannot reinstall it). Execute the sqlserver installation program and everything seems to be normal, after the installation is complete, the system prompts "installation program configuration server failed ".

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 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://www.jb51.net/softs/20587.html
Failure 3:
Working with 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://www.jb51.net/softs/20587.html

Failure 4:

Working with service?
Driver = {SQL server}; server = *****-***********; UID = sa; PWD =; database = master
[Microsoft] [odbc SQL Server Driver] [SQL Server] user 'sa' login?
Driver = {SQL server}; server = *****-***********; UID = sa; PWD =; database = master
[Microsoft] [odbc SQL Server Driver] [SQL Server] user 'sa' login?
Driver = {SQL server}; server = *****-***********; UID = sa; PWD =; database = master
[Microsoft] [odbc SQL Server Driver] [SQL Server] user 'sa' login?
SQL Server configuration?
######################################## #######################################
13:23:35 Process Exit Code: (-1)
When this error occurs:
Delete the junk files left by Microsoft SQL Server when the installation fails.
1) Click start --> Run --> enter regedit
2) Expand HKEY_CURRENT_USER \ Software \ Microsoft \ ms SQL Server
3) Right-click MSSQLServer or ms SQL Server and choose delete
4) Expand HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ ms SQL Server
5) Right-click MSSQLServer or ms SQL Server and choose delete
6) Go to c: \ Program Files
7) Right-click Microsoft SQL Server and choose delete from the shortcut menu.
8) enter d: \ Program Files
9) Right-click Microsoft SQL Server and choose delete from the shortcut menu.

Note: Some common problems are also mentioned:

(1) When the MDAC component fails to be installed, try to repair or reinstall microsoft office.
(2) When you want to reinstall SQL server and the prompt "your computer has an instance installed" appears during installation, you can delete the program files \ Microsoft SQL Server folder, then install.

(3) 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 ).

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.