Error message when you try to import Management Pack reports in Microsoft Operations Manager 2005: "Import failed" (925439)


The information in this article applies to:

  • Microsoft Operations Manager 2005

SYMPTOMS

When you use the Microsoft operations Manager (MOM) 2005 Administrator console to try to import Management Pack reports, you receive the following error message:
Description: Import failed.
Report server url: http://ServerName/ReportServer/ReportService.asmx
Report import file: C:\MOM 2005 Management Packs\ManagementPackName\Report.XML
Error message: The permissions granted to user 'DOMAIN\user' are insufficient for performing this operation.

CAUSE

This issue occurs when one of the following conditions is true:
  • You do not have permissions to import the Management Pack report folder.
  • You do not have permissions to access an individual Management Pack report.

RESOLUTION

To resolve this issue, you must turn on SQL Reporting Services verbose logging to identify the report folder or the report that is causing the issue, and then grant the required permissions. To do this, follow these steps.

Turn on SQL Reporting Services verbose logging

  1. Click Start, click Run, type notepad, and then click OK.
  2. In Notepad, open the Web.config file that is located in the Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer folder.
  3. Locate the following line in the Web.config file:
    <add name="DefaultTraceSwitch" value="3" />
  4. Change value="3" to value="4" in the Web.config file.
  5. Restart the ReportServer Service.
  6. Search in the most recent log file for the AccessDeniedException information. This information indicates which report is causing the issue.

    For example, the most recent log file that is located in the Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles folder may contain an error message that resembles the following:
    w3wp!runningrequests!1544!08/02/2006-13:03:38:: v VERBOSE: SoapAction: "http://schemas.microsoft.com/sqlserver/2003/12/reporting/reportingservices/GetReportDefinition"
    w3wp!library!1544!08/02/2006-13:03:38:: v VERBOSE: Call to GetReportDefinition( '/Users Folders/UserFolderName/My Reports/ReportName')
    w3wp!library!1544!08/02/2006-13:03:38:: e
    ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'DOMAIN\User' are insufficient for performing this operation., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException:
    Note ReportName represents the name of the report that you cannot access.

Grant the required permissions

  1. Click Start, point to All Programs, click Microsoft SQL Server, point to Reporting Services, and then click Report Manager.
  2. On the Microsoft Operations Manager Reporting page, click Site Settings.
  3. On the SQL Server Reporting Services Site Settings page, click to select the Enable My Reports to support user-owned folders for publishing and running personalized reports check box.
  4. Click the list that is next to the Choose the role to apply to each user's My Reports folder, and then select Content Manager.
  5. Click Apply to save the changes.
Modification Type:MinorLast Reviewed:10/9/2006
Keywords:kbprb KB925439 kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.