Microsoft KB Archive/925439

= Error message when you try to import Management Pack reports in Microsoft Operations Manager 2005: &quot;Import failed&quot; =

Article ID: 925439

Article Last Modified on 2/8/2007

-

APPLIES TO


 * Microsoft Operations Manager (MOM) 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:// /ReportServer/ReportService.asmx

Report import file: :\MOM 2005 Management Packs\ \ .XML

Error message: The permissions granted to 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
 Click Start, click Run, type notepad, and then click OK. In Notepad, open the Web.config file that is located in the Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer folder.  Locate the following line in the Web.config file:   Change value=&quot;3&quot; to value=&quot;4&quot; in the Web.config file. Restart the ReportServer Service. 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: &quot;http://schemas.microsoft.com/sqlserver/2003/12/reporting/reportingservices/GetReportDefinition&quot;

w3wp!library!1544!08/02/2006-13:03:38:: v VERBOSE: Call to GetReportDefinition( '/ / /My Reports/ ')

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  represents the name of the report that you cannot access.</li></ol>

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.

Keywords: kbtshoot kbprb KB925439

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.