Microsoft KB Archive/938215

= Error message when you run any Windows Key Management Service Management Pack report in MOM 2005: &quot;SELECT permission denied on object&quot; =

Article ID: 938215

Article Last Modified on 6/25/2007

-

APPLIES TO


 * Microsoft Operations Manager (MOM) 2005

-



SYMPTOMS
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.



CAUSE
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.



RESOLUTION
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

 * 1) Start SQL Server Enterprise Manager.
 * 2) Expand Microsoft SQL Servers, expand SQL Server Group, and then expand (local) (Windows NT).
 * 3) Expand Databases, expand SystemCenterReporting, and then click Tables.
 * 4) Right-click a KMS table, and then click Properties. For example, right-click KMSActivationCount.
 * 5) Click Permissions.
 * 6) 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.)
 * 7) Click OK.
 * 8) 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

 * 1) Start the SQL Server Management Studio program, and then connect to the appropriate server.
 * 2) Expand Databases, expand SystemCenterReporting, and then click Tables.
 * 3) Right-click a KMS table, and then click Properties. For example, right-click KMSActivationCount.
 * 4) In the Select a page pane, click Permissions.
 * 5) Click Add, and then click Browse.
 * 6) Click to select the [SC dW Reader] check box that corresponds to a Database role type, and then click OK two times.
 * 7) 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.
 * 8) Follow steps 3 through 7 to grant the Select permission to the SC DW Reader database role for each KMS table.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.



MORE INFORMATION
To obtain the Windows Key Management Service Management Pack for MOM 2005, visit the following Microsoft Web site:

http://www.microsoft.com/downloads/details.aspx?FamilyId=F500D97B-8648-49B8-AF7C-C65A47E83256&displaylang=en

Keywords: kbtshoot kbprb KB938215

-

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

© Microsoft Corporation. All rights reserved.