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

Failure Sending Mail: the transport failed to connect the server Error related to the Mail Server. Ensure you have given the correct Mail server name and the server is up and running.Sivaprasad S http://sivasql.blogspot.com Please click the Mark as Answer button if a post solves your problem!

I exactly don't know how setup the mail server. I know the how to do the subscription. Can just tell me brief way to send the report E-mail Subscription including the all thing. Please, reply me ASAP.

Please talk to your Network Admin, he should be able to help you out with the stuff related to mail server.