Jasinski Technical Wiki

Navigation

Home Page
Index
All Pages

Quick Search
»
Advanced Search »

Contributor Links

Create a new Page
Administration
File Management
Login/Logout
Your Profile

Other Wiki Sections

Software

PoweredBy

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

RSS
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
\MSSQL.3
\Reporting Services
\ReportServer
\rsreportserver.config.

2. Navigate to
/Configuration
/Extensions
/Delivery
/Extension[@Name='Report Server Email']
/Configuration
/RSEmailDPConfiguration

3. Set the text of the following nodes

NodeValue
<SMTPServer>SMTP server name
<From>email address of sender
<SetEmailToUserAlias>False
<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 3.0.1.400. Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2018, Patrick Jasinski.