Pro SQL Server 2012 Reporting Services

CHAPTER 11  SECURING REPORTS Consume reports Create linked reports Manage all subscriptions Manage data sources Manage folders ...

CHAPTER 11  SECURING REPORTS Figure 11-11. Connecting to SSRS via SSMS Expand the Roles node to see the five default roles that ...

CHAPTER 11  SECURING REPORTS Figure 11-12. Viewing the Report Builder role task permissions From SSRS, you can also add new rol ...

CHAPTER 11  SECURING REPORTS root folder called Clinical Reports and then one inside the Clinical Reports folder called Registe ...

CHAPTER 11  SECURING REPORTS Figure 11-13. Setting up the RN_DS data source Figure 11-14 shows the folder structure and setup o ...

CHAPTER 11  SECURING REPORTS 347 Figure 11-14. Report objects for registered nurse test To begin the test, open a browser and l ...

CHAPTER 11  SECURING REPORTS Figure 11-15. Error message for insufficient permissions Running Report Manager as an administrato ...

CHAPTER 11  SECURING REPORTS Figure 11-16. Registered Nurse folder’s default permissions To set permissions for the RN group, c ...

CHAPTER 11  SECURING REPORTS Now when you access the Registered Nurse folder logged in as jyoungblood, all you see are the repo ...

CHAPTER 11  SECURING REPORTS Figure 11-18. Report properties available for an administrator To complete the test, you will simp ...

CHAPTER 11  SECURING REPORTS Figure 11-19. Test account viewing other employee’s data  Tip When building a testing environment ...

CHAPTER 11  SECURING REPORTS The global collection that you will use for the report filter is User, and the value you are inter ...

CHAPTER 11  SECURING REPORTS Because this report may return several hundred records, even though it will filter automatically f ...

CHAPTER 11  SECURING REPORTS Credentials Stored Securely in the Report Server: SSRS uses authentication credentials stored in ...

CHAPTER 11  SECURING REPORTS Figure 11-22. Setting SQL Server stored procedure permissions Auditing Reports Having the ability ...

CHAPTER 11  SECURING REPORTS Report execution activity: Which user executed which report and when, and what status the report ...

CHAPTER 11  SECURING REPORTS Figure 11-23. Report Execution Audit report Introducing Log File Auditing In addition to report au ...

CHAPTER 11  SECURING REPORTS Summary In this chapter, you examined three of the security tasks essential to secure SSRS deploym ...

C H A P T E R 12 Delivering Business Intelligence with SSRS Most companies accumulate business data that, if analyzed correctly, ...

CHAPTER 12  DELIVERING BUSINESS INTELLIGENCE WITH SSRS Building SSRS Reports for SQL Analysis Services When we began the journe ...