How to configure Reporting service for SMTP server located remotly.

Hi
I have one problem which i am not able to solve regardig the reporting
service SMTP services.
One of our client is using the SQL server 2000 along with Microsoft
Reporting Services. They need to configure SQL Reporting services for
sending reports through emails using subscription services. They don't
have any SMTP server located in their local network.
They are using external SMTP server for sending & receiving mails. How
to configure the RSReportServer.config file for the same? If we refer
documentation available in Reporting Service Books Online, it states
that we can configure using SMTPAuthenticate settings by using
"SENDUSERNAME" & "SENDPASSWORD".
ms-help://MS.RSBOL80.1033/rsadmin/htm/arp_configserver_v1_4bzl.htm
"SendUsing"
Specifies which method to use for sending messages.
To send report subscriptions through e-mail using a local POP3 server
hosted on a Windows 2003 server, you must set the value to 1.
1=sends a message using the local SMTP service pickup directory.
2=sends the message using the network SMTP service.
"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.
If We Refer the MSDN online it states SMTPAuthenticate authorization is
not
supported.
http://msdn2.microsoftcom/ms157273.aspx
SendUsing
Specifies which method to use for sending messages. Valid values
include the following:
1=Sends a message from the local SMTP service pickup directory.
2=Sends the message from the network SMTP service.
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.
Valid values include the following:
0=No authentication.
1= (not supported).
2= NTLM (NT LanMan) authentication. The security context of the Report
Server Windows service is used to connect to the network SMTP server.
Please help me in matter to solve the problem. We are unable to send
mails using reporting service by using the settings stated in the
Reporting Service Books Online. Please solve the following problems.
1. Whether it is possible to use SMTP server outside the network or
not?
2. If yes what is the method of configuring SMTP services?
3. How can we send username & password to authenticate the user?
4. Send us sample RSReportServer.config if possible for the same.
Thanking youYou might want to start with checking if the firewall is allowing traffic
out of this server.
On your server, try using telnet to check for traffic.
Open command prompt.Try to type what I write after the (type)...
(Type) Telnet your-mail-server 25
reply 220 your-mail-server Microsoft ESMTP MAIL Service, Version:
5.0.2195.6713
ready at Mon, 24 Oct 2005 15:43:27 +0200
(Type) HELO your-domain
250 your-mail-server Hello [10.61.120.21]
(Type) MAIL FROM: you@.youradress.com
250 2.1.0 you@.youradress.com... Sender OK
(Type) RCPT TO: someone.else@.youradress.com
250 2.1.5 someone.else@.youraddress.com
(Type) DATA
354 Start mail input; end with <CRLF>.<CRLF>
(Type) THis is my message!
.
250 2.6.0 your-mail-server> Queued mail for delivery
Type quit to end the telnet session.
If you can't send an e-mail by telnet, your reporting services server
probably can't either.
Kaisa M. Lindahl Lervik
"msinghindia" <msinghindia@.gmail.com> wrote in message
news:1140695688.842888.246030@.f14g2000cwb.googlegroups.com...
> Hi
> I have one problem which i am not able to solve regardig the reporting
> service SMTP services.
> One of our client is using the SQL server 2000 along with Microsoft
> Reporting Services. They need to configure SQL Reporting services for
> sending reports through emails using subscription services. They don't
> have any SMTP server located in their local network.
> They are using external SMTP server for sending & receiving mails. How
> to configure the RSReportServer.config file for the same? If we refer
> documentation available in Reporting Service Books Online, it states
> that we can configure using SMTPAuthenticate settings by using
> "SENDUSERNAME" & "SENDPASSWORD".
> ms-help://MS.RSBOL80.1033/rsadmin/htm/arp_configserver_v1_4bzl.htm
> "SendUsing"
> Specifies which method to use for sending messages.
> To send report subscriptions through e-mail using a local POP3 server
> hosted on a Windows 2003 server, you must set the value to 1.
> 1=sends a message using the local SMTP service pickup directory.
> 2=sends the message using the network SMTP service.
> "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.
>
> If We Refer the MSDN online it states SMTPAuthenticate authorization is
> not
> supported.
> http://msdn2.microsoftcom/ms157273.aspx
> SendUsing
> Specifies which method to use for sending messages. Valid values
> include the following:
> 1=Sends a message from the local SMTP service pickup directory.
> 2=Sends the message from the network SMTP service.
> 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.
> Valid values include the following:
> 0=No authentication.
> 1= (not supported).
> 2= NTLM (NT LanMan) authentication. The security context of the Report
> Server Windows service is used to connect to the network SMTP server.
> Please help me in matter to solve the problem. We are unable to send
> mails using reporting service by using the settings stated in the
> Reporting Service Books Online. Please solve the following problems.
> 1. Whether it is possible to use SMTP server outside the network or
> not?
> 2. If yes what is the method of configuring SMTP services?
> 3. How can we send username & password to authenticate the user?
> 4. Send us sample RSReportServer.config if possible for the same.
> Thanking you
>|||Thnks for early reply.
I followed your steps. When type RCPT TO: mail@.domain.com gives the
following error.
"Relaying Denied...proper authentication required."
Please ! It will be great if you could let me know the reasons behind
the error.
Thanks in Advance
Manjeet|||Relaying is often used for spamming - someone sends out loads of email from
a mail server they don't own. So a lot of email providers will configure
their server to not allow relaying.
You might want to check with the owners of your smtp server what settings
you should use, and how to authenticate proberly remotely.
Kaisa M. Lindahl Lervik
"msinghindia" <msinghindia@.gmail.com> wrote in message
news:1140704270.023492.174060@.j33g2000cwa.googlegroups.com...
> Thnks for early reply.
> I followed your steps. When type RCPT TO: mail@.domain.com gives the
> following error.
> "Relaying Denied...proper authentication required."
> Please ! It will be great if you could let me know the reasons behind
> the error.
> Thanks in Advance
> Manjeet
>|||I have checked with the owners of the server. They can not enable
relaying since it will create problem of SPAM mails as server is live
on internet. So i can not send mails without authorization. So i need
to send username & password to SMTP server when Reporting Server send
mails? But how to do that '
If i refer documents of reporting service for rsconfig file it says
using "sendusername" and "senduserpassword". But it is not working.
When i refer MSDN online it says these is not Supported.
Please any body know how to authorize SQL Reporting Service for sending
mails'
Thanks in advance.