When installing sqlserver2000, the following error occurs: commandlineoptionsyntaxerror, typecomman... sqlserver2000: commandlineoptionsyntaxerror, typecommand? Forhelp solution when the installer is installed to: the installer is installing the ms data access component, the screen
SQL server 2000 installation: command line option syntax error, type comman... SQL server 2000 installation: command line option syntax error, type command /? For help
SQL server 2000InstallMediumAppears: Command line option syntax error, type comman...
SQL server 2000InstallMediumAppears: Command line option syntax error, type command /? For help Solution
WhenInstallProgramInstallTo:
InstallThe program isInstallMs Data Access Component
Time, screenAppearsError message:
Then click OK to continue,
InstallThe program starts copying the file.
AppearsError message:
The dynamic Connection Library sqlunirl. dll cannot be found in the specified path "... \ Sqlunirl. dll "(Super long path !)
Click OK
InstallThe program stops running. View
InstallLogs.
Solution:
The cause of this problem is that SQL Server's
InstallFile in the Chinese directory.
InstallCopy the file to the English directory,
InstallOK
For example:
D: \ Software \ Sqlserver
In the "software" removed. or directly change to "English name", such as "soft,
InstallAfter the SQL statement is completed, change it to the original name.
========================================================== ==================================
If not
Check whether your user name is in Chinese. Change it to English. This user name refers to the user name used when you log on to windows. The default user name is administrator.
Are you reluctant to modify this user name? Create a new English user, log on with this user, and then
InstallThat's all.
The reason is:
Software in
InstallWill first decompress, generate some temporary files, the system calls these files
Install.
Sometimes these files are stored in the current directory and sometimes in the "C: \ Documents ents and Settings \ USERNAME \ Local Settings \ Temp" folder,
At this time, if your "User Name" is Chinese, it may fail. It seems that it is not good to support Chinese characters! Helpless!
========================================================== ============
SQL Server 1069 error (unable to start the service due to logon failure) Solution
The solution is as follows:
Control Panel-> Administrative Tools-> services, find the MSSQLSERVER Service, right-click-> properties-> log on, select "Local SYSTEM account", OK
Then open the enterprise manager again.
Computer
InstallSQL
AppearsError: command line option syntax error! Type command /? For help
All said
InstallThe directory is caused by Chinese characters, but I checked it several times.
InstallThe directory is indeed in English.
I. Description
For SQL Server versions earlier than 2000, for example, 7.0 generally does not have multiple versions. Only the standard version and the desktop version are available. If you do not know what version to install, you can press
InstallOn
InstallPrerequisite instructions
InstallGenerally, the Standard Edition is installed on the WIN2000 Server Edition, and other systems can be installed on the desktop edition; while SQL Server 2000
InstallThe problem is large, often
The problem is as follows:
1. server configuration is interrupted.
2. ActiveX registration is interrupted.
3. interrupted when 100% is displayed.
4. Prompt: command line option syntax error, type command /? For help, continue
InstallWhen configuring the server
Appears: The dynamic link cannot be found.
SQLUNIRL. DLL in the specified path ......
5. Previously, the program created a pending file operation to run
InstallBefore the program, you must restart
Ii. Solutions in Case 1, 2, and 3:
Reminder: To avoid misoperation, you can back up the registry and database before entering SQL Server 2000. You can back up C: Program Files \ Microsoft SQL Server \ Mssql \ Data
(Default path) folder file.
1) uninstall SQL Server first (it does not matter if it cannot be detached. Continue the following operations );
2) Delete the entire Microsoft SQL Server folder;
3) run the registry and delete the following items:
HKEY_LOCAL_MACHINE \ SOFTWARE \ 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 SQL Server
4) restart the system as needed;
5), re-
Install.
You can also try to run in one step.
InstallSQL Server 2000 method:
1) Put the SQL Server 2000 CD.
2) In "start" -- "run" type "F: \ x86 \ setup.exe k = dbg" (F is a CD)
Note:
1) SQL Server 2000 versions supported by different operating systems (see the difference between SQL Server 2000 versions and VERSION Query article ).
Windows 2000 Server can
InstallAny version of SQL Server 2000.
Windows 2000 Professional only
InstallSQL Server 2000 Personal Edition, development edition, evaluation edition, and MCDE
2) SQL Server 2000 versions and requirements for hardware and software (see: SQL Server 2000 hardware and software
InstallRequired ).
Iii. Solution to situation 4
Because
InstallThe file path (full path) contains Chinese characters.
For example, c: \ SQLSERVER Chinese Enterprise Edition \
Change to c: \ SQLSERVER \
Iv. Solution to situation 5
1) restart the machine and proceed.
InstallIf the error persists, follow these steps;
2) Enter regedIT in start-run;
3) locate HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Control \ Session Manager.
PendingFileRenameOperations project and delete it. In this way, you can clear
InstallTemporarily suspended projects.
4) Select a file-inverted and save;
5) Right-click PendingFileRenameOperations in the right window, select Delete, and then confirm;
6) Restart
Install, Problem solving
5. If the problem persists, try to fix the operating system first:
Run sfc/scannow at the command prompt.
Last method: change to Windows 2000
InstallDisk and SQL Server 2000
InstallDisk, sometimes the cause of the problem is very strange, someone has replaced a power supply to solve the problem.
1) uninstall your SQL Server 2000 and delete the Program Files \ Microsoft SQL Server folder if necessary;
2) Open the registry;
In "start" -- "run", type "regedIT"
3) Click to open in the following order;
+ HKEY_LOCAL_MACHINE
+ Softlinks
+ Microsoft
+ Windows
+ CurrentVersion
+ Setup
+ Predictioncomponents
4) delete all the folders under predictioncomponents;
For example, {60BFF50D-FB2C-4498-A577-C9548C390BB9}
{60BFF50D-FB2C-4498-A577-C9548C390BB9}
{60BFF50D-FB2C-4498-A577-C9548C390BB9}
{60BFF50D-FB2C-4498-A577-C9548C390BB9}
5) restart the instance;
6), re-
InstallSQL Server 2000.
Vi. Other Instructions
1) The SQLstp. log file in the Windows directory, which lists
InstallDetailed information about the operations performed by the program, including
InstallAll errors encountered during this period.
Check this file to learn more
InstallWhere and why.
2) SQL
InstallThe error information is stored in a Log file named Errorlog. By default, the file is located in Program Files \ Microsoft SQL Server \ Mssql \ Log
Directory. This error log contains
InstallErrors encountered by SQL-Server when the program tries to start SQL-Server. These information can help you thoroughly check the cause of the error.
3) Another component to be checked is the Microsoft Data Access Component (MDAC)
InstallProgram, it acts as a SQL-Server2000
InstallStart part of the program.
SQL-Server2000
InstallProgram MEETING
InstallMDAC2.6. MDAC
InstallThe program will create a separate log file named DASEtup. log. You can view this log file and ensure that the MDAC
InstallNo program
AppearsProblem.
SQL or msde
InstallProblem-Command line option syntax error. Typ
Sqls 2000
InstallProblem -- Command line option syntax error
When
InstallProgram
InstallTo:
InstallThe program is
InstallMs Data Access Component
Time, screen
AppearsError message:
---------------------------
SQL Redist
---------------------------
Command line option syntax error. Type Command /? For Help.
---------------------------
OK
---------------------------
Then click OK to continue,
InstallThe program starts copying the file.
AppearsError message:
The dynamic Connection Library sqlunirl. dll cannot be found in the specified path "... \ Sqlunirl. dll "(Super long path !)
Click OK
InstallThe program stops running. View
InstallLogs.
Solution:
The cause of this problem is that SQL Server's
InstallThe file is stored in the Chinese directory.
InstallCopy the file to the English directory,
InstallOK
For example:
"D: \ Sqlserver
InstallDisk"
InstallDisk "removed. That's it!
What? Or not ?! Don't worry, hey.
Check whether your user name is in Chinese. Change it to English. This user name refers to the user name used when you log on to windows. The default user name is administrator.
Are you reluctant to modify this user name? Create a new English user, log on with this user, and then
InstallThat's all.
Let's talk more about the reason:
Software in
InstallWill first decompress, generate some temporary files, the system calls these files
Install. Sometimes these files are stored in the current directory and sometimes in the "C: \ Documents ents and Settings \ USERNAME \ Local Settings \ Temp" folder. If your "username" is in Chinese, it may fail. It seems that it is not good to support Chinese characters! Helpless!
Symptom:InstallCommand line option syntax error, type command /? For help
As shown in:
Solution:
1,InstallThe directory contains Chinese characters, suchInstallIn D: \ database 2000 \
2. If the operating system user name is Chinese, the environment variable path is Chinese. You can modify the operating system user name or environment variable as follows:
A. Modify the Operating System User Name:
"Start"-"Control Panel"-"User Account"-click "Change name"-change Chinese name to English, and click "Change name, restart your computer and then try againInstall.
B. You can change the operating system environment variables as follows:
Right-click "my computer"-"properties"-"advanced"-"environment variable ",
Select TEMP and click Edit, change it to D: \ temp, and then select TMP and click Edit to change it to D: \ temp. (when changing it, note that the input state is in English. Do not set D: input to D :)
As shown in figure:
Next, create a TEMP folder under drive D (Be sure to create this folder; otherwise, an error will occur ). Restart your computer after all the operations are completed.Install.
3. SinceInstallThe database may have residual files in the operating system. IfAppearsFor more information, see: How to completely delete the SQL SERVER database!
