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

Subscription email rights Expand / Collapse
Author
Message
Posted Thursday, November 12, 2009 8:08 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, July 22, 2011 4:13 AM
Points: 1,149, Visits: 603
Hi
We have SSRS set up with Windows authentication - but out email uses Lotus Notes.

When you hit subscriptions in SSRS you can choose to get an email subscription and this is pre-populated with your login name. If we had Exchange this would be fine and it would resolve the login name to an email address. We don't have exchange and a standard REport Browser user does not have permission to change the email.

Do you know of a way I can either change the default email address or give them permission to change it (without increasing their other permissions.)

Seth
Post #817864
Posted Wednesday, November 18, 2009 7:50 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: Yesterday @ 12:14 PM
Points: 3,433, Visits: 14,423
Seth Lynch (11/12/2009)
Hi
We have SSRS set up with Windows authentication - but out email uses Lotus Notes.

When you hit subscriptions in SSRS you can choose to get an email subscription and this is pre-populated with your login name. If we had Exchange this would be fine and it would resolve the login name to an email address. We don't have exchange and a standard REport Browser user does not have permission to change the email.

Do you know of a way I can either change the default email address or give them permission to change it (without increasing their other permissions.)

Seth


You need to look for the rsreportserver.config file in your Report Server folder in Microsoft SQL Server folder in programs and add your Lotus Notes SMTP definitions so your subscriptions can be sent to Lotus Notes. You also should know Windows authentication is the default and you could create a subscription account used to manage the subscription so it is not user permission dependent.

http://technet.microsoft.com/en-us/library/ms159155(SQL.90).aspx





Kind regards,
Gift Peddie
Post #821328
Posted Thursday, November 19, 2009 2:27 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, July 22, 2011 4:13 AM
Points: 1,149, Visits: 603
Thanks Gift Peddie
The problem isn't with subscriptions or sending emails as such.
For example - I have Content Manager Rights and I can subscribe ok.

This is what happens:
Click on subscriptions for a report and when you choose email the To field is pre-populated with your windows login. So say in my case my login is Lynch.
My email address is not Lynch though it is sethlynch@...
So I change it to my email address and all is fine.
If you have lesser permissions you can not change the To field an have to accept the windows login.

If we were using Exchange it could take the windows login and resolve it to your email address. As Lotus Notes isn't integrated in that way it takes the windows login and emails off to it.

So I would like to know if there is a way to change the default pre-populated To field and if not what are the minimum rights you have to grant in order to let someone do it manually.

Thanks

Seth Lynch

Post #821411
Posted Thursday, November 19, 2009 2:48 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, July 22, 2011 4:13 AM
Points: 1,149, Visits: 603
OK Peddie you got me searching for more config info.

After reading to the bottom of the page in the link you provided I saw that the email To filed is configurable - however it didn't take any notice when I added a default To field.
But then I saw SendEmailToUserAlias and this was set to True. This means if you subscribe it automatically adds your login name. If you change it to false it leaves the To field blank and allow the user to change it.

Thanks for prodding me in the right direction - I had given up on this one.

Here is link to the Configuring a Report Server for E-Mail Delivery page
http://msdn.microsoft.com/en-us/library/aa972234(SQL.80).aspx

seth
Post #821425
Posted Thursday, November 19, 2009 6:36 AM
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: Yesterday @ 12:14 PM
Points: 3,433, Visits: 14,423
If we were using Exchange it could take the windows login and resolve it to your email address. As Lotus Notes isn't integrated in that way it takes the windows login and emails off to it.


If you go back to the folder with the config file you will see the CDO Interop dll that is enabling automatic Exchange mail transport. There are many thing Microsoft left out in the documentation but I am glad you have found the place to fix your issue.



Kind regards,
Gift Peddie
Post #821549
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse