In writing this chapter we contacted the Product Support Services (PSS) group in Dallas, Texas. They let us know some of the most common installation issues that they have been receiving calls about for years, which we share with you in this section.
There is a common problem many users run into when they try to install the SQL Server client tools from a fileshare copied from the install CD. They get the following error:
There was an unexpected failure during the setup wizard. You may review the setup logs and/or click the help button for more information. SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%\Microsoft SQL Server\100\Setup Bootstrap\LOG\Summary.txt.
When you go to the CORE(local).Log, you find the following information:
Running: InstallToolsAction.10 at: 2008/0/18 11:35:13 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: The system cannot find the file specified. Source File Name: sqlchaining\sqlprereqpackagemutator.cpp Compiler Timestamp: Tue Aug 9 01:14:20 2008 Function Name: sqls::SqlPreReqPackageMutator::modifyRequest Source Line Number: 196 ---- Context ----------------------------------------------- sqls::InstallPackageAction::perform ...