How do I add multiple SMTP Servers for use by SQL-RD schedules?

You can set up a number of SMTP servers and select from the list of existing servers when creating schedules. You can also set some as "backup" servers to be used when your "primary" SMTP server is unavailable.

System - SMTP Servers

  • Go to System.
SSRS. SQL-RD Home Menu.
  • Select SMTP Servers.
SSRS. SQL-RD System Menu.

You can set up a number of SMTP servers and select from the list of existing servers when creating schedules. This allows you to use a different SMTP server for each schedule should you wish. This is useful if you want the "From" name and email address to be different for different recipients.

Example: Reports and Alerts sent to customers come from the Customer Services Email Account; Alerts And Reports Relating to IT come from the IT Department's Account
SSRS. SMTP Servers in SQL-RD.

A "check" indicates that this server has been selected as a backup server. If the selected server fails, SQL-RD will attempt to send the email through the backup server instead. If there is no backup server selected, SQL-RD will continue to re-try the email (See "Retry Failed Mails") using just the server which has been selected for that schedule.

Add Server

  • Click Add.
SSRS. SMTP Servers in SQL-RD.

SSRS. SMTP Servers Configuration in SQL-RD.

As stated above, you can set this account to be a backup email server.

  • Click Test to confirm that the settings are correct.
SSRS. Test Email pop-up in SQL-RD.
  • Click OK to continue.

Sending Through Another SMTP Account or Customize Sender Details

  • In any schedule in Email Destination, you can customize the sender’s details. Rather than the email appearing to come from a SQL-RD user, it can appear to come from any individual you desire.
  • Mail Server to use an added SMTP account simply select it from the drop down box.
SSRS. Sending EMail through SMTP Account in Destination section in SQL-RD.