An error occurred while installing SQL. An error occurred while configuring the server.

Source: Internet
Author: User
Two days ago, I had a problem with my local SQL!
The installation fails, but I did not pay attention to it. I always thought it was an SQL installation suspension problem. Later I found it was "installation ". Program An error occurred while configuring the server. I found it online. I hope it will help you!

[Convert to intimateArticleFrom the classic Forum-computer technology]

SQL Server 2000 installation error, unable to find the dynamic link library sqlunirl. dll
The Installation File is certainly correct, because it has been installed before and can be used

The machine was installed with SQL Server 2000 and can be used normally. It was just today that it was suddenly unable to connect to the local database and planned to reinstall it. I deleted the ms SQL directory in program files, then re-install the SQL statement. The result is prompted at the last step. The configuration cannot be completed. Later, I deleted some SQL Server Information in the Registry (with a backup note table). When I installed it again, this prompt appeared. Worse, the backup registry cannot be restored.

======================================
Now the problem has been solved and some experiences have been summarized.

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

My problem was solved by deleting the SQL Installation File under program files and then reinstalling it. The specific problem was fixed and then supplemented!

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.