Error message when you install Reporting Services on a Windows SBS 2003 R2-based computer: "The setup has encountered an unexpected error while setting reporting service and share point exclusion path" (920803)


The information in this article applies to:

  • Microsoft Windows Small Business Server 2003 R2, Premium Edition, when used with:
    • Microsoft Internet Security and Acceleration Server 2004
  • Microsoft Windows Small Business Server 2003 R2, Standard Edition, when used with:
    • Microsoft Internet Security and Acceleration Server 2004

SYMPTOMS

Consider the following scenario:
  • You install Microsoft Windows Small Business Server 2003 R2.
  • You install Microsoft Internet Security and Acceleration (ISA) Server 2004.
  • You run the Configure E-mail and Internet Connection Wizard (CEICW).
  • You install a default instance of Microsoft SQL Server 2005. On the Components to install page in the SQL Server Installation Wizard, you install Reporting Services. On the Reporting Service Installation Options page, you select the default configuration.
In this scenario, you receive the following error message:
Microsoft SQL Server 2005 Setup

The setup has encountered an unexpected error while setting reporting service and share point exclusion path.

The error is: Fatal error during installation.
When you examine the SQLSetupNumber_ServerName_Core(local).log file, you notice an error message that resembles the following:
Doing Action: Do_RSSetSharePointExclusionPath PerfTime Start: Do_RSSetSharePointExclusionPath : Thu May 25 09:08:17 2006 <Func Name='Do_RSSetSharePointExclusionPath'> The application pool /s already exists. Error Code: 0x80077374 (29556) Windows Error Text: Source File Name: sqlca\sqliisca.cpp Compiler Timestamp: Mon Aug 29 01:18:41 2005 Function Name: Do_RSSetSharePointExclusionPath Source Line Number: 840

Error Code: 29556
MSI (s) (80!A4) [09:08:42:332]: Product: Microsoft SQL Server 2005 Reporting Services -- Error 29528. The setup has encountered an unexpected error while Setting reporting service and share point exclusion path. The error is: Fatal error during installation.

Error 29528.
The setup has encountered an unexpected error while Setting reporting service and share point exclusion path. The error is: Fatal error during installation.

<Failure Type='Fatal' Error='29556'>

CAUSE

This problem occurs when the IP address for the Microsoft Internet Information Services (IIS) Default Web Site setting is not set to All Unassigned. If the SQL Server 2005 Reporting Services setup process cannot detect the Default Web Site setting, a new Web site is created. When SQL Server tries to configure the new Web site, the setup process fails, and an error message is generated.

RESOLUTION

To resolve this problem, follow these steps:
  1. Click Start, click Administrative Tools, and then click Internet Information Services (IIS) Manager.
  2. In the Internet Information Services (IIS) Manager MMC snap-in, expand ServerName, expand Web Sites, right-click Default Web Site, and then click Properties.
  3. In the Default Web site Properties dialog box, click the Web Site tab, click the list next to IP address, click (All Unassigned), and then click OK.
  4. Reinstall SQL Server 2005. Select the SQL Reporting Services option during the installation process..
  5. After you successfully install SQL Server 2005 and SQL Reporting Services, repeat steps 1 through 3, but reset the Default Web Site IP address to the internal IP address.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Modification Type:MajorLast Reviewed:7/11/2006
Keywords:kbprb KB920803 kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.