SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Personal Subscription E-mail Address


Personal Subscription E-mail Address

Author
Message
LostAccount
LostAccount
SSCarpal Tunnel
SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)

Group: General Forum Members
Points: 4421 Visits: 1424
When anyone sets up a subscription in SSRS 2005 the To: field defaults to the individual's network username. This has never been a problem as the admins are usually setting up a subscription for others and they overtype this with the correct e-mail addresses.

However, when a user in the Browser role (with permission to create personal subscriptions) accesses a report and sets up a subscription they are not able to change this field (makes sense that they can't) but the subscription also is useless without a valid e-mail address. Is there a way to default this field to their e-mail address from Active Directory?
Niraj-627298
Niraj-627298
SSC-Addicted
SSC-Addicted (495 reputation)SSC-Addicted (495 reputation)SSC-Addicted (495 reputation)SSC-Addicted (495 reputation)SSC-Addicted (495 reputation)SSC-Addicted (495 reputation)SSC-Addicted (495 reputation)SSC-Addicted (495 reputation)

Group: General Forum Members
Points: 495 Visits: 719
Hi...

Please let me know...are you asking abt the From field or To field...b'coz To field is mandatory as we need to fill it with the valid e-mail address....

Yes...by default...it takes the User's network name or User's e-mail address which he may have set while entering the SMTP address but I think its for From field...not To field...

If I am getting it wrongly..can you elaborate your issue so that we can find a solution...

Thanks,

Niraj
LostAccount
LostAccount
SSCarpal Tunnel
SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)

Group: General Forum Members
Points: 4421 Visits: 1424
The FROM: field is set in configuration. A user cannot affect that.

When setting up a subscription the user can set the TO:, CC: or BCC: fields. As I mentioned, with limited rights and while setting up a personal subscription, the TO: field is pre-populated and not enabled to be changed. In our case anyway, what is showing up in the TO: field is the user's network ID not a valid SMTP address. It allows them to save this subscription but of course it fails when executed as the TO: address is not valid.

As an admin I went in and modified the TO: address for him but then he decided to change the delivery format and then it wouldn't let him save his changes because it was expecting the user ID value in the TO: field and he did not have rights to save to a different e-mail address. As it stands now personal subscriptions are worthless unless there is a way for them to be able to modify the TO: address or have it default to their e-mail address instead of their user ID.
MaricopaJoe
MaricopaJoe
SSC-Enthusiastic
SSC-Enthusiastic (107 reputation)SSC-Enthusiastic (107 reputation)SSC-Enthusiastic (107 reputation)SSC-Enthusiastic (107 reputation)SSC-Enthusiastic (107 reputation)SSC-Enthusiastic (107 reputation)SSC-Enthusiastic (107 reputation)SSC-Enthusiastic (107 reputation)

Group: General Forum Members
Points: 107 Visits: 408
I agree, this has been troublesome, as some users do not understand the need to have a fully qualified email address in the .to field.
If this is greyed our, then you need to investigate the line in your rsconfig.config file:

<SendEmailToUserAlias>True</SendEmailToUserAlias>
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search