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!