一聚教程网:一个值得你收藏的教程网站

热门教程

mssql sqlserver2005安装失败解决办法与原因分析

时间:2022-06-29 08:18:48 编辑:袖梨 来源:一聚教程网

安装到上述错误的时候,SQL Server2005很多文件已经安装到硬盘上了,所有你重新安装的时候,可能会遇到
1、提示磁盘空间不够
目标磁盘中的空间不足,无法执行当前的 SQL Server 安装。若要继续,请释放磁盘空间以安装所选功能、为此次安装选择较少的功能或将所选功能安装到另一个驱动器中。

2、安装仍然失败
所以建议你重新安装之前,到添加删除程序里把SQL Server2005卸载掉!

上述问题是8月份我在一个客户那里搞了一个晚上都没有搞定,最后第二天早上在宾馆里上网到微软的网站上找到了答案,真是让人哭笑不得。

第一招:

1、清空曾经的安装(包括以前其他所有版本的相关组件),包括windows/temp文件夹下的内容。

     2、打开vs的光盘,在vs/wcu/msi31文件夹下有一个windows installs的文件,安装之。

     3、重启电脑,关闭杀毒软件和防火墙。

     4、修改programe file和temp文件夹让安装程序有足够的权限,其实就是用administrator登陆安装2005。

     5、现在就可以直接安装了。

(如果此找不行,请看下招)

 

第二招:

1、  打开VS2005安装盘,进入目录VS /wcu/DExplore

 

2、  手动运行DExplorer.exe

 

3、  再次运行VS2005安装程序。

 

第三招:

1、  修复.Net framework 2.0

 

2、  移除一个名为Rgstrtn.lck的文件,该文件可能在

"%APPDATA%/Microsoft Help" or   %temp% or directory under %temp% or
"/Documents and Settings/All Users{.Windows}/Application Data/Microsoft Help"。

 

3、  Then, see if ANY directories exist under  "%APPDATA%/Microsoft Help"  or

"/Documents and Settings/All Users{Windows}/Application Data/Microsoft Help",  they need to be moved to another directory for this error to go away, a rename to another name will not work, the code is checking the existance of ANY directory regardless of name and the directories "%APPDATA%/Microsoft Help" or "/Documents and Settings/All Users/Application Data/Microsoft Help"  having any directory under it will not resolve this error.

(英文很简单,我就不翻译了,基本意思就是要将Microsoft Help下的所有文件夹移除或重命名,大家注意看好路径就好了)。

 

4、  确保以Administrator登陆,有足够的权限操作安装。

 

5、  再次安装VS2005

    (以上三招基本上够用了,能够解决大部分的这样问题,如果你还不行,那你遇到的情况可能跟我一样,那就试试下面这招吧,呵呵)

 

       第四招:

1、  打开你的安装程序的temp目录,我的是在/Documents and Settings/luocl(你登陆的用户名)/Local Settings/Temp。

 

2、  去掉Temp文件夹的加密属性:点击Temp文件的属性——>常规——>高级,将“加密内容以便保护数据”一项的勾选去掉,点击确定。

 

3、  重新安装VS2005.

网络上搜索的其它办法


当我检查C:/Program Files/Microsoft SQL Server/90/Setup Bootstrap/LOG/Summary.txt

Microsoft SQL Server 2005 9.00.1399.06
==============================
OS Version      : Microsoft Windows Server 2003 family, Enterprise Edition Service Pack 2 (Build 3790)
Time            : Wed Oct 10 08:34:17 2007
 
CSZ : 执行安装向导期间出错。有关详细信息,您可以查看安装日志和/或单击“帮助”按钮。


 SQL Server 安装程序失败。有关详细信息,请查看 %ProgramFiles%/Microsoft SQL Server/90/Setup Bootstrap/LOG/Summary.txt 中的安装日志文件。


Time            : Wed Oct 10 08:42:32 2007


List of log files:
 C:/Program Files/Microsoft SQL Server/90/Setup Bootstrap/LOG/Files/SQLSetup0001_CSZ_Core(Local).log
 C:/Program Files/Microsoft SQL Server/90/Setup Bootstrap/LOG/Files/SQLSetup0001_CSZ_Datastore.xml
 C:/Program Files/Microsoft SQL Server/90/Setup Bootstrap/LOG/Files/SQLSetup0001_CSZ_.NET Framework 2.0.log
 C:/Program Files/Microsoft SQL Server/90/Setup Bootstrap/LOG/Files/SQLSetup0001_CSZ_Core.log
 C:/Program Files/Microsoft SQL Server/90/Setup Bootstrap/LOG/Summary.txt
 C:/Program Files/Microsoft SQL Server/90/Setup Bootstrap/LOG/Files/SQLSetup0001_CSZ_.NET Framework 2.0 LangPack.log
 C:/Program Files/Microsoft SQL Server/90/Setup Bootstrap/LOG/Files/SQLSetup0001_CSZ_.NET Framework Upgrade Advisor.log
 C:/Program Files/Microsoft SQL Server/90/Setup Bootstrap/LOG/Files/SQLSetup0001_CSZ_.NET Framework Upgrade Advisor LangPack.log
 C:/Program Files/Microsoft SQL Server/90/Setup Bootstrap/LOG/Files/SQLSetup0001_CSZ_.NET Framework Windows Installer.log
 C:/Program Files/Microsoft SQL Server/90/Setup Bootstrap/LOG/Files/SQLSetup0001_CSZ_.NET Framework Windows Installer LangPack.log
 C:/Program Files/Microsoft SQL Server/90/Setup Bootstrap/LOG/Files/SQLSetup0001_CSZ_Support.log
 C:/Program Files/Microsoft SQL Server/90/Setup Bootstrap/LOG/Files/SQLSetup0001_CSZ_SCC.log
 C:/Program Files/Microsoft SQL Server/90/Setup Bootstrap/LOG/Files/SQLSetup0001_CSZ_WI.log

3、当我检查到日志文件SQLSetup0001_CSZ_Core.log,发现在日志文件末尾有如下的错误提示:
{英文原意如下:
When you examine the SQLSetupNumber_ServerName_Core(local).log file at this point, you notice the following error message at the end of the log file: }

Running: InstallToolsAction.10 at: 2007/9/10 8:35:36
Error: Action "InstallToolsAction.10" threw an exception during execution.  Error information reported during run:
Target collection includes the local machine.
Fatal Exception caught while installing package: "10"
        Error Code: 0x80070002 (2)
Windows Error Text: 系统找不到指定的文件。
  Source File Name: sqlchaining/sqlprereqpackagemutator.cpp
Compiler Timestamp: Tue Aug  9 01:14:20 2005
     Function Name: sqls::SqlPreReqPackageMutator::modifyRequest
Source Line Number: 196
---- Context -----------------------------------------------
sqls::InstallPackageAction::perform
WinException caught while installing package. : 1603
        Error Code: 0x80070643 (1603)
Windows Error Text: 安装时发生严重错误
  Source File Name: packageengine/installpackageaction.cpp
Compiler Timestamp: Fri Jul  1 01:28:25 2005
     Function Name: sqls::InstallPackageAction::perform
Source Line Number: 167
---- Context -----------------------------------------------
sqls::InstallPackageAction::perform
Error: Failed to add file :"C:/Program Files/Microsoft SQL Server/90/Setup Bootstrap/LOG/Files/SQLSetup0001_CSZ_.NET Framework 2.0.log" to cab file : "C:/Program Files/Microsoft SQL Server/90/Setup Bootstrap/LOG/SqlSetup0001.cab" Error Code : 2
Error: Failed to add file :"C:/Program Files/Microsoft SQL Server/90/Setup Bootstrap/LOG/Files/SQLSetup0001_CSZ_.NET Framework 2.0 LangPack.log" to cab file : "C:/Program Files/Microsoft SQL Server/90/Setup Bootstrap/LOG/SqlSetup0001.cab" Error Code : 2
Error: Failed to add file :"C:/Program Files/Microsoft SQL Server/90/Setup Bootstrap/LOG/Files/SQLSetup0001_CSZ_.NET Framework Upgrade Advisor.log" to cab file : "C:/Program Files/Microsoft SQL Server/90/Setup Bootstrap/LOG/SqlSetup0001.cab" Error Code : 2
Error: Failed to add file :"C:/Program Files/Microsoft SQL Server/90/Setup Bootstrap/LOG/Files/SQLSetup0001_CSZ_.NET Framework Upgrade Advisor LangPack.log" to cab file : "C:/Program Files/Microsoft SQL Server/90/Setup Bootstrap/LOG/SqlSetup0001.cab" Error Code : 2
Error: Failed to add file :"C:/Program Files/Microsoft SQL Server/90/Setup Bootstrap/LOG/Files/SQLSetup0001_CSZ_.NET Framework Windows Installer.log" to cab file : "C:/Program Files/Microsoft SQL Server/90/Setup Bootstrap/LOG/SqlSetup0001.cab" Error Code : 2
Error: Failed to add file :"C:/Program Files/Microsoft SQL Server/90/Setup Bootstrap/LOG/Files/SQLSetup0001_CSZ_.NET Framework Windows Installer LangPack.log" to cab file : "C:/Program Files/Microsoft SQL Server/90/Setup Bootstrap/LOG/SqlSetup0001.cab" Error Code : 2
Running: UploadDrWatsonLogAction at: 2007/9/10 8:42:36
Message pump returning: 1603

4、问题解决
在d:盘根目录下建立sqlserver2005Setup目录,再在d:/sqlserver2005Setup/下创建2个目录
/Servers
/Tools
如果是2个cd的安装程序,将cd1上的所有文件拷贝到Servers目录下,将cd2目录下的所有文件拷贝到Tools下;如果是一个dvd的安装程序,则分别把dvd上的Servers和Tools目录下的所有文件分别拷贝到d:/sqlserver2005Setup/Servers和d: /sqlserver2005Setup/Tools
再进行安装应该就没有问题。

热门栏目