Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 938215 - Last Review: June 25, 2007 - Revision: 1.0
Error message when you run any Windows Key Management Service Management Pack report in MOM 2005: "SELECT permission denied on object"
You have installed the Microsoft Windows Key Management Service (KMS) Management Pack for Microsoft Operations Manager (MOM) 2005. When you run any Windows Key Management Service Management Pack report, you receive an error message that resembles the following:
An error has occurred during report processing. (rsProcessingAborted) Get Online Help
Query execution failed for data set 'SystemCenterReporting'. (rsErrorExecutingCommand) Get Online Help
SELECT permission denied on object 'KMSActivationCount', database 'SystemCenterReporting', owner 'dbo'.
You do not receive an error message when you run other MOM 2005 reports.
This problem occurs if the Select permission is not assigned to the SC DW Reader database role for the KMS tables. These tables include the following:
- KMSActivationCount
- KMSActivitySummary
- KMSActivitySummaryByComputerName
- KMSCumulativeData
- KMSReportDataAll
- KMSReportDataLatestByCMID
- KMSTimePeriods
- KMSWindowsEditions
In MOM 2005, the SC DW DTS database role is assigned to a group that contains the MOM Data Transfer account. Also, the SC DW Reader database role is assigned to a group that contains the MOM Reporting user account. MOM 2005 uses the MOM Reporting user account to run reports. MOM 2005 does not use the MOM Data Transfer account to run reports. Therefore, if the Select permission is not assigned to the SC DW Reader database role for the KMS tables, you experience this problem.
To resolve this problem, grant the Select permission to the SC DW Reader database role for all the KMS tables. To do this, use one of the following methods, as appropriate for the version of Microsoft SQL Server that you are running.
Method 1: SQL Server 2000
- Start SQL Server Enterprise Manager.
- Expand Microsoft SQL Servers, expand SQL Server Group, and then expand (local) (Windows NT).
- Expand Databases, expand SystemCenterReporting, and then click Tables.
- Right-click a KMS table, and then click Properties.
For example, right-click KMSActivationCount.
-
Click Permissions.
-
Click to select the SELECT check box that corresponds to the SC DW DTS role. (This role is represented by an icon that appears as two users.)
- Click OK.
- Follow steps 4 through 7 to grant the Select permission to the SC DW Reader database role for each KMS table.
Method 2: SQL Server 2005
- Start the SQL Server Management Studio program, and then connect to the appropriate server.
- Expand Databases, expand SystemCenterReporting, and then click Tables.
- Right-click a KMS table, and then click Properties.
For example, right-click KMSActivationCount.
- In the Select a page pane, click Permissions.
- Click Add,
and then click Browse.
- Click to select the [SC dW Reader] check box that corresponds to a Database role type, and then click OK two times.
- Under Explicit permissions for SC DW Reader box, click to select the Grant check box that corresponds to the Select permission, and then click OK.
- Follow steps 3 through 7 to grant the Select permission to the SC DW Reader database role for each KMS table.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
To obtain the Windows Key Management Service Management Pack for MOM 2005, visit the following Microsoft Web site:
APPLIES TO
- Microsoft Operations Manager (MOM) 2005
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate