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

Allow Users to Configure Email on Report Subscription Expand / Collapse
Author
Message
Posted Monday, June 22, 2009 3:36 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 5:29 AM
Points: 621, Visits: 1,073
Hi. A user wishes to manage their own subscriptions. The user is a member of the 'Browser Role' which has 'Manage Individual Subscriptions' selected. When the user attempts to configure the report delivery option (email) the 'To' field is greyed out so they are unable to specify the recipient.

Can anyone advise.
Many Thanks,
Phil.


-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

Tommy Cooper
Post #739230
Posted Friday, May 18, 2012 6:23 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 8:22 AM
Points: 656, Visits: 939
We have the same issue. Anyone no why the "To:" box is greyed out / protected when the user is in the BROWSER role?

BT
Post #1302437
Posted Friday, May 18, 2012 9:19 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 5:29 AM
Points: 621, Visits: 1,073
Hi. I ended up assigning Content Manager + Publisher roles to users within specific AD groups.
Phil.


-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

Tommy Cooper
Post #1302616
Posted Friday, May 18, 2012 9:27 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 8:22 AM
Points: 656, Visits: 939
thx Phil.. I wound up doing the following to resolve the issue:

Reviewed Microsoft recommendation on this issue: "Configure a Report Server for E-Mail Delivery (Reporting Services)"

http://msdn.microsoft.com/en-us/library/ms159155.aspx -- Configuration Options for Setting the To: Field in a Message

If you are using an SMTP server or forwarder that uses e-mail accounts that are different from the domain user account, the report delivery will fail when the SMTP server tries to deliver the report to that user.

To workaround this issue, you can modify configuration settings that allow users to enter a name in the To: field:
1. Open RSReportServer.config with a text editor.
2. Set SendEmailToUserAlias to False.
3. Set DefaultHostName to the Domain Name System (DNS) name or IP address of the SMTP server or forwarder.
4. Save the file.
5. Restart SSRS service


BT
Post #1302622
Posted Friday, May 18, 2012 9:31 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 5:29 AM
Points: 621, Visits: 1,073
Pleased to hear you have resolved.
Phil.


-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

Tommy Cooper
Post #1302625
Posted Friday, May 25, 2012 12:56 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, September 12, 2013 9:58 AM
Points: 39, Visits: 230
Subscriptions can be managed by "system administrators" not by "systemusers"
Post #1306785
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse