SQL Server 2008安装失败：Error writing to file:Microsoft.analysisServices.AdomdClient.dll.

问题描述

==========

SQL Server 2008 标准版安装在Windows Server 2008上失败，错误为：

Error writing to file:Microsoft.analysisServices.AdomdClient.dll. Verify that you have access to that directory.

故障排查

==========

根据错误日志，存在以下错误信息：

1.在安装到Install_sql_common_core_Cpu32_Action ： InstallFiles. Copying new files时出现以下错误信息：

Error writing to file:Microsoft.analysisServices.AdomdClient.dll. Verify that you have access to that directory.

2.在安装到Install_SqlBrowser_Cpu32_Action时出现以下错误信息：

系统无法从指定的设备上读取（The system cannot read from the specified device.）

3.在Detail.txt中存在以下错误信息：

Bootstrap/Log/20110620_153155/Registry_SOFTWARE_Microsoft_MSSQLServer.reg_

2011-06-20 16:07:03 Slp: 系统无法从指定的设备上读取。

2011-06-20 16:07:03 Slp: Watson bucket for Msi based failure has been created

2011-06-20 16:07:03 Slp: InstallPackage: MsiInstallProduct returned the result code 30.

2011-06-20 16:07:03 Slp: Retry-able MSI return code detected: 30

2011-06-20 16:07:03 Slp: Prompting user if they want to retry this action due to the following failure:

2011-06-20 16:07:03 Slp: ----------------------------------------

2011-06-20 16:07:03 Slp: The following is an exception stack listing the exceptions in outermost to innermost order

2011-06-20 16:07:03 Slp: Inner exceptions are being indented

2011-06-20 16:07:03 Slp:

2011-06-20 16:07:03 Slp: Exception type: Microsoft.SqlServer.Configuration.MsiExtension.MsiExtensionException

2011-06-20 16:07:03 Slp:     Message:

2011-06-20 16:07:03 Slp:         SQL Server 安装程序在运行 Windows Installer 文件时遇到错误。

2011-06-20 16:07:03 Slp:        

2011-06-20 16:07:03 Slp:         Windows Installer 错误消息: 系统无法从指定的设备上读取。

2011-06-20 16:07:03 Slp:        

2011-06-20 16:07:03 Slp:         Windows Installer 文件: N:/x86/setup/sqlbrowser.msi

2011-06-20 16:07:03 Slp:         Windows Installer 日志文件: C:/Program Files/Microsoft SQL Server/100/Setup Bootstrap/Log/20110620_153155/SqlBrowser_Cpu32_1.log

2011-06-20 16:07:03 Slp:     Data:

2011-06-20 16:07:03 Slp:       DisableRetry = true

2011-06-20 16:07:03 Slp:     Inner exception type: System.ComponentModel.Win32Exception

2011-06-20 16:07:03 Slp:         Message:

2011-06-20 16:07:03 Slp:                 系统无法从指定的设备上读取。

2011-06-20 16:07:03 Slp:                

2011-06-20 16:07:03 Slp: ----------------------------------------

2011-06-20 16:23:57 Slp: Error result: -2068643839

2011-06-20 16:23:57 Slp: Result facility code: 1203

2011-06-20 16:23:57 Slp: Result error code: 1

2011-06-20 16:23:57 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine

2011-06-20 16:23:57 Slp: Sco: Attempting to open registry subkey Software/Microsoft/PCHealth/ErrorReporting/DW/Installed

2011-06-20 16:23:57 Slp: Sco: Attempting to get registry value DW0200

2011-06-20 16:23:58 Slp: Submitted 5 of 5 failures to the Watson data repository

2011-06-20 16:24:05 Slp: Detected localization resources folder: 1033

2011-06-20 16:24:05 Slp: Detected localization resources folder: 2052

4.在SqlBrowser_Cpu32_1.log中存在以下错误信息：

MSI (s) (30:D4) [16:05:48:937]: Note: 1: 1305 2: N:/x86/setup/sqlbrowser.msi 3: 1117

MSI (s) (30:10) [16:07:03:656]: I/O on thread 2992 could not be cancelled. Error: 1168

MSI (s) (30:10) [16:07:03:656]: I/O on thread 796 could not be cancelled. Error: 1168

MSI (s) (30:10) [16:07:03:656]: I/O on thread 2172 could not be cancelled. Error: 1168

MSI (s) (30:10) [16:07:03:656]: I/O on thread 3280 could not be cancelled. Error: 1168

MSI (s) (30:10) [16:07:03:656]: I/O on thread 3796 could not be cancelled. Error: 1168

MSI (s) (30:10) [16:07:03:656]: I/O on thread 812 could not be cancelled. Error: 1168

MSI (s) (30:D4) [16:07:03:656]: MainEngineThread is returning 30

MSI (s) (30:10) [16:07:03:656]: No System Restore sequence number for this installation.

系统无法从指定的设备上读取。

出现以上错误可能是由于系统无法从光驱中读取安装文件。可能有以下几种原因：

1.光驱发生损坏

2.安装光盘中的文件发生损坏。

3.通过远程路径进行安装，并且不具有足够的权限

4.通过远程桌面进行安装

解决办法

==========

1.将光盘中的文件复制粘贴到本地（如果出现错误，请从网站上重新获取正确完好的安装文件）

2.在本地直接安装而不使用远程安装