Problem - SSRS 2005 and email subscriptions

Search: Find

Home

Book

Contents

Preview

Articles

Tools

Newsletters

Premium

Ask

About

Most Popular Articles

Using Secure Sockets Layer (SSL) for SQL Server 2000 Reporting Services
Creating an SSL Certificate to ensure your confidential reports remain confidential

SQL Reporting Services - Answers to your questions

Notify me of new comments

Author

Thread: Problem - SSRS 2005 and email subscriptions

JamesE

Problem - SSRS 2005 and email subscriptions
Posted: Friday, April 07, 2006 2:33 PM (GST)

Hi -

Having a problemm with email subscriptions on the following configuration:

Win 2003 Enterprise
SQL 2005 Enterprise
Configured SSRS to use another server as the SMTP server

Every time I schedule a subscription - it generates the following error:

Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information.

I do find the following warnings in the ReportServerWebApp.log:

The extension Report Server Email does not have a LocalizedNameAttribute

The extension Report Server FileShare does not have a LocalizedNameAttribute.

Do I need to add these attributes to the config file - if so is there an example of what is required?

Any help appreciated - thanks.

Comments:

Author Thread:

hellanm

Problem - SSRS 2005 and email subscriptions
Posted: Friday, June 23, 2006 12:13 AM (GST)

Did you ever resolve this issue? We're facing the same problem and I've found no answers anywhere. Thanks!

JamesE

Problem - SSRS 2005 and email subscriptions
Posted: Friday, June 23, 2006 12:25 AM (GST)

Yes -

It turns out that we had configured the service that runs all the jobs for sql server (SQL Server Agent (SQL2005)) to logon as a local system account - that account does not have permissions on the remote smtp server to read and write to disk. We chaged the configuration so that the service logs on as a domain account with privledges on the remote smtp server and all is well.

Having said that - this may or may not be your issue as many things can cause reporting services to have issues with email delivery but give it a look and good luck.

mjgtennis

Problem - SSRS 2005 and email subscriptions
Posted: Wednesday, March 18, 2009 3:39 PM (GST)

Just stumbled onto a strange issue with the same error message. We have had a number of subscriptions that have failed with this message under the following path - 1. RS 2000 upgraded to RS 2005 2. Report subscriptions worked fine. 3. Additional development on report and converting report in visual studio environment from "http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition" to "http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" 4. Subscriptions then started failing. 5. Reset to previous version of report and made coding changes in xml instead of visual studio. ...still tracking down more convenient solution.