March 24, 2009 at 3:10 pm
I have setup the report services and most of it seems to be working fine. When I create a subscription, the email is populated with the username, aadams for example. The problem is that when the subscription is executed it fails because of an invalid email address. If I add the rest of the mail, aadams@company.com, then it works just fine. Why isn't RS recognizing email aliases and where would I look to resolve this?
Thanks
March 24, 2009 at 6:25 pm
You cannot use an Exchange server email alias.
Reporting services uses only SMTP format email addresses, so it must be in the form name@company.com
March 25, 2009 at 7:26 am
Sorry, I'm not always good at putting my questions down in words.
From msdn.com
"If you are distributing reports within an intranet and you are using an SMTP gateway to a Microsoft Exchange server, type the e-mail alias (as if you were sending e-mail to a coworker)."
The RS automatically populates the email address field with the username of the individual logged on. It is just not working on my current setup and I do not know where to look to resolve this. It has worked for me in the past at other companies I have worked at.
March 25, 2009 at 10:45 am
Find and edit the file rsreportserver.config. Locate the section for the Report Server Email extension. Modify the default host name and permitted host name sections and add your domain information.
Example:
<DefaultHostName>domain.company.com</DefaultHostName>
<PermittedHosts>
<HostName>domain.company.com</HostName>
</PermittedHosts>
Restart Reporting services to pick up the changes.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
March 25, 2009 at 11:35 am
That did the trick. Thanks
March 25, 2009 at 11:45 am
You are welcome - glad it worked. I just wish MS would expose those settings in the configuration instead of having to find it in the config file. There are other settings available - but I have not reviewed all of them.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
March 25, 2009 at 12:09 pm
Jeffrey Williams (3/25/2009)
Find and edit the file rsreportserver.config. Locate the section for the Report Server Email extension. Modify the default host name and permitted host name sections and add your domain information.Example:
<DefaultHostName>domain.company.com</DefaultHostName>
<PermittedHosts>
<HostName>domain.company.com</HostName>
</PermittedHosts>
Restart Reporting services to pick up the changes.
did not know this trick, thanks for sharing
will keep this in mind
but for my sake, I always explicitly state the full email address anyway
March 25, 2009 at 12:35 pm
Jerry - yes, you can specify the full address yourself because you are an administrator and have that ability. However, a normal user would not have that ability and cannot modify the email to address field - which defaults to only their username.
If you want to give your users the ability to setup and create subscriptions - then you have to specify the default domain. Or (I haven't tried this myself), you can disable the property right above that 'SendEmailToUserAlias'. Not sure if that will work - but, something you can test.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
March 23, 2012 at 5:40 am
Hi (this is my first post)
Like the person who posted this originally, my subscriptions are failing to send an email when just the email alias is used.
Unlike the original post, my organisation's email alias' are not in the same format: aadams to aadams@company.com
In actual fact it goes: aadams to andy.adams@company.com (and the like)
I presume that editing the RSConfig file would be futile in my case.
FYI I'm using SQL Server 2005.
kind regards
Paul
March 5, 2013 at 11:59 am
To give the regular users the ability to specify the email address, set the send email to alias value to false:
<SendEmailToUserAlias>False</SendEmailToUserAlias>
The downside is that the user must specify the full email address and they can now email the reports to ANY email address - even those outside your organization. (That may or may not be an issue for you.)
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply