sql挂起的文件操作.docx

昨天在Windows Server 2003安装SQL2000,由于安装源所在的文件名过长,结果安装过程报错.装好了和项目要用的软件冲突.只好重装.结果重装死活装不上,提示安装程序配置服务器失败.今天在网上搜索了下,找到了解决方案,集中放在这里,以备后查.(一)装SQL一半的时候退出,亦即安装失败,此后想重新安装,Windows提示有一个安装已经挂起,必须重启,如何不重启继续重新安装?方案如下:1.将以下两个从注册表中删除，一定可以解决SQL挂起问题： 一、开始运行输入regedit回车 +HKEY_LOCAL_MACHINE +SYSTEM +CurrentControlSet +Control +Session Manager下的PendingFileRenameOperations删掉 二、+HKEY_LOCAL_MACHINE +SOFTWARE +Microsoft +Windows +CurrentVersion +Setup +ExceptionComponents下的东西全部删掉如： 077ACEC7-979C-40AB-9835-435BA1511E0D 30C7234B-6482-4A55-A11D-ECD9030313F2 3FDF25EE-E592-4495-8391-6E9C504DAC2B 60204BB3-7078-4F70-8F69-68297621941C. 总之有几项,就删几项,删掉后重启,再装SQL Server,就不会提示有挂起了。或者2.在HKEY_LOCAL_MACHINESYSTEMControlSet001ControlSession Manager 删除PendingFileRenameOperations 在HKEY_LOCAL_MACHINESYSTEMCurrentControlSetControlSession Manager 删除PendingFileRenameOperations这个一定不要留 重新启动就OK了(二)安装到最后,配置时报安装程序配置服务器失败,参考服务器错误日志和C:WINNTsqlstp.log 了解更多信息,这个问题的情况比较复杂,可能是多种原因造成的,具体如下:失败一：正在与服务?driver=sql server;server=ZHL;UID=sa;PWD=;database=master MicrosoftODBC 驱动程序 管理器 驱动程序的 SQLAllocHandle on SQL_Hdriver=sql server;server=ZHL;UID=sa;PWD=;database=master MicrosoftODBC 驱动程序 管理器 驱动程序的 SQLAllocHandle on SQL_Hdriver=sql server;server=ZHL;UID=sa;PWD=;database=master MicrosoftODBC 驱动程序 管理器 驱动程序的 SQLAllocHandle on SQL_HSQL Server 配置?#13:40:06 Process Exit Code: (-1) 13:40:09 安装程序配置服务器失败。参考服务器错误日志和 C:WINNTsqlstp.log 了解更多信息。13:40:09 Action CleanUpInstall:当出现这个错误时，试一下重装系统文件在dos下重新运行win2000的安装，然后选择修复，而不是全新安装，修复系统文件之后，再装sql server，则不会出现此错误消息失败二：正在与服务?driver=sql server;server=ZHL;UID=sa;PWD=;database=master MicrosoftODBC 驱动程序 管理器 未发现数据源driver=sql server;server=ZHL;UID=sa;PWD=;database=master MicrosoftODBC 驱动程序 管理器 未发现数据源driver=sql server;server=ZHL;UID=sa;PWD=;database=master MicrosoftODBC 驱动程序 管理器 未发现数据源SQL Server 配置?#13:50:07 Process Exit Code: (-1) 13:50:10 安装程序配置服务器失败。参考服务器错误志 C:WINNTsqlstp.log 了解更多信息。13:50:10 Action CleanUpInstall:当出现这个错误时，是因为在注册表删除了HKEY_LOCAL_MACHINESOFTWAREODBC中有关sql sever的信息失败三：在与服务?driver=sql server;server=ZHL;UID=sa;PWD=;database=master MicrosoftODBC SQL Server DriverNamed Pipes连接? MicrosoftODBC SQL Server DriverNamed PipesConnectionRead (ReadFile().driver=sql server;server=ZHL;UID=sa;PWD=;database=master MicrosoftODBC SQL Server DriverNamed Pipes连接? MicrosoftODBC SQL Server DriverNamed PipesConnectionRead (GetOverLappedResult().driver=sql server;server=ZHL;UID=sa;PWD=;database=master MicrosoftODBC SQL Server DriverNamed Pipes连接? MicrosoftODBC SQL Server DriverNamed PipesConnectionRead (GetOverLappedResult().SQL Server 配置?#17:17:41 Process Exit Code: (-1) 17:17:45 安装程序配置服务器失败。参考服务器错误日志和C:WINDOWSsqlstp.log 了解更多信息。 当出现这个错误时，是因为在注册表删除了HKEY_LOCAL_MACHINESOFTWAREODBC中有关sql sever的内容这时可以选择修复注册表，或安装ODBC修复工具ODBC修复工具： 211.101.4.50/download/canyin/tools/MDAC_TYP.EXE然而，我的问题都不在其中：driver=sql server;server=soyo;UID=sa;PWD=;database=master MicrosoftODBC SQL Server DriverShared Memory一般性网络错误。 MicrosoftODBC SQL Server DriverShared MemoryConnectionRead (WrapperRead().driver=sql server;server=soyo;UID=sa;PWD=;database=master MicrosoftODBC SQL Server DriverShared Memory一般性网络错误。 MicrosoftODBC SQL Server DriverShared MemoryConnectionRead (WrapperRead().driver=sql server;server=soyo;UID=sa;PWD=;database=master MicrosoftODBC SQL Server DriverShared Memory一般性网络错误。 MicrosoftODBC SQL Server DriverShared MemoryConnectionR当我发现有一高手说要把计算机名称改为大写时，我突然记起，我的计算机名是小写的。于是通过修改注册表改为大写，然后安装通过。修改计算机名可以通过调用控制面板来实现，也可以通过调用注册表编辑器来实现。比如要将计算机名由MMX233改为P233，则可以按照下述方法进行操作：打开HKEY_LOCAL_MACHINESystemCurrenControlSetControlComputerNameComputerName，将名为ComputerName的主键的值从原来的MMX233更改为P233，注销用户或重新启动Windows后就会生效。以上蓝色字体为转载,我遇到的报错经查日志,是第二种情况,找不到数据源.这样的话,需要修复ODBC,可以从网上下一个ODBC修复器试试.我用的是注册表文件修复,如下所示:我的是SP3啊，都正常安装了 。我在网上查到先把SQL卸载干净，包括注册表里的SQL相关键（好像有三项，搜索一下）值都删除。然后把下边的代码复制到记事本里，在读入到注册表。重启后安装SQL2000。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,*.ndx,*.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,*.cdx,*.idx,*.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,*.ndx,*.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,*.cdx,*.idx,*.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=*.,*.asc,*.csv,*.tab,*.txt,*.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=*.,*.asc,*.csv,*.tab,*.txt,*.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,*.cdx,*.idx,*.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,*.cdx,*.idx,*.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)=