Two Problems and Solutions for installing SQL Server 2000

Don't talk nonsense. Let's talk about the problem directly. I encountered two problems when installing SQL Server 2000 on my machine.

1. Two dialog boxes are displayed during installation:

The redlist header contains command line option syntax error, TYPE command /? Forhelp;

The content in the title HTML Help 1.32 update is command line option syntax error, TYPE command /? Forhelp.

2. Click "OK" to continue the installation. However, a dialog box is displayed with the following content: "An error occurred while configuring the server for the installation program ..., see C:/Windows/sqlstp. log, find the file, and finally find the following content

Driver = {SQL Server}; server = Paladin; uid = sa; Pwd =; database = Master

[Microsoft] [ODBC driver manager] No data source found

Driver = {SQL Server}; server = Paladin; uid = sa; Pwd =; database = Master

[Microsoft] [ODBC driver manager] No data source found

Driver = {SQL Server}; server = Paladin; uid = sa; Pwd =; database = Master

[Microsoft] [ODBC driver manager] No data source found

SQL Server configuration?

Solution:

1. The first problem is that the original installation file of SQL Server contains Chinese characters in the path. Move the original installation file to the pure English path, and then

After the installation, the two dialog boxes will no longer appear;

2. The second problem is that the SQL Server Content in HKEY_LOCAL_MACHINE/software/ODBC is deleted in the registry.

Fix the problem. Solution 2:

A. Copy the following content into A. reg file. After running the file, you can install it successfully;

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

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE/software/ODBC]

[HKEY_LOCAL_MACHINE/software/ODBC. INI]

[HKEY_LOCAL_MACHINE/software/ODBC. INI/localserver]
"Description" = ""
"Server" = "(local )"
"Trusted_connection" = ""
"Useprocforprepare" = "yes"

[HKEY_LOCAL_MACHINE/software/ODBC. INI/ODBC data sources]
"Localserver" = "SQL Server"
"Triomotors" = "Microsoft Access Driver (*. mdb )"

[HKEY_LOCAL_MACHINE/software/ODBC. INI/ODBC file DSN]
"Defaultdsndir" = "C: // program files // common files // ODBC // data sources"

[HKEY_LOCAL_MACHINE/software/ODBC. INI/triomotors/engines]

[HKEY_LOCAL_MACHINE/software/ODBC. INI/triomotors/engines/jet]
"Implicitcommitsync" = "yes"
"Maxbuffersize" = DWORD: 00000200
"Pagetimeout" = DWORD: 00000005
"Threads" = DWORD: 00000003
"Usercommitsync" = "yes"

[HKEY_LOCAL_MACHINE/software/ODBC/odbcinst. INI]

[HKEY_LOCAL_MACHINE/software/ODBC/odbcinst. INI/driver da Microsoft para arquivos texto (*. txt; *. CSV)]
"Usagecount" = DWORD: 00000002
"Driver" = "C: // windows // system32 // odbcjt32.dll"
"Setup" = "C: // windows // system32 // odtext32.dll"
"Apilevel" = "1"
"Connectfunctions" = "yyn"
"Driverodbcver" = "02.50"
"Fileusage" = "1"
"Fileextns" = "*., *. ASC, *. CSV, *. tab, *. txt, *. CSV"
"Sqllevel" = "0"

[HKEY_LOCAL_MACHINE/software/ODBC/odbcinst. INI/driver do Microsoft Access (*. mdb)]
"Usagecount" = DWORD: 00000002
"Driver" = "C: // windows // system32 // odbcjt32.dll"
"Setup" = "C: // windows // system32 // odbcjt32.dll"
"Apilevel" = "1"
"Connectfunctions" = "yyn"
"Driverodbcver" = "02.50"
"Fileusage" = "2"
"Fileextns" = "*. mdb"
"Sqllevel" = "0"

[HKEY_LOCAL_MACHINE/software/ODBC/odbcinst. INI/driver do Microsoft DBASE (*. DBF)]
"Usagecount" = DWORD: 00000002
"Driver" = "C: // windows // system32 // odbcjt32.dll"
"Setup" = "C: // windows // system32 // oddbse32.dll"
"Apilevel" = "1"
"Connectfunctions" = "yyn"
"Driverodbcver" = "02.50"
"Fileusage" = "1"
"Fileextns" = "*. DBF, *. ndx, *. MDX"
"Sqllevel" = "0"

