Points: 55309

8/17/2016 1:02:54 PM

Configuring an SSRS Server to send email via a local SMTP server

* This article, and all our great SQL Server Reporting Services documentation, Is available on the SQL Server Reporting Services menu
SSRS Servers <= 2014 cannot be configured to send email using a password. And in this day and age, what idiot allows their email server to relay unauthenticated email?

If you have any interest in SSRS, please remember where this blog entry is, you'll want it, and it'll save you the days that I've spent on this.

This article will walk you through setting up a mail server on a Server 2012 box with SQL 2014, and then configuring the mail server to only accept connections from the SQL server. This provides the security that we need to be sure that we're not an open relay.

Here we go:
Version: All
Section: Dynamics GP,SSRS
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables