Reporting Services Email Subscriptions

You've got SQL Agent running already, so what other steps are needed to deliver a report via email? Learn how to update the configuration to support SMTP and how to build the subscription - all in less time than it takes to finish your coffee (if the cup is full right now).

Devin (MCTS) is a Senior BI consultant at Pragmatic Works Consulting. Previously, he has tech edited the book Professional Microsoft SQL Server 2008 Integration Services and was an author in the book Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services. Devin has spoken at past conferences like PASS and at several SQL Saturday events. He is a contributing member to the Business...

Raymond on 3/3/2010

Thanks

Darpan on 3/3/2010

Simply Excellent

Mark on 3/3/2010

I am trying to set up email subscriptions on SQL 2005 this is the erro I get. Can you provide me with some direction. An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help EXECUTE permission denied on object 'sp_add_category', database 'msdb', schema 'dbo'. I love your video's

Devin Knight on 3/3/2010

From the looks of the error it sounds like the data source account that's being used does not have rights to the stored procedure used in your report.

John O'Sullivan on 3/3/2010

Excellent SSRS video

Munna Bhai on 3/3/2010

Great video. Thanks for sharing....

FELIX on 3/3/2010

Keep coming more and more!!! Excellent video.

Michael Davis on 3/3/2010

Great Video

Arun on 3/3/2010

Good Video

Anand on 3/5/2010

very nice explanation

ricardoacaraujo@hotmail.com on 3/16/2010

Muito bom

Bahadir on 3/27/2010

thanks

vinay on 4/19/2010

very help full

Steve Culshaw on 5/29/2010

Blurry video

Ankur Arroa on 6/24/2010

Nice simple video to learn about configuring Subscriptions, Thanks

Edward on 2/2/2011

Good.

Edward on 2/2/2011

gr8 video!!

Anil Babu on 2/26/2011

good

Affzal on 1/10/2012

How do we create snapshots, please help.

Devin Knight on 1/11/2012

Affzal- here's a good resource for snapshots. http://www.mssqltips.com/sqlservertip/1922/working-with-report-snapshots-in-sql-server-reporting-services-ssrs/

Guru on 9/3/2012

very good