Subscription email rights

Question

Subscription email rights

Seth Lynch

SSCrazy

Points: 2975
More actions
November 12, 2009 at 8:08 am

#213656

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

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Gift Peddie SSC Guru Points: 73570 More actions · Answer 1

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

Seth Lynch SSCrazy Points: 2975 More actions · Answer 2

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

Seth Lynch SSCrazy Points: 2975 More actions · Answer 3

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

Gift Peddie SSC Guru Points: 73570 More actions · Answer 4

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