SSRS 2012 multiple email subscriptions error: Failure sending mail: The specified string is not in the form required for an e-mail address.Mail will not be resent.

Question

SSRS 2012 multiple email subscriptions error: Failure sending mail: The specified string is not in the form required for an e-mail address.Mail will not be resent.

Cpt_Picard

SSChasing Mays

Points: 611
More actions
December 9, 2013 at 9:45 am

#281006

I've set up a new SSRS 2012 instance pointing to the local Database Engine and got an error I'm having trouble resolving. I have not changed the RSreportserver.config file and left pretty much all the settings to default. The service account SSRS runs under is a domain account that has permissions to email from a remote SMTP Server.
I've set up a subscription for a single email address in the To box and it works great.
I set up a subscription for multiple emails in the To box (semi-colon delimited), or one in the To box and one in the Cc box and I get the following error message under the "My Subscriptions" link on the SSRS site: "Failure sending mail: The specified string is not in the form required for an e-mail address.Mail will not be resent."
Please let me know if I can provide any additional information to solve this. Any help would be greatly appreciated.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323504 More actions · Answer 1

Cpt_Picard (12/9/2013)
I've set up a new SSRS 2012 instance pointing to the local Database Engine and got an error I'm having trouble resolving. I have not changed the RSreportserver.config file and left pretty much all the settings to default. The service account SSRS runs under is a domain account that has permissions to email from a remote SMTP Server.
I've set up a subscription for a single email address in the To box and it works great.
I set up a subscription for multiple emails in the To box (semi-colon delimited), or one in the To box and one in the Cc box and I get the following error message under the "My Subscriptions" link on the SSRS site: "Failure sending mail: The specified string is not in the form required for an e-mail address.Mail will not be resent."
Please let me know if I can provide any additional information to solve this. Any help would be greatly appreciated.

mail has to send items to an SMTP server, which requires name@domain.tld format.

it sounds like you might be trying to send to an exchange mail group instead of an smtp address; for example, we have an email group named "Developers", that sends to about a half dozen individuals.

to send to that group via smtp, the exchange admin had to expose and map an external email address to the group.

could that be your issue?

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Cpt_Picard SSChasing Mays Points: 611 More actions · Answer 2

Thanks for your reply!

All the email accounts are to individuals and not distro list(s).

The To box contains: username@example.com;user.name@example.com

I am also asking my exchange admin to check things out but so far we are coming up dry.

The part that gets me is that it works with one email address to an individual, but not two. Both addresses are in the same domain and contained in the Global Address List.

Cpt_Picard SSChasing Mays Points: 611 More actions · Answer 3

Also, here's the text from the RSReportServer.config file located at "C:\Program Files\Microsoft SQL Server\MSRS11.NamedInstanceName\Reporting Services\ReportServer" for the RSEmailDPConfiguration tag:

<SMTPServer>RemoteSMTPAddress</SMTPServer>

</SMTPServerPort>

</SMTPAccountName>

</SMTPConnectionTimeout>

</SMTPServerPickupDirectory>

</SMTPUseSSL>

</SMTPAuthenticate>

<From>JWSReports@zachrycorp.com</From>

<RenderingExtension>MHTML</RenderingExtension>

</EmbeddedRenderFormats>

</PrivilegedUserRenderFormats>

<RenderingExtension>HTMLOWC</RenderingExtension>

</ExcludedRenderFormats>

</DefaultHostName>

</PermittedHosts>

</RSEmailDPConfiguration>

Elliott Whitlow SSC Guru Points: 102296 More actions · Answer 4

Cpt_Picard (12/9/2013)
Thanks for your reply!
All the email accounts are to individuals and not distro list(s).
The To box contains: username@example.com;user.name@example.com
I am also asking my exchange admin to check things out but so far we are coming up dry.
The part that gets me is that it works with one email address to an individual, but not two. Both addresses are in the same domain and contained in the Global Address List.

First thought is the delimiter between addresses, I *think* it needs to be comma and not semi-colon..

CEWII

Cpt_Picard SSChasing Mays Points: 611 More actions · Answer 5

Elliott Whitlow (12/9/2013)First thought is the delimiter between addresses, I *think* it needs to be comma and not semi-colon..
CEWII

Thanks for your reply!

I tried that but got the error below 🙁

One of the extension parameters is not valid for the following reason: The e-mail name username@domain.com,user.name@domain.com is not valid. (rsInvalidExtensionParameter)

Cpt_Picard SSChasing Mays Points: 611 More actions · Answer 6

After a long afternoon we were able to track this issue down to what appears to be an exchange configuration issue. I'm not an exchange expert in the least so please forgive me here.

We have a firewall in place to prevent machines from sending out automated emails. The main exchange guy was out so his backup setup this new server for the exception. There are three servers that need the update for the emails and only one of them had it. Once that was addressed and I restored my backup RSReportServer.config everything worked as expected. Again, I made no changes to the config file prior to the issue.

Sorry the explanation is not more in-depth, but here's some information on the environment I had this setup in:

Windows Server 2008 R2 SP1 x64

SQL Server 2012 Standard SP1 x64 DE, SSRS

Domain service account for SSRS service

Thanks to you folks that were throwing ideas out there. I appreciate that!