[HKEY_LOCAL_MACHINE/software/ODBC/odbcinst. INI/driver do Microsoft Excel (*. xls)]
"Usagecount" = DWORD: 00000002
"Driver" = "C: // windows // system32 // odbcjt32.dll"
"Setup" = "C: // windows // system32 // odexl32.dll"
"Apilevel" = "1"
"Connectfunctions" = "yyn"
"Driverodbcver" = "02.50"
"Fileusage" = "1"
"Fileextns" = "*. xls"
"Sqllevel" = "0"

[HKEY_LOCAL_MACHINE/software/ODBC/odbcinst. INI/driver do Microsoft paradox (*. DB)]
"Usagecount" = DWORD: 00000002
"Driver" = "C: // windows // system32 // odbcjt32.dll"
"Setup" = "C: // windows // system32 // odpdx32.dll"
"Apilevel" = "1"
"Connectfunctions" = "yyn"
"Driverodbcver" = "02.50"
"Fileusage" = "1"
"Fileextns" = "*. DB"
"Sqllevel" = "0"

[HKEY_LOCAL_MACHINE/software/ODBC/odbcinst. INI/driver para o Microsoft Visual FoxPro]
"Usagecount" = DWORD: 00000002
"Driver" = "C: // windows // system32 // vfpodbc. dll"
"Setup" = "C: // windows // system32 // vfpodbc. dll"
"Apilevel" = "0"
"Connectfunctions" = "yyn"
"Driverodbcver" = "02.50"
"Fileusage" = "1"
"Fileextns" = "*. DBF, *. CDX, *. idx, *. FPT"
"Sqllevel" = "0"

[HKEY_LOCAL_MACHINE/software/ODBC/odbcinst. INI/Microsoft Access Driver (*. mdb)]
"Usagecount" = DWORD: 00000002
"Driver" = "C: // windows // system32 // odbcjt32.dll"
"Setup" = "C: // windows // system32 // odbcjt32.dll"
"Apilevel" = "1"
"Connectfunctions" = "yyn"
"Driverodbcver" = "02.50"
"Fileusage" = "2"
"Fileextns" = "*. mdb"
"Sqllevel" = "0"

[HKEY_LOCAL_MACHINE/software/ODBC/odbcinst. INI/Microsoft Access-Treiber (*. mdb)]
"Usagecount" = DWORD: 00000002
"Driver" = "C: // windows // system32 // odbcjt32.dll"
"Setup" = "C: // windows // system32 // odbcjt32.dll"
"Apilevel" = "1"
"Connectfunctions" = "yyn"
"Driverodbcver" = "02.50"
"Fileusage" = "2"
"Fileextns" = "*. mdb"
"Sqllevel" = "0"

[HKEY_LOCAL_MACHINE/software/ODBC/odbcinst. INI/Microsoft DBASE Driver (*. DBF)]
"Usagecount" = DWORD: 00000002
"Driver" = "C: // windows // system32 // odbcjt32.dll"
"Setup" = "C: // windows // system32 // oddbse32.dll"
"Apilevel" = "1"
"Connectfunctions" = "yyn"
"Driverodbcver" = "02.50"
"Fileusage" = "1"
"Fileextns" = "*. DBF, *. ndx, *. MDX"
"Sqllevel" = "0"

[HKEY_LOCAL_MACHINE/software/ODBC/odbcinst. INI/Microsoft dbase vfp Driver (*. DBF)]
"Usagecount" = DWORD: 00000002
"Driver" = "C: // windows // system32 // vfpodbc. dll"
"Setup" = "C: // windows // system32 // vfpodbc. dll"
"Apilevel" = "0"
"Connectfunctions" = "yyn"
"Driverodbcver" = "02.50"
"Fileusage" = "1"
"Fileextns" = "*. DBF, *. CDX, *. idx, *. FPT"
"Sqllevel" = "0"

[HKEY_LOCAL_MACHINE/software/ODBC/odbcinst. INI/Microsoft DBASE-Treiber (*. DBF)]
"Usagecount" = DWORD: 00000002
"Driver" = "C: // windows // system32 // odbcjt32.dll"
"Setup" = "C: // windows // system32 // oddbse32.dll"
"Apilevel" = "1"
"Connectfunctions" = "yyn"
"Driverodbcver" = "02.50"
"Fileusage" = "1"
"Fileextns" = "*. DBF, *. ndx, *. MDX"
"Sqllevel" = "0"

