question

ScottCraig-7090 avatar image
0 Votes"
ScottCraig-7090 asked Joyzhao-MSFT commented

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

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
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @ScottCraig-7090 ,
Has your issue been resolved?
If you have any questions, please feel free to let me know.
Best Regards,
Joy

0 Votes 0 ·

1 Answer

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered Joyzhao-MSFT edited

Hi @ScottCraig-7090
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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.