E-mail delivery configuration

Warren Smith

unread,

Jul 18, 2004, 7:36:01 PM7/18/04

to

I have looked high and low - everywhere - but can't seem
to find the answer.

Books on-line talks about the SMTPAuthenticate field in
the RSReportServer.config file and indicates that the
fields sendusername and senduserpassword need to be set
if authentication to the smtp server is required (in my
case it is).

Everytime I set the config file with the options that
seem to be correct from Books on-line, the email delivery
either fails or the e-mail delivery option on the
subscription is not available - usually meaning problems
with reportServer reading the config file.

Has anyone set up SMTP authentication with report server.

Below are pertinent data related to this problem.

notes from Books on-line ----
SMTPAuthenticate Specifies an integer value that
indicates the kind of authentication to use when sending
messages to an SMTP service over a TCP/IP connection.
0=no authentication.
1=basic authentication. Credentials are passed in clear
text using either sendusername and senduserpassword, or
postusername and postuserpassword fields.

2= NTML (NT LanMan) authentication. The security context
of the current process is used to authenticate the
service.

It appears the sendusername and senduserpassword are from
CDO objects but when you look in the CDO Docs on MSDN it
identifies sendusername and sendpassword fields.

I have tried to set the following in the config file...
<SendUserName>wc.s...@sbcglobal.net</SendUserName>
<SendPassword>7776787</SendPassword> (bogus password here)
and although ReportServer does not seem to error on the
config file the e-mail option on the subscription is not
available. It only has the fileshare option.

I am logged into Report Manager as admin.

Here is the snippet from the config file....

<Extensions>
<Delivery>
<Extension Name="Report Server
FileShare"
Type="Microsoft.ReportingServices.FileShareDeliveryProvide
r.FileShareProvider,ReportingServicesFileShareDeliveryProv
ider">
<MaxRetries>3</MaxRetries>

<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>

<FileShareConfiguration>

<ExcludedRenderFormats>

<RenderingExtension>HTMLOWC</RenderingExtension>

<RenderingExtension>NULL</RenderingExtension>

</ExcludedRenderFormats>

</FileShareConfiguration>
</Configuration>
</Extension>
<Extension Name="Report Server
Email"
Type="Microsoft.ReportingServices.EmailDeliveryProvider.Em
ailProvider,ReportingServicesEmailDeliveryProvider">
<MaxRetries>3</MaxRetries>

<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>

<RSEmailDPConfiguration>

<SMTPServer>smtp.sbcglobal.yahoo.com</SMTPServer>

<SMTPServerPort>25</SMTPServerPort>

<SMTPAccountName>WarrenSmith-sbc</SMTPAccountName>

<SMTPConnectionTimeout></SMTPConnectionTimeout>

<SMTPServerPickupDirectory></SMTPServerPickupDirec
tory>

<SMTPUseSSL></SMTPUseSSL>

<SendUsing>2</SendUsing>

<SMTPAuthenticate>1</SMTPAuthenticate>

<From>wc.s...@sbcglobal.net</From>

<EmbeddedRenderFormats>

<RenderingExtension>MHTML</RenderingExtension>

</EmbeddedRenderFormats>

<PrivilegedUserRenderFormats></PrivilegedUserRende
rFormats>

<ExcludedRenderFormats>

<RenderingExtension>HTMLOWC</RenderingExtension>

<RenderingExtension>NULL</RenderingExtension>

</ExcludedRenderFormats>

<SendEmailToUserAlias>True</SendEmailToUserAlias>

<DefaultHostName></DefaultHostName>

<PermittedHosts></PermittedHosts>

</RSEmailDPConfiguration>
</Configuration>
</Extension>
<Extension Name="NULL"
Type="Microsoft.ReportingServices.NullDeliveryProvider.Nul
lProvider,ReportingServicesNullDeliveryProvider"/>

Does anyone know where you set the SendUserName and
SendPassword fields?

Thanks,

Warren

anon...@discussions.microsoft.com

unread,

Jul 18, 2004, 10:00:51 PM7/18/04

to

As an update to the problem. If I put a 1 in the
SMTPAuthenticate field the config file errors off. I can
leave it blank and then my smtp server complains that I
am not authenticating. I can put a 2 in the field and
then report services does not deliver the email because I
am not using winnt authentication.

I have also tried to put in the SendUserName and
SendPassword (spelled this way and all lowercase, as in
the DOCS) as attributes...
<SMTPAuthenticate SendUserName="wc.s...@sbcglobal.net"
SendPassword="3333333"></SMTPAuthenticate>

That does not error the config file unless, again you put
a 1 for the value of the element. Again a blank for the
SMTPAuthenticate element causes report services to fail
with a non-authentication (503) from the smtp server...

Here is the error I get for the subscription...

Failure sending mail: The server rejected the sender
address. The server response was: 530 authentication
required - for help go to
http://help.yahoo.com/help/us/sbc/dsl/mail/pop/pop-
11.html

Here is the delivery extensions area of the
RSReportServer.config file....

<Extension Name="Report Server
Email"
Type="Microsoft.ReportingServices.EmailDeliveryProvider.Em
ailProvider,ReportingServicesEmailDeliveryProvider">
<MaxRetries>3</MaxRetries>

<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>

<RSEmailDPConfiguration>

<SMTPServer>smtp.sbcglobal.yahoo.com</SMTPServer>

<SMTPServerPort>25</SMTPServerPort>

<SMTPAccountName>WarrenSmith</SMTPAccountName>

<From>wc.s...@sbcglobal.net</From>

<EmbeddedRenderFormats>

<RenderingExtension>MHTML</RenderingExtension>

</EmbeddedRenderFormats>

<PrivilegedUserRenderFormats></PrivilegedUserRende
rFormats>

<ExcludedRenderFormats>

<RenderingExtension>HTMLOWC</RenderingExtension>

<RenderingExtension>NULL</RenderingExtension>

</ExcludedRenderFormats>

<SendEmailToUserAlias>True</SendEmailToUserAlias>

<DefaultHostName>sbcglobal.net</DefaultHostName>

>.
>

Brian Welcker [MSFT]

unread,

Jul 19, 2004, 12:02:58 AM7/19/04

to

Unfortunately, SendUserName and SendPassword are not supported in the e-mail
delivery extension. The only value that works other than 0 is 2 (which uses
the service account credentials).

--
Brian Welcker
Group Program Manager
SQL Server Reporting Services

This posting is provided "AS IS" with no warranties, and confers no rights.

<anon...@discussions.microsoft.com> wrote in message
news:2fb0d01c46d34$380d4fe0$a301...@phx.gbl...

Tim

unread,

Jul 20, 2004, 5:32:03 PM7/20/04

to

I have found that I had to exempt my RS machine's ip from SMTP Auth to get this to go.