[HKEY_LOCAL_MACHINE/software/ODBC/odbcinst. INI/Microsoft Excel Driver (*. xls)]
"Usagecount" = DWORD: 00000002
"Driver" = "C: // windows // system32 // odbcjt32.dll"
"Setup" = "C: // windows // system32 // odexl32.dll"
"Apilevel" = "1"
"Connectfunctions" = "yyn"
"Driverodbcver" = "02.50"
"Fileusage" = "1"
"Fileextns" = "*. xls"
"Sqllevel" = "0"

[HKEY_LOCAL_MACHINE/software/ODBC/odbcinst. INI/Microsoft Excel-Treiber (*. xls)]
"Usagecount" = DWORD: 00000002
"Driver" = "C: // windows // system32 // odbcjt32.dll"
"Setup" = "C: // windows // system32 // odexl32.dll"
"Apilevel" = "1"
"Connectfunctions" = "yyn"
"Driverodbcver" = "02.50"
"Fileusage" = "1"
"Fileextns" = "*. xls"
"Sqllevel" = "0"

[HKEY_LOCAL_MACHINE/software/ODBC/odbcinst. INI/Microsoft FoxPro VFP Driver (*. DBF)]
"Usagecount" = DWORD: 00000002
"Driver" = "C: // windows // system32 // vfpodbc. dll"
"Setup" = "C: // windows // system32 // vfpodbc. dll"
"Apilevel" = "0"
"Connectfunctions" = "yyn"
"Driverodbcver" = "02.50"
"Fileusage" = "1"
"Fileextns" = "*. DBF, *. CDX, *. idx, *. FPT"
"Sqllevel" = "0"

[HKEY_LOCAL_MACHINE/software/ODBC/odbcinst. INI/Microsoft ODBC for Oracle]
"Usagecount" = DWORD: 00000001
"Driver" = "C: // windows // system32 // msorcl32.dll"
"Setup" = "C: // windows // system32 // msorcl32.dll"
"Sqllevel" = "1"
"Fileusage" = "0"
"Driverodbcver" = "02.50"
"Connectfunctions" = "yyy"
"Apilevel" = "1"
"Cptimeout" = "120"

[HKEY_LOCAL_MACHINE/software/ODBC/odbcinst. INI/Microsoft paradox Driver (*. DB)]
"Usagecount" = DWORD: 00000002
"Driver" = "C: // windows // system32 // odbcjt32.dll"
"Setup" = "C: // windows // system32 // odpdx32.dll"
"Apilevel" = "1"
"Connectfunctions" = "yyn"
"Driverodbcver" = "02.50"
"Fileusage" = "1"
"Fileextns" = "*. DB"
"Sqllevel" = "0"

[HKEY_LOCAL_MACHINE/software/ODBC/odbcinst. INI/Microsoft paradox-Treiber (*. DB)]
"Usagecount" = DWORD: 00000002
"Driver" = "C: // windows // system32 // odbcjt32.dll"
"Setup" = "C: // windows // system32 // odpdx32.dll"
"Apilevel" = "1"
"Connectfunctions" = "yyn"
"Driverodbcver" = "02.50"
"Fileusage" = "1"
"Fileextns" = "*. DB"
"Sqllevel" = "0"

[HKEY_LOCAL_MACHINE/software/ODBC/odbcinst. INI/Microsoft text Driver (*. txt; *. CSV)]
"Usagecount" = DWORD: 00000002
"Driver" = "C: // windows // system32 // odbcjt32.dll"
"Setup" = "C: // windows // system32 // odtext32.dll"
"Apilevel" = "1"
"Connectfunctions" = "yyn"
"Driverodbcver" = "02.50"
"Fileusage" = "1"
"Fileextns" = "*., *. ASC, *. CSV, *. tab, *. txt, *. CSV"
"Sqllevel" = "0"

