Subscription email only allows links, any other format fails -- sql server reporting services

sql server reporting services : Subscription email only allows links, any other format fails

BruceLC
1/21/2005 2:00:51 PM

I am using an external smtp server. If I do a subscription with a link only
it works. Including the report in any format (tried 4 different ones) and it
fails with the following error:

Failure sending mail: The Report Server has encountered a configuration
error; more details in the log files

I tried finding log files including (just in case) looking for any files
that had been modified today. Although I found a couple of RS log files I
did not find anything with regards to this error. Anyplace specific I should
look?

Here is the part of my config file for email (I have purposely changed the
IP address and server name for this posting).

<Extension Name="Report Server Email"
Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,Report
ingServicesEmailDeliveryProvider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<RSEmailDPConfiguration>
<SMTPServer>123.45.6.78</SMTPServer>
<SMTPServerPort></SMTPServerPort>
<SMTPAccountName></SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing></SendUsing>
<SMTPAuthenticate></SMTPAuthenticate>
<From>somebody@bogus.com</From>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML</RenderingExtension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>True</SendEmailToUserAlias>
<DefaultHostName></DefaultHostName>
<PermittedHosts></PermittedHosts>
</RSEmailDPConfiguration>
</Configuration>
</Extension>

Bruce L-C

v-mingqc NO[at]SPAM online.microsoft.com
1/22/2005 7:14:32 AM

Hi BruceLC,

Thanks for your posting!

From your descriptions, I understood that you would like to maka a email
subscription but it fails with the error message "Failure sending mail".
Have I understood you? Correct me if I was wrong.

First of all, have you made the test after restarting the windows? Restart
the machine and then make the test again.

Secondly, have you upgraded to Reporting Services SP1? It seems the
following issue reports the same error

FIX: Subscriptions that use the e-mail delivery method for distribution may
not deliver the report successfully in SQL Server 2000 Reporting Services
http://support.microsoft.com/?id=842538

I have not configured external SMTP server, however, here is my
configuration file for the SMTP on localhost for your reference and I think
you should modify value <SendUsing> to 2 when external SMTP server is used.

<RSEmailDPConfiguration>
<SMTPServer>123.45.67.89</SMTPServer>
<SMTPServerPort>25</SMTPServerPort>
<SMTPAccountName></SMTPAccountName>
<SMTPConnectionTimeout>60</SMTPConnectionTimeout>

<SMTPServerPickupDirectory>c:\Inetpub\mailroot\Pickup</SMTPServerPickupDirec
tory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing>1</SendUsing>
<SMTPAuthenticate></SMTPAuthenticate>
<From>SQLSERVER@localhost.com</From>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML</RenderingExtension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>True</SendEmailToUserAlias>
<DefaultHostName></DefaultHostName>
<PermittedHosts></PermittedHosts>
</RSEmailDPConfiguration>

Last but not the least, I believe Error Log file might help much, you are
encouraged to send me the error log v-mingqc@microsoft.com after you have
tried restarting and upgrading SP1.

Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!

Sincerely yours,

Michael Cheng

Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---------------------------------------------------------------
Get Secure! - http://www.microsoft.com/security

This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

BruceLC
1/24/2005 2:37:08 PM

I am already on SP1 on two different servers having this problem. Both are
windows 2003. One is standard, one is enterprise. Both have the db on the
same machine (which the incident you list below has the db on a different
server). So, although the same message it is not the same problem.

I have sent you the log file.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

v-mingqc NO[at]SPAM online.microsoft.com
2/1/2005 9:44:58 AM

Hi Bruce,

I wanted to post a quick note to see if you would like additional
assistance or information regarding this particular issue. Have you
received my email? I need more detailed infomation about your error logs.

We appreciate your patience and look forward to hearing from you!

Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

v-mingqc NO[at]SPAM online.microsoft.com
2/3/2005 5:48:50 AM

Hi Bruce,

This is due to the inability of the Windows service identity (SYSTEM) to
look into the domain SA to see if the subscription owner is still
authorized to subscribe to the report. The fix is to change the Windows
service identity to a domain account.

Hope it helps and if you have any questions or concerns, don't hesitate to
let me know. We are always here to be of assistance!

Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

home · blog · groups

Questions? Comments? Contact the dn