-
Native
Mode
-
Predefined
Roles
-
Site Level
- System User
- System Administrator
- Report Builder
-
Publisher
- add reports
- create folders
- Content
Manager
- Browser
-
Custom roles
- folders, reports
- reports
- and other items
-
SharePoint
Integration
-
Predefined groups
and permission levels
- Owners
- Members (Contribute)
- Visitors (Viewer)
- Custom groups
-
Securable items
- .rdl
- .smdl
- .rsds
- .rsc
- .rsd
-
Tools
for managing
permissions
-
Management Studio
- Used to view, modify,
create, and delete
role definitions
-
Report Manager
- Used to assign users
and groups to roles
-
Enable
Report
Execution
Log
-
Sharepoint
- Open SharePoint Central Administration
- Click Manage service applications
- Select Reporting Services service application
- Click System Settings
- Enable Execution Logging in the Logging section
-
Native Mode
- Start SQL Server Management Studio
- Connect to the desired report server
- Right-click the server name and click Properties
- Click the Logging page
- Change EnableExecutionLogging to True
-
Enable Trace Log
-
Sharepoint
- SharePoint Central Administration
- Click Monitoring.
- Click Configure Diagnostic Logging in the Reporting group.
- Find SQL Server Reporting Services
- Select the subcategories to be added to the trace log.
- Native Mode