Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

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... Expand / Collapse
Author
Message
Posted Monday, December 09, 2013 9:45 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, December 10, 2013 9:42 AM
Points: 73, Visits: 82
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.
Post #1521191
Posted Monday, December 09, 2013 10:16 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 12:01 PM
Points: 12,744, Visits: 31,074
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

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1521210
Posted Monday, December 09, 2013 10:26 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, December 10, 2013 9:42 AM
Points: 73, Visits: 82
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.
Post #1521218
Posted Monday, December 09, 2013 10:31 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, December 10, 2013 9:42 AM
Points: 73, Visits: 82
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:

<RSEmailDPConfiguration>
<SMTPServer>RemoteSMTPAddress</SMTPServer>
<SMTPServerPort>
</SMTPServerPort>
<SMTPAccountName>
</SMTPAccountName>
<SMTPConnectionTimeout>
</SMTPConnectionTimeout>
<SMTPServerPickupDirectory>
</SMTPServerPickupDirectory>
<SMTPUseSSL>
</SMTPUseSSL>
<SendUsing>2</SendUsing>
<SMTPAuthenticate>
</SMTPAuthenticate>
<From>JWSReports@zachrycorp.com</From>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML</RenderingExtension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderFormats>
</PrivilegedUserRenderFormats>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
<RenderingExtension>RGDI</RenderingExtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>True</SendEmailToUserAlias>
<DefaultHostName>
</DefaultHostName>
<PermittedHosts>
</PermittedHosts>
</RSEmailDPConfiguration>
Post #1521222
Posted Monday, December 09, 2013 10:41 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, January 03, 2014 3:52 PM
Points: 6,066, Visits: 5,277
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
Post #1521227
Posted Monday, December 09, 2013 10:44 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, December 10, 2013 9:42 AM
Points: 73, Visits: 82
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)
Post #1521228
Posted Tuesday, December 10, 2013 9:47 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, December 10, 2013 9:42 AM
Points: 73, Visits: 82
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!
Post #1521582
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse