THIS TOPIC APPLIES TO:SQL Server 2016January 2017 Technical Preview of Power BI reports in SQL Server Reporting ServicesSharePoint 2013SharePoint 2016
Before users and alerting administrators can create, edit, delete, and view data alerts they must be granted SharePoint permissions. There are no special permissions to use with the Reporting Services data alerting feature, you use the built-in SharePoint permissions.
Reporting Services integration with SharePoint is no longer available after SQL Server 2016.
Information workers—Permissions must include the Create Alert and View Items SharePoint permissions. The built-in SharePoint permission levels named Design, Contribute, Read, and View Only include the Create Alert and View Items SharePoint permissions. You can also create a custom permission level with the permissions required to support users that create, edit, run, and view data alerts.
Alerting administrators—Permissions must include the Manage Alert SharePoint permission. By default only the Full Control permission level includes this permission for sites created with the Team Site site template. If you use other site templates, you will see different lists of default SharePoint groups. You can add the Manage Alert permission to one of the built-in permission levels or create a custom permission level with the permission required to support alerting administrators that view and delete data alerts.
To learn more about SharePoint permissions, see User permissions and permission levels (SharePoint Server 2010).
Go to the SharePoint site to which you want to grant permissions.
On the toolbar, click Site Actions and then click Site Permissions.
If you do not see this option, you do not sufficient permission to grant permissions to others.
Click Grant Permissions.
In Users/Groups, type the user names, group names, or e-mail addresses you want grant permission to.
Select the Add users to a SharePoint group or Grant users permission directly option. Depending on whether you selected Add users to a SharePoint group or Grant users permissions directly do one of the following:
If you selected Add users to a SharePoint group, select a permission level in the drop-down list.
If you selected Grant users permissions directly, select a permission level.