Tuesday, October 14, 2014

Enabling Kerberos Authentication for Reporting Services

http://blogs.technet.com/b/rob/archive/2011/11/23/enabling-kerberos-authentication-for-reporting-services.aspx

Tuesday, September 16, 2014

Implement Kerberos Delegation with SSRS

http://sqlmag.com/sql-server-reporting-services/implement-kerberos-delegation-ssrs

Tuesday, July 29, 2014

SSRS report subscription: Fire Event from SSIS package

http://www.sqlservercentral.com/blogs/data-adventures/2014/07/22/ssrs-report-subscription-fire-event-from-ssis-package/

Quick and dirty way is to execute dbo.AddEvent stored procedure in the SSRS database and provide two parameters: @EventType='TimedSubscription', @EventData=@Subsciption_ID (primary key from the dbo.Subscriptions table)

You can also use the SSRS web service; see link above.

Wednesday, April 9, 2014

Troubleshooting Subscriptions

http://blogs.msdn.com/b/deanka/archive/2009/01/13/diagnosing-and-troubleshooting-subscriptions.aspx

http://blogs.msdn.com/b/deanka/archive/2010/02/16/troubleshooting-subscriptions-part-ii-using-the-report-services-trace-log-file.aspx