SMS Reporting Issue
From: Karen (Karen_at_discussions.microsoft.com)
Date: 12/16/04
- Next message: emebohw2_at_netscape.net: "Re: sms collection based on AD OU membership"
- Previous message: Jed Dunn: "Re: sms collection based on AD OU membership"
- Next in thread: Karen: "RE: SMS Reporting Issue"
- Reply: Karen: "RE: SMS Reporting Issue"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 16 Dec 2004 08:33:09 -0800
We are running SMS 2003 sp1 and having an issue with Reporting. The report
summary pages can be viewed but I cannot view the details of a report.
whenever I try to drill down to the details page I get the following error
message:
An error occurred when the report was run. The details are as follows:
SELECT permission denied on object 'v_RA_System_SMSInstalledSites', database
'SMS_BOS', owner 'dbo'.
Error Number: -2147217911
Source: Microsoft OLE DB Provider for SQL Server
Native Error: 229
I am logged on as an SMS Admin; the NT AUTHORITY\SYSTEM account is the
account being used to run the report; my account and the NT AUTHORITY\SYSTEM
have full control permissions to SMS Reporting and to the SQL database. what
am I missing? Any help would be greatly appreciated.
Thanks,
Karen
- Next message: emebohw2_at_netscape.net: "Re: sms collection based on AD OU membership"
- Previous message: Jed Dunn: "Re: sms collection based on AD OU membership"
- Next in thread: Karen: "RE: SMS Reporting Issue"
- Reply: Karen: "RE: SMS Reporting Issue"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
