SMTP Server in SSRS/PBIRS – Subscribe to Email Problem/Issue

SMTP Server in SSRS/PBIRS: In this article we will see, how can we create local SMTP Server (Local Pickup Directory Test). This will give you idea on how to configure and check the behavior of SSRS/PBIRS with SMTP.

For more details: https://learn.microsoft.com/en-us/exchange/configure-the-pickup-directory-and-the-replay-directory-exchange-2013-help

Follow the below steps:

Step 1: Go to SSRS/PBIRS instance and click on Email Settings. In the right side you can see that currently all the setting are by default blank, when we install SSRS/PBIRS newly this will be the interface.

image 108
Note: Here, if you have already configured the SMTP and it is not working then you can follow the below mentioned steps to check problem is from SSRS/PBIRS or not.

Step 2: Firstly, we will go to the Installation Folder of the SSRS/PBIRS and do some minor changes in the “rsreportserver” config files. Note: Please take the Backup of the config files, before making any changes.

image 118

Step 3: Open the “rsreportserver.config” file with notepad and search or scroll down until you find SMTP tags. Make changes in the SMTP tags.

image 109
Note: In <SendUsing> change the value from 2 to “1” and in the <SMTPServerPickupDirectory> tag put you local folder path name. You can see below for more insights.

Step 4: As you can see in this below image how I have given the required values to use Pickup directory test. Once done all the changes, please save the file and go back to Configuration Manger, Stop and Re-start the services.

image 110
Note: C:\TEMP\ is my local pc folder path where I will receive the email.

Step 5: Click on the instance name in Configuration Manger, Stop and Re-start the services as you can see below.

image 115

Step 6: Now go to Email Settings tab and give any email which you like. Don’t use the SMTP Server mail id if you’re troubleshooting the SSRS/PBIRS. Also, if you see in Current SMTP Delivery Method it is automatically selected “Send to local pickup directory.

image 116

Step 7: Once Done, just browse the web portal URL and create a new subscription and run that subscription. Give the parameters value and all the required details mentioned below and click on “Create Subscription.”

image 117

Step 8: Select the report and click on “Run Now” and refresh the page after 3-5 second to check the status.

image 111

Step 9: As you can see in the below image the Subscription Runed Successfully without any error. Now we can conclude that the issue is not with SSRS/PBIRS.

image 114

Step 10: Now will go to the folder path which we have mentioned in the Step 4. Here you can see that the email is available in .eml format. Now, open this with mail app, outlook etc.

image 112

Step 11: As you can see that the reports is running successfully in the outlook app.

image 113

SMTP Server in SSRS/PBIRS

SSRS & PBIRS both are On-prem Reporting Services, where everything will function logically. But you can also access and create subscriptions for this using SMTP and Https certificate bindings. In this article we have seen how to check the SSRS/PBIRS functionality in “Email Subscription.” If you have any concern, please comment it down.

SQL Bi Links:

  1. SQL Server 2022 Download, Install, Connect Using SSMS Tool (kingfishertechtips.in)
  2. Creating Tabular Project & Deploy Model To Analysis Service (kingfishertechtips.in)
  3. Deploy Tabular Project To Azure Analysis Service – SSDT Tool (kingfishertechtips.in)
  4. SSRS/PBIRS – Install And Configure The Report Server On-Prem (kingfishertechtips.in)
  5. Could Not Load Folder Contents In Portal URLs – SSRSPBIRS (kingfishertechtips.in)
  6. SSRS/PBIRS – Install And Configure The Report Server On-Prem (kingfishertechtips.in)
  7. SQL Server 2022 Download, Install, Connect Using SSMS Tool (kingfishertechtips.in)
  8. Capture Fiddler Trace for Debugging the Network Traffic (kingfishertechtips.in)
  9. On-Premises Gateway: Configure/Map SQL DB To Power Bi (kingfishertechtips.in)
  10. Fixed Column/Row Header Make Visible In Any Report (kingfishertechtips.in)
  11. Self-Signed Certificate: Configure SSRS/PBIRS With SSL (kingfishertechtips.in)
  12. Create Local User Account/Local Admin User In Windows 10/11 (kingfishertechtips.in)
  13. Login With AAD/Domain/Microsoft Account To Azure VM’s/RDP (kingfishertechtips.in)
Vickey Rajpoot
Vickey Rajpoot

Hello there! I'm dedicated Microsoft Data & AI Engineer at LTIMindtree, where I thrive technology into actionable insights. Dive into my world by visiting my YouTube channel & Webiste, "Kingfisher Tech Tips".

Articles: 71

Leave a Reply

Your email address will not be published. Required fields are marked *