Showing posts with label email. Show all posts
Showing posts with label email. Show all posts

Friday, March 23, 2012

Reporting Services 200 & Subscriptions

I currently have about 500 reports with subscriptions going out to around
1500 email address's. Is there any way of managing these subscriptions so
that I don't have to go to every individual report to add or remove an email
address?Use distribution lists, that way you add and delete the users from a DL and
you have one place to go to do it.
"Brian Smith" wrote:
> I currently have about 500 reports with subscriptions going out to around
> 1500 email address's. Is there any way of managing these subscriptions so
> that I don't have to go to every individual report to add or remove an email
> address?sql

Wednesday, March 21, 2012

reporting services - subscription

Creating a subscription in Reporting Services/SQL Server 2K/ for the automated delivery of an email notification that report is updated.

In the subscription, there is an option:

Delivered by: Report Server E-Mail

that is in the "Report Delivery Options" section.

When this option is selected and the email generated, it comes from the email address of my predecessor former.person@.emailaddress.com, I need to change the address to my own but can't find where to change it. Can anyone point this out?i think its in the config file, i don't have my book with me at the moment

the config files are located on the server @. C:\program files\microsoft sql server\mssql\reporting services... there is 2 directories in there, one for each site (report server / report manager), check the config files and see where one of them specifies the smtp settings, you should be able to change the email addy in there and save it

since its a config file you prolly dont have to stop/start anything