MS SQL Reporting Services Error "The specified string is not in the form required for an e-mail address"

Scott Craig 21 Reputation points
2021-10-12T20:54:38.597+00:00

Hello,

We have an error with reporting subscriptions. The error is "The specified string is not in the form required for an e-mail address"

  • Validated the email addresses are valid
  • Validated the SMTP service name is correct
  • Checked DNS and the name resolves and pings
  • Checked rsreportserver.config and it has the correct SMTP server address
  • The To: email address is only to 1 recipient, so there is no other email address in the To: field

I wrote a small stand alone app that can test SMTP connections and will send an email. I copied the app to the SQL server and ran it. The app successfully connects to the SMTP server and sends an email. So I know it shouldn't be a firewall or port issue. And this also validated that the SMTP server address is correct.

Running MS SQL 2016 Enterprise v13.0.4001.0
Any help will be appreciated.

Thank you,
Scott

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,771 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Joyzhao-MSFT 15,561 Reputation points
    2021-10-13T03:01:17.54+00:00

    Hi @Scott Craig
    If you are using an SMTP server or forwarder that uses e-mail accounts that are different from the domain user account, the report delivery will fail when the SMTP server tries to deliver the report to that user.
    To workaround this issue, you could modify configuration settings that allow users to enter a name in the To: field:

    • Open RSReportServer.config with a text editor.
    • Set <SendEmailToUserAlias> to False.
    • Set <DefaultHostName> to the Domain Name System (DNS) name or IP address of the SMTP server or forwarder.
    • Save the file.

    For more information,Please refer to: E-Mail Settings - Reporting Services Native mode (Configuration Manager).
    If the problem persists, please try to share your configuration information.
    Best Regards,
    Joy


    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.
    0 comments No comments