Failure sending mail: The transport failed to connect to the server

Question

Failure sending mail: The transport failed to connect to the server

portnova

SSC Veteran

Points: 260
More actions
June 28, 2004 at 8:56 am

#161571

Hi All,
Could anyone tell me how to configur my Report Server for email delivery, i did not do that during the installation. How to connect Report Server to SMTP server? I know there is RSWebApplication.config file, but what should i add/change there? Does anyone has an example for me? Thanks in advance for any help.
July 1, 2004 at 8:00 am

This was removed by the editor as SPAM

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Darrin Veit SSC Veteran Points: 240 More actions · Answer 1

There are quite a few options listed but the only ones that are auto-populated when filling out the fields during install are shown as follows on our server:

<SMTPServer>smtprelay.yourdomain.com</SMTPServer>

<From>fromaddress@yourdomain.com</From>

<RenderingExtension>MHTML</RenderingExtension>

</EmbeddedRenderFormats>

<RenderingExtension>HTMLOWC</RenderingExtension>

</ExcludedRenderFormats>

</RSEmailDPConfiguration>

Jean-Marie Rwankuba SSChasing Mays Points: 607 More actions · Answer 2

Hi there.

I'm having the same problem with publishing reports via email. Checking this issue for the last week I've been offered to install RS SP1, which I did. This did not solve the problem. In the rsReportServer.Config file I'm still struggling with the parameters of the SMTPAuthenticate. My SMTP server is at a remote location and I assume that I need to add the sendusername and senduserpassword settings but BOL does not say HOW.

Jean-Marie Rwankuba SSChasing Mays Points: 607 More actions · Answer 3

Good news!

The settings I had were correct and I did not need to setup the SMTPAuthenticate. The email subscriptions work BUT only if I remove the flag to include the report in the email. An email is sent with the link to the report. Still need to figure out WHY attaching the report kills the subscription...

The only settings I have are those of the SMTPServer and of the From to make the email subscription work.

Nelson-290515 SSC Enthusiast Points: 118 More actions · Answer 4

I had the same issue where the reports stopped being delivered. the IT group changed the exchange server name and i was not aware of the change. i had to manually change the server name in RSReportServer.config

my question is: does anyone know where we can make those changes (i'm looking for the user interface) without editing the file manually.

thanks!

Dave Klug SSCertifiable Points: 5811 More actions · Answer 5

You can change some settings (including your email settings) by going to Microsoft Sql Server 2005 -> Configuration Tools -> Reporting Services Configuration and the clicking on Email Settings.

Dave

Nine-1088148 Valued Member Points: 67 More actions · Answer 6

Thanks so much, it worked. the mail serve had been changed and I was left out of the loop. You saved me from having to pay for tech support.

Nina:-D

sivaprasad SSCertifiable Points: 6183 More actions · Answer 7

Failure Sending Mail: the transport failed to connect the server

Error related to Mail Server. Ensure the Mail server given is correct and it is up & running.

Also check if there are not any network error connecting Mail server.

Sivaprasad S - [ SIVA ][/url]http://sivasql.blogspot.com/[/url]