Seth Lynch (11/12/2009)
HiWe 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