Unable to send scheduled email using the SSRS - Report Server error

Kadher Meera Sahib 0 Reputation points
2024-11-05T14:47:46.8366667+00:00

Had setup the email configuration for a report to auto schedule email due to some error unable to move forward, have tried with everything - are we missing something here?

Does this Guide is enough from the Stackoverflow forum in anyway? or else any other alternative guide will be provided?

https://stackoverflow.com/questions/278297/how-to-automate-report-delivery-in-ssrs

1

Error is showing in the Server Manager

3

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,938 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Michael Taylor 54,811 Reputation points
    2024-11-05T15:19:53.1966667+00:00

    You need to look at the SQL and SSRS error logs to see the actual error message. This is insufficient information for us to help you.

    Just off the top of my head I'm going to guess your email server is rejecting the call because SSRS is sending the email using a From address that isn't valid for your email server. Relaying is generally not turned on in mail servers for security reasons so the email address that the email is being sent from needs to be a valid email address on your mail server. But that is just guessing without knowing your configuration.

    0 comments
  2. ZoeHui-MSFT 37,446 Reputation points
    2024-11-06T02:09:50.7566667+00:00

    Hi @Kadher Meera Sahib,

    Please check the SSRS error log so that we could get more details about the issue.

    In addition, if you want to use email subscription, you may need to set the Email server configuration correctly.

    Email settings in Reporting Services native mode (Report Server Configuration Manager)

    You may also follow this blog to see if you have missed any steps.

    Reporting Services Subscriptions in SQL Server 2019

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.