Subscription To: Field -- sql server reporting services

cphite NO[at]SPAM hotmail.com
2/24/2006 8:22:04 AM

[quoted text, click to view]

I just found this one today myself :) You don't have to make them
admins...

Look for the rsreportserver.config file on your server, and set the
value to SendEmailToUserAlias to false. To do this, look for the line:

<SendEmailToUserAlias>True</SendEmailToUserAlias>

and change it to:

<SendEmailToUserAlias>False</SendEmailToUserAlias>

However, this leads me to a follow-up question: Does anyone know if
there is there any way to make it pull an email address for the user
from Active Directory instead of using the shortname?

Darrell
2/24/2006 9:23:05 AM

Okay. I have a good one. Most all our users are in the Browsers group. The
Browsers group can manage their own subscriptions. However, everything I read
about this group says that users in the group cannot change who the report is
sent to. Fair enough. Wouldn't want a frustrated employee flooding a manager
with emails. Problem is (for us) that RS inserts the domain account (SAM) name
in the To: field (e.g. "JoeUser"). This SAM name means nothing to the email
server. So reports never reach the intended recipient.

It appears to me that I only have two options. Add the "Manage All
Subscriptions" task to the Browsers role, or, as administrator, change the
subscription recipient for the user after they have created the subscription. Am
I on the right track here, or can something else be done.

sql server reporting services : Subscription To: Field