Reporting Services E-mail Subscription
Hi all,
I would appreciate if you could help me with the following problem related to e-mail subscription in SSRS.
I am currently using SQL Server 2008 R2 Standard Edition 64-bit, which is installed on Windows Server 2008 R2 Standard Edition 64-bit, also having IIS 7.5. Reporting Services is installed on the same server using Native Mode. In "Reporting Services
Configuration Manager", I have the "Service Account" page set up to a Windows user with administrative privileges, that is "Use another account" is checked with user "ServerName\SQLReporting" and with correct password.
I am stating the issue with the e-mail subscription in two stages:
1) My primary goal was to use a connection to a REMOTE SMTP server. The REMOTE SMTP server requires a username and a PASSWORD. However, in the "rsreportserver.config" file, there is not a spot to provide the PASSWORD for the username, and thus I cannot
satisfy the authentication requirement of the REMOTE SMTP server. Is there a solution to this problem? Do you know how to provide a password in the "rsreportserver.config" file?
2) To work around the problem stated in part 1, I have been trying to use a LOCAL SMTP server to relay to the remote SMTP server. I have configured the "rsreportserver.config" file as shown below:
<Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<RSEmailDPConfiguration>
<SMTPServer></SMTPServer>
<SMTPServerPort>
</SMTPServerPort>
<SMTPAccountName>
</SMTPAccountName>
<SMTPConnectionTimeout>
</SMTPConnectionTimeout>
<SMTPServerPickupDirectory>
\\ServerName\c\inetpub\mailroot\Pickup
</SMTPServerPickupDirectory>
<SMTPUseSSL>
</SMTPUseSSL>
<SendUsing>1</SendUsing>
<SMTPAuthenticate>
</SMTPAuthenticate>
<From>anemail@emaildomain.com</From>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML</RenderingExtension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderFormats>
</PrivilegedUserRenderFormats>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
<RenderingExtension>RGDI</RenderingExtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>
False
</SendEmailToUserAlias>
<DefaultHostName>
</DefaultHostName>
<PermittedHosts>
</PermittedHosts>
</RSEmailDPConfiguration>
</Configuration>
</Extension>
However, I keep on receiving the following error message in the subscription page on Reports Manager:
"Failure sending mail: The filename, directory name, or volume label syntax is incorrect. Mail will not be resent." The error message is still thrown even if I uncheck the option for attachment, but to insert only the link to the report. In "rsreportserver.config"
file, I also try to use
<SMTPServerPickupDirectory>
c:\inetpub\mailroot\Pickup
</SMTPServerPickupDirectory>
but, the same error still persists.
What would be the solution? What is the fix?
Please feel free to provide a concrete solution to any of the two stages.
I thank you all for your time.
May 29th, 2012 11:53am
Hi There
Did you go you Reporting Services Configuration Manager and go to the Email setting and specify your SMTP server etc. in there as I can see your
<SMTPServer></SMTPServer> blank
After that I have not change anything inside my rsreportserver.config file and all the setting has been done by the configuration manger and my rsreportserver.config file look like this
http://msdn.microsoft.com/en-us/library/ms345234(SQL.105).aspx
http://msdn.microsoft.com/en-us/library/ms159155.aspx
I am putting some screenshot for your help.
If you have any questions please do ask.
Many Thanks
Syed Qazafi Anjum
Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.
<Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<RSEmailDPConfiguration>
<SMTPServer>abcsmtp.test.com</SMTPServer>
<SMTPServerPort>
</SMTPServerPort>
<SMTPAccountName>
</SMTPAccountName>
<SMTPConnectionTimeout>
</SMTPConnectionTimeout>
<SMTPServerPickupDirectory>
</SMTPServerPickupDirectory>
<SMTPUseSSL>
</SMTPUseSSL>
<SendUsing>2</SendUsing>
<SMTPAuthenticate>
</SMTPAuthenticate>
<From>HelpDesk@test.com</From>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML</RenderingExtension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderFormats>
</PrivilegedUserRenderFormats>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
<RenderingExtension>RGDI</RenderingExtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>True</SendEmailToUserAlias>
<DefaultHostName>
</DefaultHostName>
<PermittedHosts>
</PermittedHosts>
</RSEmailDPConfiguration>
</Configuration>
</Extension>
Free Windows Admin Tool Kit Click here and download it now
May 29th, 2012 6:29pm