[HKEY_LOCAL_MACHINE/software/ODBC/odbcinst. INI/Microsoft text-Treiber (*. txt; *. CSV)]
"Usagecount" = DWORD: 00000002
"Driver" = "C: // windows // system32 // odbcjt32.dll"
"Setup" = "C: // windows // system32 // odtext32.dll"
"Apilevel" = "1"
"Connectfunctions" = "yyn"
"Driverodbcver" = "02.50"
"Fileusage" = "1"
"Fileextns" = "*., *. ASC, *. CSV, *. tab, *. txt, *. CSV"
"Sqllevel" = "0"

[HKEY_LOCAL_MACHINE/software/ODBC/odbcinst. INI/Microsoft Visual FoxPro driver]
"Usagecount" = DWORD: 00000002
"Driver" = "C: // windows // system32 // vfpodbc. dll"
"Setup" = "C: // windows // system32 // vfpodbc. dll"
"Apilevel" = "0"
"Connectfunctions" = "yyn"
"Driverodbcver" = "02.50"
"Fileusage" = "1"
"Fileextns" = "*. DBF, *. CDX, *. idx, *. FPT"
"Sqllevel" = "0"

[HKEY_LOCAL_MACHINE/software/ODBC/odbcinst. INI/Microsoft Visual FoxPro-Treiber]
"Usagecount" = DWORD: 00000002
"Driver" = "C: // windows // system32 // vfpodbc. dll"
"Setup" = "C: // windows // system32 // vfpodbc. dll"
"Apilevel" = "0"
"Connectfunctions" = "yyn"
"Driverodbcver" = "02.50"
"Fileusage" = "1"
"Fileextns" = "*. DBF, *. CDX, *. idx, *. FPT"
"Sqllevel" = "0"

[HKEY_LOCAL_MACHINE/software/ODBC/odbcinst. INI/MS code page translator]
"Translator" = "C: // windows // system32 // mscpxl32.dll"
"Setup" = "C: // windows // system32 // mscpxl32.dll"
"Usagecount" = DWORD: 00000002

[HKEY_LOCAL_MACHINE/software/ODBC/odbcinst. INI/ODBC core]
"Usagecount" = DWORD: 00000002

[HKEY_LOCAL_MACHINE/software/ODBC/odbcinst. INI/ODBC drivers]
"SQL Server" = "installed"
"Microsoft Access Driver (*. mdb)" = "installed"
"Microsoft text Driver (*. txt; *. CSV)" = "installed"
"Microsoft Excel Driver (*. xls)" = "installed"
"Microsoft DBASE Driver (*. DBF)" = "installed"
"Microsoft paradox Driver (*. DB)" = "installed"
"Microsoft Visual FoxPro driver" = "installed"
"Microsoft FoxPro VFP Driver (*. DBF)" = "installed"
"Microsoft dbase vfp Driver (*. DBF)" = "installed"
"Microsoft Access-Treiber (*. mdb)" = "installed"
"Microsoft text-Treiber (*. txt; *. CSV)" = "installed"
"Microsoft Excel-Treiber (*. xls)" = "installed"
"Microsoft DBASE-Treiber (*. DBF)" = "installed"
"Microsoft paradox-Treiber (*. DB)" = "installed"
"Microsoft Visual FoxPro-Treiber" = "installed"
"Driver do Microsoft Access (*. mdb)" = "installed"
"Driver da Microsoft para arquivos texto (*. txt; *. CSV)" = "installed"
"Driver do Microsoft Excel (*. xls)" = "installed"
"Driver do Microsoft DBASE (*. DBF)" = "installed"
"Driver do Microsoft paradox (*. DB)" = "installed"
"Driver para o Microsoft Visual FoxPro" = "installed"
"Microsoft ODBC for Oracle" = "installed"

[HKEY_LOCAL_MACHINE/software/ODBC/odbcinst. INI/ODBC translators]
"Ms code page translator" = "installed"

[HKEY_LOCAL_MACHINE/software/ODBC/odbcinst. INI/SQL Server]
"Usagecount" = DWORD: 00000002
"Driver" = "C: // windows // system32 // sqlsrv32.dll"
"Setup" = "C: // windows // system32 // sqlsrv32.dll"
"Sqllevel" = "1"
"Fileusage" = "0"
"Driverodbcver" = "03.50"
"Connectfunctions" = "yyy"
"Apilevel" = "2"
"Cptimeout" = "60"

B. Install the ODBC repair tool named mdac_typ.exe. You can download it online. Download and repair ODBC.

The installation continues successfully.