Configure SMTP with custom port on SQL Server Reporting Services.

--

Usually setting up SMTP email configuration is a simple task where simply go to the SSRS configuration manager and give SMTP Server details, and you are done!

Image by author

However what if SMTP Server is running on a custom port other than port 25(Default), then we cannot configure it using the GUI.

Then all we need to find the rsreportserver.config file (Normally located in C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportServer) the SSRS and update SMTPServerPort tag in the config file.

Image by author

Then simply restart the reports server and you should be ready to go!

TL;DR

Custom SMTP port and other advance settings for email services on SQL Server Reporting Services can be configured using rsreportserver.config

--

--

Prasanna Wijesiriwardana
Prasanna Wijesiriwardana

Written by Prasanna Wijesiriwardana

Data Engineer | Loves Python, Data and Cloud | Linkedin - www.linkedin.com/in/prasas

No responses yet