SMTP Server not letting Report services work
Using our local smtp server i am trying to do a report subscription to mail the report to certain mail ids. In report manager getting the status as 'Mail sent to <>' But originally no mail were sent. Our SMTP is placed remote somwhere not in our company. I do have installed smtp in local machine and have configured to receive my mails. What in additional i need to check for the SSRS to deliver the reports for EMail delivery subscription ... Please let me know...--------------------------- Radhai Krish | Golden Age is no more far | --------------------------
November 2nd, 2010 8:22am

Hi, Do you have problem with configuring SQL Server Reporting services to send the email via your Exchange SMTP server? To allow the SSRS relay off exchange server, please create a new receive connector for relay (The steps is for exchange 2007): 1. Open EMC, expand to Server Configuration-Hub Transport. In receive connectors tab, create a new receive connector. 2. In Network tab, add the IP address of the SSRS server is in the remote IP range. 3. In Authentication tab, only select the option "Externally Secured". 4. In permission groups tab, select all items. 5. Open Services.msc, restart Microsoft Exchange Transport service. If you are using Exchange 2003 or Windows Server build in SMTP server, please refer the following steps: 1. Open properties of SMTP virtual server. 2. In Access tab, click Authentication, select the Anonymous access. 3. Click Relay button, add the IP address of the SSRS server to the allow list. Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Thanks Gen Lin-MSFT
Free Windows Admin Tool Kit Click here and download it now
November 5th, 2010 4:50am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics