Celtic Coding Solutions Blog

Celtic Coding Solutions Blog - for everything computer related

SSRS Failure Sending Mail - Subscription Error From/Sender missing

Trying to create a new SQL Server 2005 Reporting Services subscription and keep getting the following error:-

Failure sending mail: At least one of the From or Sender fields is required, and neither was found.

I've checked and the To and Reply-To fields have a full email extension e.g. MyName@Company.com

The fix is quite an easy one:-

Look in the RSReportServer.config file usual located in:-

C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\ReportServer

Search under the <RSEmailDPConfiguration> for <From></From> here I noticed it had the server name so <From>ReportServer1</From>. 

I changed this to be <From>Support@Company.com</From> and now the subscription works fine.

Comments are closed