Friday, March 23, 2012

failed to connect to the server

When I have a subscription built for a report it runs at the time expected, but the report send via e-mail fails. I can run the report from a client workstation just fine. I can also run it from the admin tool fine too, it just will not run as part of a subscription. The full context of the error message is as follows:

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

This is not my first Reporting services report, but I am trying to replace all Crystal reports with Reporting services reports and this functionality is greatly needed.

Thanks! - Eric-

The error is telling you the RS server cannot connect to the Mail server. Make sure that the unattended execution account is setup and is a user that has access to the mail server.

Here is a link to help you.

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

No comments:

Post a Comment