SSRS 2014: Reporting Services Security - Data Security
This video covers one aspect of security when using Reporting Services: Data Security. You'll learn about how report data security hooks into the data security features of the core database engine of SQL Server. You'll see how to require different kinds of credential for any data source, both in SQL Server Data Tools and in Report Manager. You'll also learn about the permissions required to access data for a report.
Reports need access to data sources. And data source security represents the other half of the security puzzle in Reporting Services. A report that accesses data really is no different from any other data access operation in SQL Server, whether the request comes from a query in Management Studio, an Entity Framework model in a .NET application, or another instance of SQL Server that uses your server as a linked server. You need to protect access to that data, no matter how you allow users and applications to query it. So what we'll cover here is just the Reporting Services features that you can use to protect your data while making it available to reports you or your users build.