Rsreportserver.config Smtp password settings

Hi,
I wanted to know if there was any way of setting the SMTPAuthenticate in the RSReportServer.config file, so i could connect to a remote SMTP with username and password ?

I am using window 2003 system where smtp is not installed and i don't want to installed it.

If there is another way to change only in Rsreportserver.config file except pick up directory.

thanks in advance

Ashok kumar yadav

[464 byte] By [sunarc] at [2007-12-22]
# 1
See books online under SMTP settings.

Configuration Options for Remote SMTP Service

The connection between the report server and an SMTP server or

forwarder is determined by the following configuration settings:

  • SendUsing specifies a method for sending messages. You can choose

    between a network SMTP service or a local SMTP service pickup directory. To use

    a remote SMTP service, this value must be set to 2 in the RSReportServer.config

    file.

  • SMTPServer specifies the remote SMTP server or forwarder. This value

    is a required value if you are using a remote SMTP server or forwarder.

  • From sets the value that appears in the From: line of an

    e-mail message. This value is a required value if you are using a remote SMTP

    server or forwarder.

Other values that are used for remote SMTP service include the

following (note that you do not need to specify unless you want to override the

default values).

  • SMTPServerPort is configured for port 25.

  • SMTPAuthenticate specifies how the report server connects to the

    remote SMTP server. The default value is 0 (or no authentication). In this case,

    the connection is made through Anonymous access. Depending on your domain

    configuration, the report server and the SMTP server may need to be members of

    the same domain.

    To send e-mail to restricted distribution lists (for

    example, distribution lists that accept incoming messages only from

    authenticated accounts), set SMTPAuthenticate to 2.

Example Report Server E-Mail Configuration

The following example illustrates the settings in the

RSreportserver.config file for a remote SMTP server. To read about the setting

descriptions and valid values, see RSReportServer Configuration

File or the CDO product documentation.


Copy Code
<RSEmailDPConfiguration>
<SMTPServer>mySMTPServer.Adventure-Works.com</SMTPServer>
<SMTPServerPort></SMTPServerPort>
<SMTPAccountName></SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing>2</SendUsing>
<SMTPAuthenticate></SMTPAuthenticate>
<From>my-rs-email-account@Adventure-Works.com</From>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML</RenderingExtension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>True</SendEmailToUserAlias>
<DefaultHostName></DefaultHostName>
<PermittedHosts>
<HostName>Adventure-Works.com</HostName>
<HostName>hotmail.com</HostName>
</PermittedHosts>
</RSEmailDPConfiguration>

Andrew-T4G at 2007-8-30 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...
# 2

Hello dear

My smtp required authetication so tell me where i will specify user name password for smtp in rsreportser.config file.

I tried using sendusername and senduerpassword but its still give an error.

SO pls tell me where i will specify smtp username and password in rsreportserver.config file.

my code is

<SMTPAuthenticate>1</SMTPAuthenticate>

<sendusername>ashok@sbcglobal.net</sendusername>
<senduserpassword>ashok</senduserpassword>

Thanks

sunarc at 2007-8-30 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...
# 3
should be sendpassword perhaps.
Andrew-T4G at 2007-8-30 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...
# 4

Hello dear

sendpassword is not working.

Pls

sunarc at 2007-8-30 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...
# 5

Hi,

Have you ever get answer for this question? I have the same issue connect to remote SMTP with authentication...Thanks

CynthiaCC at 2007-8-30 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...
# 6

Could be case sensitivity issue? What is the error?

here is more info on configuring:

http://msdn2.microsoft.com/en-us/library/ms157273.aspx

Andrew-T4G at 2007-8-30 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...
# 7

I too am facing the same problem. I could not see a reference to an SMTP password in any of the documentation. Does reporting service support it?

The above documentation does not have any reference to an SMTP password. Has anyone done it?

thankx in advance

Jacob

JacobSebastian at 2007-8-30 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...
# 8

No way..

couple of weeks back I was trying to make this work ..but was not successful. I think in reporting server there is only one way to send email subscription, which i had used.

Install SMTP virtual server on IIS, enable relaying....its not installled by default ....and then give ip on this IIS server machine. I think microsoft exchange server or any other server never works with RS.

see this for mopre info http://www.developmentnow.com/g/115_2005_7_0_0_560723/Email-subscriptions.htm

if i am wrong, please correct me ..

thanks

bluemoon2181 at 2007-8-30 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...

SQL Server

Site Classified