The reporting functionality in System Center Essentials 2007 Service Pack 1 stops working after you apply security update 948109 on the Windows Essential Business Server Management Server

Article translations Article translations
Article ID: 957755 - View products that this article applies to.
Expand all | Collapse all

On This Page

SYMPTOMS

In a Windows Essential Business Server 2008 environment, you install the security update for SQL Server 2005 Service Pack 2 that is described in the following Microsoft Knowledge Base article:
948109 MS08-040: Description of the security update for SQL Server 2005 GDR: July 8, 2008
By default, this update is recommended. However, after it is applied on the Windows Essential Business Server Management server, the reporting functionality in System Center Essentials 2007 Service Pack 1 (SP1) stops working. Additionally, you receive an exception dialog that contains an error message that resembles the following:
HTTP Error 403.1 Forbidden

RESOLUTION

Update information

An update is available to re-enable the reporting functionality of System Center Essentials 2007 SP1.

Note To manually resolve this problem, see the "How to manually resolve this problem" section in this article.

How to install this update

To apply this update to System Center Essentials 2007 SP1, follow these steps:
  1. Open Control Panel on the Windows Essential Business Server Management server.
  2. Open the Windows Update item.
  3. Click Check online for updates from Microsoft Update Service.
  4. Review the available updates, and then in the list of updates, click to select the update whose name contains 957755, and then click Install.

How to uninstall this update

To uninstall this update, follow these steps:
  1. Open Control Panel on Windows Essential Business Server Management Server.
  2. Open the Programs and Features item.
  3. Click View installed updates.
  4. Select the item that has a name that contains 957755, and then click Uninstall.

Prerequisites

To apply this update, you must have Windows Essential Business Server 2008 and System Center Essentials 2007 SP1 installed.

Restart requirement

You may have to restart the computer after you apply this update.

File information

The English version of this update has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.
Collapse this tableExpand this table
File nameFile sizeDateTimePlatform
EBS-KB957755-amd64-ENU.msi23,04028-Oct-200823:51x64

How to manually resolve this problem

To resolve this problem manually, follow these steps:
  1. On Windows Essential Business Server Management Server, open a command prompt.
  2. Run the following command at the command line window:

    %SystemRoot%\System32\inetsrv\appcmd.exe set config "Default Web Site/ReportServer$SCE" /section:handlers /accessPolicy:Read,Script
  3. After the command in step 2 is complete, run the following command at the command line window:

    %SystemRoot%\System32\Icacls.exe "%PROGRAMFILES(X86)%\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer\rsreportserver.config" /grant *S-1-5-20:F
To undo the manual resolution manually, follow these steps:
  1. On Windows Essential Business Server Management Server, open a command prompt.
  2. Run the following command at the command line window:

    %SystemRoot%\System32\Icacls.exe "%PROGRAMFILES(X86)%\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer\rsreportserver.config" /remove:g *S-1-5-20
  3. Run the following command at the command line window:

    %SystemRoot%\System32\inetsrv\appcmd.exe set config "Default Web Site/ReportServer$SCE" /section:handlers /accessPolicy:Read

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

MORE INFORMATION

For more information about Windows Essential Business Server, visit the following Microsoft Web site:
http://www.microsoft.com/ebs/en/us/default.aspx
For more information about how to install and how to configure Microsoft SQL Server 2005 Reporting Services, click the following article number to view the article in the Microsoft Knowledge Base:
938245 How to install and how to configure SQL Server 2005 Reporting Services on a computer that is running Windows Server 2008
For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:
824684 Description of the standard terminology that is used to describe Microsoft software updates

Properties

Article ID: 957755 - Last Review: November 12, 2008 - Revision: 1.1
APPLIES TO
  • Windows Essential Business Server 2008 Standard
Keywords: 
kbexpertiseadvanced kbfix kbqfe KB957755

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com