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

Report Server not recognized email aliases Expand / Collapse
Author
Message
Posted Tuesday, March 24, 2009 3:10 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, August 5, 2014 1:52 PM
Points: 143, Visits: 412
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
Post #682873
Posted Tuesday, March 24, 2009 6:25 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 12:39 AM
Points: 3,136, Visits: 11,494
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




Post #682989
Posted Wednesday, March 25, 2009 7:26 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, August 5, 2014 1:52 PM
Points: 143, Visits: 412
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.
Post #683284
Posted Wednesday, March 25, 2009 10:45 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 7:26 AM
Points: 4,390, Visits: 9,536
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
Problems are opportunites brilliantly disguised as insurmountable obstacles.

How to post questions to get better answers faster
Managing Transaction Logs
Post #683473
Posted Wednesday, March 25, 2009 11:35 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, August 5, 2014 1:52 PM
Points: 143, Visits: 412
That did the trick. Thanks
Post #683516
Posted Wednesday, March 25, 2009 11:45 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 7:26 AM
Points: 4,390, Visits: 9,536
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
Problems are opportunites brilliantly disguised as insurmountable obstacles.

How to post questions to get better answers faster
Managing Transaction Logs
Post #683524
Posted Wednesday, March 25, 2009 12:09 PM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Wednesday, August 13, 2014 2:43 PM
Points: 772, Visits: 1,185
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


SQLServerNewbie

MCITP: Database Administrator SQL Server 2005
Post #683552
Posted Wednesday, March 25, 2009 12:35 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 7:26 AM
Points: 4,390, Visits: 9,536
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
Problems are opportunites brilliantly disguised as insurmountable obstacles.

How to post questions to get better answers faster
Managing Transaction Logs
Post #683571
Posted Friday, March 23, 2012 5:40 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, September 11, 2014 9:40 AM
Points: 7, Visits: 49
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
Post #1271534
Posted Tuesday, March 5, 2013 11:59 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, May 8, 2013 12:21 PM
Points: 1, Visits: 7
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.)
Post #1426974
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse