Prompt "command line option syntax error! when installing SQL Servre2000 Type command/? For help "

Problem:

when the program is installing the MS Data Access component, the error prompt appears: command line option syntax Error,type command/? , click OK to continue; When the program is installing HTML Help, the pop-up header is the HTML helper 1.32 update error prompt box: command line option syntax Error,type command/? Click OK to continue; The program starts copying files, and the error box pops up after copying: Unable to find the dynamic Connection Library Sqlunirl.dll (Sqlunirl.dll is a component of MDAC), after the specified path point is determined, the Setup program stops running, please review the installation log.

Solve:

The reason is that SQL Server installation files in the Chinese directory, the SQL Server installation files to the English directory, and then run the installation program, such as: D:\ software \sqlserver "Software" removed.

Note:

MDAC (Microsoft Data Access Components) is a Microsoft Database access component, and netpise and many software that utilize the database require the operating system to install MDAC. MDAC already exists in many users ' operating systems, some of which are built into the operating system and some are installed by other applications.

Other:

Computer Installation SQL error: Command line option Syntax error!type command/? For help, it is said that the installation directory is caused by Chinese, but I checked several times my installation directory is indeed in English.

I. Status Note

SQL Server 2000, such as the previous version, for example, 7.0 does not have multiple versions, only the standard version and the desktop version, if the user does not know what version to install, you can follow the installation of the installation prerequisites to indicate installation, generally in the WIN2000 server version of the standard version, the other system installed on the desktop version can be , and the SQL Server 2000 installation problem is relatively large, and the frequently encountered problems are as follows:

1. Interrupt when configuring the server.

2. Interrupt when registering ActiveX.

3, display to 100% when the interruption.

4. Hint: Command line option syntax error, type command/? For help, continue the installation, and finally appear when configuring the server: Cannot find dynamic link

Sqlunirl. DLL in the specified path ...

5. The previous program created a pending file operation and must be restarted before running the Setup program

Ii. solutions to the situation of the two-way:

Reminder: To avoid misoperation, back up the registry and database before SQL Server 2000, you can back up c:program Files\Microsoft SQL Server\MSSQL\Data

(the default path) file for the folder.

1), the first uninstall SQL Server (uninstall does not go off also have no relationship, continue the following operation);

2), delete the entire Microsoft SQL Server folder;

3), run the registry, delete the following:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server

HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer

Hkey_local_machine\system\currentcontrolset\services\mssqlserver

Hkey_local_machine\system\currentcontrolset\services\sqlserveragent

Hkey_local_machine\system\currentcontrolset\services\mssqlserveradhelper

HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server

4), if necessary, restart the system;

5), reinstall.

Alternatively, you can try a single-step operation to install SQL Server 2000:

1), put the SQL Server 2000 CD.

2), in "Start"--"Run" type "F:\x86\setup.exe k=dbg" (F is a disc)

Attention:

1), different operating systems support the version of SQL Server 2000 (see: SQL Server 2000 version of the differences in the introduction and version of the query article).

Windows Update server can install any version of SQL Server 2000.

Windows Professional can only install personal, dev, evaluation, MCDE, SQL Server 2000

2), versions of SQL Server 2000, and requirements for hardware and software (see: SQL Server 2000, HW and SW installation requirements article).

Iii. Solutions to Situation 4

Because the path to the installation file (full path) is in Chinese.

For example, C:\SQLSERVER Chinese Enterprise Edition \

Change into c:\SQLSERVER\

Iv. Solutions to Situation 5

1), restart the machine, and then install, if found that the error, please follow the steps below;

2), in the beginning-operation of the input regedit;

3), to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager location found

PendingFileRenameOperations the project and delete it. This allows you to clear the Install pending project.

4), select File--Pour out, save;

5), right click on the right window pendingfilerenameoperations, select Delete, and then confirm;

6), restart the installation, problem solving

Five, if the problem is still, try to repair the operating system first:

At the command prompt, execute: sfc/scannow.

The last method: Change the Windows 2000 Setup disk and the SQL Server 2000 Setup disk, sometimes the problem is very strange, someone has replaced a power supply to solve the problem.

1), uninstall your SQL Server 2000 first, delete Program Files\Microsoft SQL Server folder when necessary;

2), open the registration form;

In Start-run, type RegedIT

3), click on the following order to open;

+ HKEY_LOCAL_MACHINE

+ Softwart

+ Microsoft

+ Windows

+ CurrentVersion

+ Setup

+ exceptioncomponents

4), delete all the folders below the exceptioncomponents;

such as {60BFF50D-FB2C-4498-A577-C9548C390BB9}

{60BFF50D-FB2C-4498-A577-C9548C390BB9}

{60BFF50D-FB2C-4498-A577-C9548C390BB9}

{60BFF50D-FB2C-4498-A577-C9548C390BB9}

5), restart;

6), reinstall SQL Server 2000.

Vi. Other Notes

1), the SQLstp.log file in the Windows directory, which lists the details of the actions performed by the installer and includes any errors encountered during installation.

By examining the file, you can learn more about where the installation failed and why it failed.

2), SQL installation error information is saved in a log file called Errorlog, by default, the file is located in Program Files\Microsoft SQL Server\mssql\log

The directory. This error log contains errors that Sql-server encountered when the installer tried to start Sql-server, which can help you drill down into the cause of the error.

3), another component that needs to be checked is the Microsoft Data Access Component (MDAC) installer, which is started as part of the sql-server2000 Setup program.

The sql-server2000 installer installs the MDAC2.6. The MDAC setup program creates a separate log file named DASEtup.log; You can view this log file and ensure that the MDAC

The Setup program does not have a problem.

SQL or MSDE installation issues-command line option syntax error. Typ

SQL 2000 installation Issue--command line option syntax error

When the Setup program is installed to:

Setup is installing the MS Data access component

, the screen appears with an error message:

---------------------------

SQL Redist

---------------------------

Command line option syntax error. Type Command/? For help.

---------------------------

Are you sure

---------------------------

Then click OK to continue, Setup starts copying files, and after copying the files, an error message appears:

Unable to find the dynamic Connection library Sqlunirl.dll to the specified path "... \sqlunirl.dll" (Super Long Path!) ）

Click OK after Setup stops running to view the installation log.

Workaround:

The cause of this problem is that SQL Server installation files are placed in the Chinese directory.

Copy the installation file of SQL Server to the English directory and install it on OK

For example, to:

The "installation disk" in the "D:\Sqlserver installation Disk" is removed. It's all right!

What the? Or not?! Don't worry, hey.

Let's see if your username is in Chinese and change it to English. This user name refers to the user name that you use when you log in to Windows, and the default is administrator.

You do not give up the modification of this user name? Then re-create an English user, log in with this user and then install the line.

Let's talk about why:

The software will be unpacked at the time of installation, generate some temporary files, the system calls these files to install. Sometimes these files are placed in the current directory, sometimes in the "C:\Documents and Settings\ user name \local Settings\Temp" folder, this time if your "user name" is in Chinese, it may fail. It seems to support Chinese is not good enough ah! Helpless!

Translated from: http://hi.baidu.com/ncicnkzonpkmqvr/item/599526fe284cec18e2e3bd1b