Groups | Blog | Home
all groups > sql server reporting services > september 2007 >

sql server reporting services : e-mail subscription quit working - can't figure out why


Greg Tompkins
9/20/2007 11:14:50 AM
Hi All,

I am using SQL Reporting Services MOM Reporting. I set up some reports and
they have been delivering flawlessley now for over a month. Now this morning
I got the error:

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

It isn't descriptive enough to know what exactly failed. I can ping and
telnet to the SMTP port of the mail server and not being blocked. Also, the
same settings are being used for alerts from MOM without any problems. Is
there a way to run a test or get a better log to know what the error is?
This error is useless.

Thanks,

--GREG--

midas
9/20/2007 12:13:02 PM
I had experienced similar behavior. We resolved this by changing the
SMTP server specified in the Email Settings within Report Services
Configuration tool from the server name to the mail server's IP
address. Hope this helps!

Midas
AddThis Social Bookmark Button