SQL SERVER安装问题集锦.doc

1“以前的某个程序安装已在安装计算机上创建挂起的文件操作。运行安装程序之前必须重新启动计算机”装SQL机器之前如果装过OFFICE软件就会出现程序挂起的问题打开注册表编辑器，在HKEY_LOCAL_MACHINESYSTEMCurrentControlSetControlSession Manager中找到PendingFileRenameOperations项目，并删除它。这样就可以清除安装暂挂项目。2 安装程序配置服务器失败。参考服务器错误日志和 C:WINDOWSsqlstp.log 了解更多信息。”以前装过sql server,后来删掉重装会出现这种情况，解决办法如下：1）添加/删除程序中彻底删除sql server2）将没有删除的sql serv er目录也删除掉。3）打开注册表编辑器，在HKEY_LOCAL_MACHINESYSTEMCurrentControlSetControlSession Manager中找到PendingFileRenameOperations项目，并删除它。这样就可以清除安装暂挂项目。4）安装3创建一个或多个注册表时出现错误请参见c:windowssqlstp.log已了解实际情况问题可能是由于注册表引用条件不足而引起装SQL机器之前如果装过OFFICE软件就会出现程序挂起的问题装程序所在路径字符串里面是不是有双字节字符，就是汉字，还有系统登陆名也不要中文名有个比较笨的方法解决,就是在出这个提示时,把安装程序从进程中杀掉,这样,你的SQLserver是可以用的,不过是不能打补丁了4Command line option synax error. Type Command /? For help.请参考/kb/841487You receive a Command line option syntax error error message when you install SQL Server 2000 SP3View products that this article applies to.Article ID:841487Last Review:May 27, 2004Revision:1.0SYMPTOMSWhen you install Microsoft SQL Server 2000 Service Pack 3 (SP3) on your computer, you may receive the following error message: SQL Redistcontent: Command line option syntax error. Type Command /? for Help.If you click OK in the message box, the installation of SQL Server 2000 SP3 may complete successfully. However, the Sqlredist.exe program may not have run successfully during the installation of SQL Server 2000 SP3. This problem may occur if all the following conditions are true: You run the SQL Server 2000 SP3 Setup.bat file from a folder that contains double-byte character set (DBCS) characters in the folder name.An ODBC client program that uses the Sqlsrv32.dll file is running on your computer.Additionally, if you install the MS03-033 security update for Microsoft Data Access Components (MDAC) on your computer after this problem occurs, the SQL Server Agent service may not start successfully, and you may receive the following error message: Unable to load SQL Server ODBC driver resource DLL. The application cannot continue.Back to the topWORKAROUNDTo work around this problem, run the SQL Server 2000 SP3 Setup.bat file from a folder that does not contain DBCS characters in the folder name. Back to the topMORE INFORMATIONWhen SQL Server 2000 SP3 is installed, the SQL Server 2000 SP3 installer replaces the existing MDAC files on the computer with the files for MDAC 2.7 SP1, even if the Sqlredist.exe program does not run successfully. However, the SQL Server 2000 SP3 installer does not update the HKEY_LOCAL_MACHINESOFTWAREMicrosoftDataAccessFullInstallVer registry key with the correct version of MDAC.If you install the MS03-033 security update after this problem occurs, the MS03-033 security update installer does not replace the Sqlsrv32.rll file because the installer does not recognize the version of MDAC that is installed on your computer. Therefore, the ODBC client application cannot load the correct version of resource file, and you receive the error message that is mentioned in the Symptoms section. For additional information, click the following article number to view the article in the Microsoft Knowledge Base: 823718 (/kb/823718/) MS03-033: Security Update for Microsoft Data Access Components 5 sqlserver2000安装不成功之处理 同事出差，遇到两次安装SQL不成功，这边虽然给予了他指导，他也按我说的方法，先停止服务，退出，再卸载，然后将注册表与相应安装目录也删除了，但仍然安装不了SQL，特恼火，没有办法，我只得让他重新装一下OS，就OK了。但这个方法是迫不得已，索性到网上查查相关资料，但结果都是提问的，即使有回答，答案也无非就是卸载掉再重新安装试试等此类的回复，嘿，没办法，自己整理一个，或许对安装SQL不成功的同志有所帮助吧。 1、先停止服务，退出，再到控制面板正常卸载； 2、删除安装路径下的所有目录文件夹，包括注册表，如果担心删除不到位，可以用查找命令，将所有*SQL*的逐一查出，然后再一一确认删除；（如果安装SQL时，不是按默认路径安装，除了删除安装路径下的所有目录文件夹外，主系统盘里的程序组里的相应文件夹也要删除） 3、删除的时候还应考虑到C:Program FilesCommon FilesMicrosoft Sharedweb server extensions40binFPMMC.MSC; 4、管理工具中，将SQLSERVERAGENT服务停止服务；此服务程序存放在D:Program FilesMicrosoft SQL ServerMSSQLBinnsqlagent.exe -i MSSQLSERVER 5、将C:WINDOWS目录下的sql.mif、sqlsp.log、sqlstp.log、sqlsrv32.rll、sqlwid.dll、sqlwoa.dll、dbmsqlgc.dll、SQLSRV32.dll、sqlclnt.rsp、sqlunirl.dll、SQLSERVR.EXE-18F260D8.pf、SQLMANGR.EXE-0150BA62.pf等清除；（偶机器SQL是打过SP4的） 6、删除时还应将C:Program FilesCommon FilesMicrosoft SharedSQL Debuggingsqldbreg2.exe,sqldbreg.exe ,sqldbg.dll也清除掉； 7、如果安装不成功，记得要将C:WINDOWSTempSQLSETUPBINSCM.EXE一并清除； 8、卸载干净后，如果怕再次安装出错，那就建议按默认路径安装； 9、SQL在安装过程中如果出错，系统会锁定文件，当然，卸载程序也会，但可以通过修改注册表，就不用重新启动，再尝试安装了。（建议装完SQL后还是重新启动一下机器，就避免修改注册表了） 避免重启，注册表修改：（1）运行REGEDIT；（2）注册表中选择HKEY_LOCAL_MACHINESYSTEMCurrentControlSetControlSession Manager，将光标定位于此；（3）选择文件-导出，再次保存（安全起见）；（4）在右边窗中右击PendingFile Rename Operations，选择删除，最后确认； 10、如果安装不成功，还可以通过C:WINDOWSsqlstp.log查看安装不成功的原因，这个是最利于解决问题的了； 11、同时需要将C:Documents and SettingsXXXLocal SettingsTemp所有关于*SQL*.*全部