|
最近安装个SQLSERVER2000时碰到问题，可能是原机器里的SQLSERVER2005卸载不完全的原因。
出处：http://www.cnblogs.com/kuang/archive/2012/07/19/2599441.html
问题一、以前的某个程序安装已经在计算机上创建挂起的文件操作,必须重启计算机
1）添加/删除程序中彻底删除sql server
2）将没有删除的sql serv er目录也删除掉。
3）运行-regedit打开注册表编辑器，在HKEY_LOCAL_MACHINESYSTEMCurrentControlSetControl
Session Manager中找到PendingFileRenameOperations项目
，并删除它。这样就可以清除安装暂挂项目。
4）如果上面的操作还是没有解决，运行-regedit--编辑--查找输入sql server 找到一个删一个，删完后，按F3，直到
全部删除为止！
问题二、安装sql2000时出现command line option syntax error
原因分析：很有可能是你的安装目录层数太多；
安装程序不能放在中文目录下（注意不是安装到路径，
而是安装程序自己本身所在路径）！
比如不能把安装程序放在'D:数据库SQL2000’目录下进行安装，
把它拷出来到根目录再装就OK了！
问题三、如果出现：无法找到动态连接库sqlunirl.dll于指定路径
?
解决：关于安装服务器配置失败的时候（sqlunirl.dll是MDAC的一个组件）
，你可以考虑如下方法试试： 重装MDAC
问题四、安装程序配置服务失败。参考服务器错误日子和C:WINDOWSsqlstp.log 了解更多信息
SQL2000安装失败，提示“[ODBC 驱动程序管理器]未发现数据源
参考日志：
正在启动?
Chinese_PRC_CI_AS
-m -Q -T4022 -T3659
正在与服务?
driver={sql server};server=LZ01;UID=sa;PWD=;database=master
[Microsoft][ODBC 驱动程序管理器] 未发现数据源
driver={sql server};server=LZ01;UID=sa;PWD=;database=master
[Microsoft][ODBC 驱动程序管理器] 未发现数据源
driver={sql server};server=LZ01;UID=sa;PWD=;database=master
[Microsoft][ODBC 驱动程序管理器] 未发现数据源
SQL Server 配置?
###############################################################################
17:00:08 Process Exit Code: (-1)
17:01:41 安装程序配置服务器失败。参考服务器错误日志和 C:WINDOWSsqlstp.log 了解更多信息。
17:01:41 Action CleanUpInstall:
17:01:41 C:DOCUME~1ADMINI~1LOCALS~1TempSqlSetupBinscm.exe -Silent 1 -Action 4 -Service SQLSERVERAGENT
17:01:41 Process Exit Code: (1060) 指定的服务未安装。
17:01:41 C:DOCUME~1ADMINI~1LOCALS~1TempSqlSetupBinscm.exe -Silent 1 -Action 4 -Service MSSQLSERVER
17:01:41 Process Exit Code: (0)
17:01:41 StatsGenerate returned: 2
17:01:41 StatsGenerate (0x0,0x1,0xf00,0x100,2052,303,0x0,0
17:01:41 StatsGenerate -1,Administrator)
17:01:41 Installation Failed.
解决方法：
保存一下内容到一个.reg文件中，运行后可以成功安装
-----------------------------------------------
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINESOFTWAREODBC]
[HKEY_LOCAL_MACHINESOFTWAREODBCODBC.INI]
[HKEY_LOCAL_MACHINESOFTWAREODBCODBC.INILocalServer]
"Description"=""
"Server"="(Local)"
"Trusted_connection"=""
"UseProcForPrepare"="Yes"
[HKEY_LOCAL_MACHINESOFTWAREODBCODBC.INIODBC Data Sources]
"LocalServer"="SQL Server"
"TrioMotors"="Microsoft Access Driver (*.mdb)"
[HKEY_LOCAL_MACHINESOFTWAREODBCODBC.INIODBC File DSN]
"DefaultDSNDir"="C:Program FilesCommon FilesODBCData Sources"
[HKEY_LOCAL_MACHINESOFTWAREODBCODBC.INITrioMotorsEngines]
[HKEY_LOCAL_MACHINESOFTWAREODBCODBC.INITrioMotorsEnginesJet]
"ImplicitCommitSync"="Yes"
"MaxBufferSize"=dword:00000200
"PageTimeout"=dword:00000005
"Threads"=dword:00000003
"UserCommitSync"="Yes"
[HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INI]
[HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INIDriver da Microsoft para arquivos texto (*.txt; *.csv)]
"UsageCount"=dword:00000002
"Driver"="C:WINDOWSsystem32odbcjt32.dll"
"Setup"="C:WINDOWSsystem32odtext32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.,*.asc,*.csv,*.tab,*.txt,*.csv"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INIDriver do Microsoft Access (*.mdb)]
"UsageCount"=dword:00000002
"Driver"="C:WINDOWSsystem32odbcjt32.dll"
"Setup"="C:WINDOWSsystem32odbcjt32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="2"
"FileExtns"="*.mdb"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INIDriver do Microsoft dBase (*.dbf)]
"UsageCount"=dword:00000002
"Driver"="C:WINDOWSsystem32odbcjt32.dll"
"Setup"="C:WINDOWSsystem32oddbse32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.dbf,*.ndx,*.mdx"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INIDriver do Microsoft Excel(*.xls)]
"UsageCount"=dword:00000002
"Driver"="C:WINDOWSsystem32odbcjt32.dll"
"Setup"="C:WINDOWSsystem32odexl32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.xls"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INIDriver do Microsoft Paradox (*.db )]
"UsageCount"=dword:00000002
"Driver"="C:WINDOWSsystem32odbcjt32.dll"
"Setup"="C:WINDOWSsystem32odpdx32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.db"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INIDriver para o Microsoft Visual FoxPro]
"UsageCount"=dword:00000002
"Driver"="C:WINDOWSsystem32vfpodbc.dll"
"Setup"="C:WINDOWSsystem32vfpodbc.dll"
"APILevel"="0"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.dbf,*.cdx,*.idx,*.fpt"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INIMicrosoft Access Driver (*.mdb)]
"UsageCount"=dword:00000002
"Driver"="C:WINDOWSsystem32odbcjt32.dll"
"Setup"="C:WINDOWSsystem32odbcjt32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="2"
"FileExtns"="*.mdb"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INIMicrosoft Access-Treiber (*.mdb)]
"UsageCount"=dword:00000002
"Driver"="C:WINDOWSsystem32odbcjt32.dll"
"Setup"="C:WINDOWSsystem32odbcjt32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="2"
"FileExtns"="*.mdb"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INIMicrosoft dBase Driver (*.dbf)]
"UsageCount"=dword:00000002
"Driver"="C:WINDOWSsystem32odbcjt32.dll"
"Setup"="C:WINDOWSsystem32oddbse32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.dbf,*.mdx"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INIMicrosoft dBase VFP Driver (*.dbf)]
"UsageCount"=dword:00000002
"Driver"="C:WINDOWSsystem32vfpodbc.dll"
"Setup"="C:WINDOWSsystem32vfpodbc.dll"
"APILevel"="0"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.dbf,*.fpt"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INIMicrosoft dBase-Treiber (*.dbf)]
"UsageCount"=dword:00000002
"Driver"="C:WINDOWSsystem32odbcjt32.dll"
"Setup"="C:WINDOWSsystem32oddbse32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.dbf,*.mdx"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INIMicrosoft Excel Driver (*.xls)]
"UsageCount"=dword:00000002
"Driver"="C:WINDOWSsystem32odbcjt32.dll"
"Setup"="C:WINDOWSsystem32odexl32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.xls"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INIMicrosoft Excel-Treiber (*.xls)]
"UsageCount"=dword:00000002
"Driver"="C:WINDOWSsystem32odbcjt32.dll"
"Setup"="C:WINDOWSsystem32odexl32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.xls"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INIMicrosoft FoxPro VFP Driver (*.dbf)]
"UsageCount"=dword:00000002
"Driver"="C:WINDOWSsystem32vfpodbc.dll"
"Setup"="C:WINDOWSsystem32vfpodbc.dll"
"APILevel"="0"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.dbf,*.fpt"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INIMicrosoft ODBC for Oracle]
"UsageCount"=dword:00000001
"Driver"="C:WINDOWSsystem32msorcl32.dll"
"Setup"="C:WINDOWSsystem32msorcl32.dll"
"SQLLevel"="1"
"FileUsage"="0"
"DriverODBCVer"="02.50"
"ConnectFunctions"="YYY"
"APILevel"="1"
"CpTimeout"="120"
[HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INIMicrosoft Paradox Driver (*.db )]
"UsageCount"=dword:00000002
"Driver"="C:WINDOWSsystem32odbcjt32.dll"
"Setup"="C:WINDOWSsystem32odpdx32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.db"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INIMicrosoft Paradox-Treiber (*.db )]
"UsageCount"=dword:00000002
"Driver"="C:WINDOWSsystem32odbcjt32.dll"
"Setup"="C:WINDOWSsystem32odpdx32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.db"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INIMicrosoft Text Driver (*.txt; *.csv)]
"UsageCount"=dword:00000002
"Driver"="C:WINDOWSsystem32odbcjt32.dll"
"Setup"="C:WINDOWSsystem32odtext32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.,*.csv"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INIMicrosoft Text-Treiber (*.txt; *.csv)]
"UsageCount"=dword:00000002
"Driver"="C:WINDOWSsystem32odbcjt32.dll"
"Setup"="C:WINDOWSsystem32odtext32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.,*.csv"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INIMicrosoft Visual FoxPro Driver]
"UsageCount"=dword:00000002
"Driver"="C:WINDOWSsystem32vfpodbc.dll"
"Setup"="C:WINDOWSsystem32vfpodbc.dll"
"APILevel"="0"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.dbf,*.fpt"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INIMicrosoft Visual FoxPro-Treiber]
"UsageCount"=dword:00000002
"Driver"="C:WINDOWSsystem32vfpodbc.dll"
"Setup"="C:WINDOWSsystem32vfpodbc.dll"
"APILevel"="0"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.dbf,*.fpt"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INIMS Code Page Translator]
"Translator"="C:WINDOWSsystem32MSCPXL32.dll"
"Setup"="C:WINDOWSsystem32MSCPXL32.dll"
"UsageCount"=dword:00000002
[HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INIODBC Core]
"UsageCount"=dword:00000002
[HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INIODBC 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_MACHINESOFTWAREODBCODBCINST.INIODBC Translators]
"MS Code Page Translator"="Installed"
[HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INISQL Server] "UsageCount"=dword:00000002 "Driver"="C:WINDOWSsystem32SQLSRV32.dll" "Setup"="C:WINDOWSsystem32sqlsrv32.dll" "SQLLevel"="1" "FileUsage"="0" "DriverODBCVer"="03.50" "ConnectFunctions"="YYY" "APILevel"="2" "CPTimeout"="60"
（编辑：李大同）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
