Jasinski Technical Wiki


Home Page
All Pages

Quick Search
Advanced Search »

Contributor Links

Create a new Page
File Management
Your Profile

Other Wiki Sections



Setting Up A Report for Email Delivery - SQL Server Reporting Services

Modified on Fri, May 01, 2009, 10:47 AM by Administrator Categorized as SSRS (SQL Server Reporting Services)
1. Edit the file
C:\Program Files
\Microsoft SQL Server
\Reporting Services

2. Navigate to
/Extension[@Name='Report Server Email']

3. Set the text of the following nodes

<SMTPServer>SMTP server name
<From>email address of sender
<PermittedHosts>Add child node named <HostName> with the text of the additional domain

4. Configure the report's data sources' credentials

  • Within SQL Server Management Studio, open the Object Explorer and click Connect > Reporting Services to connect to Reporting Services server
  • Navigate to report-server > Home > Report Design > report of interest > Data Sources
  • Expand the Data Source folder,
  • Right click on each data source and select Properties
  • In the Report Data Source Properties, select Credentials stored securely on the report server to ensure that every user can run the report.

ScrewTurn Wiki version Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2023, Patrick Jasinski.