Quick Search

Advanced Search »

Discuss (0) History

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

Node	Value
`<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.

Jasinski Technical Wiki