Error creating emailed report subscriptions in Sharepoint-integrated SSRS
Anybody who has the rights to run a report in SSRS can set up a subscription, delivering the report to their own email address. However, if you try to deliver the report as an email to somebody else, you might be greeted with this unclear error message:
It reads:
A subscription delivery error has occurred. (rsDeliveryError) One of the extension parameters is not valid for the following reason: The account you are using does not have administrator privileges. A subscription cannot be created for bob.thompson@mydomain.com. (rsInvalidExtensionParameter)
I was setting up a subscription in our Sharepoint-integrated SQL Reporting Services site, and was attending to send the report to our shared group email address. I could set it up to deliver to me and I could forward it, but it wasn't letting me send the email to anybody else's email address, either inside or outside the organization.
Solution: Grant your user "Create Alerts" and "Manage Alerts" permission
I received this error because I lacked the "Create Alerts" and "Manage Alerts" on the report in question (or folder, or higher up). The error says you need to be an administrator, but doesn't really tell you what's wrong with your request - it's really complaining that you're delivering an alert to somebody else. Granting those rights to your user account (for that report, or to an object above it so they propagate down to that report) allows you to send the report to any email address you want.
I hope this helps!
Recent Posts
- Client certificate error with Office 365 and Blackberry Hub
- Passing multi-value report parameters to SSRS using the URL querystring
- Microsoft Connect item for an SSRS pre-report canvas
- Query Business Objects repository for list of reports
- SQL Agent job fails with QUOTED_INDENTIFIER error
Recent Comments
- Cooper on Identifying SQL Server 2005 Enterprise Edition features in use
- Ryan on Exporting from SQL Server to CSV with column names
- sajitha on Exporting from SQL Server to CSV with column names
- Trevor on “Invalid server” error while altering SQL Agent Job step
- Ryan on Correcting OGG-01733 in Goldengate – Trail file header file size mismatch
Archives
- November 2018
- August 2017
- January 2017
- September 2016
- March 2016
- November 2015
- May 2015
- January 2015
- July 2014
- April 2014
- September 2013
- May 2013
- April 2013
- March 2013
- February 2013
- January 2013
- December 2012
- October 2012
- September 2012
- August 2012
- July 2012
- April 2012
- March 2012
- February 2012
- January 2012
- December 2011
- November 2011
- September 2011
- July 2011
- June 2011
- May 2011
- February 2011
- August 2010
- June 2010
- April 2010
- March 2010
- February 2010
- January 2010
- September 2009
- July 2009
- May 2009
- April 2009
- March 2009
Categories
- .NET
- Data Reporting
- Encryption
- Open Source Projects
- Oracle
- Powershell
- SQL Compact
- SQL Reporting Services
- SQL Server
- T-SQL Scripts
- Team Foundation Server
- Troubleshooting
- Uncategorized
- Windows Clustering
- Windows Server