How to configure Reporting service for SMTP server located remotly. -- sql server reporting services

sql server reporting services : How to configure Reporting service for SMTP server located remotly.

Kaisa M. Lindahl Lervik
2/23/2006 12:00:00 AM

You 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

[quoted text, click to view]

msinghindia
2/23/2006 3:54:48 AM

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

msinghindia
2/23/2006 6:17:50 AM

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

Kaisa M. Lindahl Lervik
2/23/2006 4:25:37 PM

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

[quoted text, click to view]

msinghindia
2/26/2006 1:05:26 AM

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.

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