How to Send report to SFTP server

Hi, anmolmalviya05 

If you want to send reports to your SMTP server, you need to configure your SMTP information in the Report Server configuration manager:

I found the following documentation to help you configure SMTP.

Email settings in SSRS native mode (Report Server Configuration Manager) - SQL Server Reporting Services (SSRS) | Microsoft Learn

After that, you have to create a subscription for your reports in SSRS's web portal:

Select your destination in the subscription:

I found the following email subscription document that will walk you through setting up your subscription step by step:

Create and manage subscriptions for native mode report servers - SQL Server Reporting Services (SSRS) | Microsoft Learn

You can send the report to the corresponding SMTP mailbox by the above method.

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.