Select the product you need help with

SQL Server 2005 Reporting Services e-mail subscriptions do not work in Windows Vista and in Windows Server 2008 if you use aliases as e-mail addresses

Article ID: 945601 - View products that this article applies to.

SYMPTOMS

Note This article also applies to Microsoft SQL Server 2008 Reporting Services Community Technology Preview (CTP).

In Microsoft SQL Server 2005 Reporting Services, e-mail subscriptions do not work after you upgrade the report server or the remote SMTP server to Windows Vista or to Windows Server 2008. This problem occurs when Reporting Services is running on any platform. This issue occurs in the following scenarios.

Scenario 1

You specify an alias instead of a full e-mail address for the sender of the e-mail subscriptions. When the report server tries to deliver a report as a part of the e-mail subscriptions, you receive the following error message:

At least one of the From or Sender fields is required, and neither was found. Mail will not be resent.

Scenario 2

After you upgrade the computer that has Reporting Services installed to Windows Vista or to Windows Server 2008, you receive the following error message when the report server delivers a report to the e-mail subscriptions:

At least one recipient is required, but none were found. Mail will not be resent.

This problem occurs if the following conditions are true:

The sender e-mail address is a full e-mail address.
The DefaultHostName tag of the configuration file on the report server is not set.
In the Subscription page of Report Manager, you specify aliases instead of full e-mail addresses for the To field.

If at least one e-mail address in the To field is a full e-mail address, the subscription does not fail. However, the report is delivered only to the addresses that are full e-mail addresses and that are specified in the following recipient fields:

To
Cc
Bcc
Reply-To

Scenario 3

After you upgrade the remote SMTP server to Windows Vista or to Windows Server 2008, you receive the following error message when the report server delivers a report to the e-mail subscriptions:

The e-mail address of one or more recipients is not valid.

This problem occurs if the following conditions are true:

The sender e-mail address is a full e-mail address.
The DefaultHostName tag of the configuration file on the report server is not set.
In the Subscription page of Report Manager, you specify aliases instead of full e-mail addresses for the To field.

To
Cc
Bcc
Reply-To

Back to the top | Give Feedback

CAUSE

This issue occurs because Windows Server 2003 contains a feature that resolves aliases to their full e-mail addresses. SQL Server 2005 Reporting Services depends on this feature to allow for using e-mail aliases instead of full e-mail addresses. However, to help filter out false e-mail addresses, Windows Vista and Windows Server 2008 do not contain this feature.

Back to the top | Give Feedback

RESOLUTION

To resolve this issue, you must first make sure that a full e-mail address is specified as the sender e-mail address for the reporting server. You can do this by using one of the following methods:

In the Email Settings page of the Reporting Services Configuration tool, specify a full e-mail address instead of an alias for the Sender Address setting.
In the Rsreportserver.config file, specify a full e-mail address instead of an alias for the From tag that is located under the RSEmailDPConfiguration tag. By default, the configuration file is located in the following folder:
C:\Program Files\Microsoft SQL Server\MSSQL.x\Reporting Services\ReportServer

Then, use one of the following methods to resolve this issue.

Method 1

Set the DefaultHostName setting for the configuration file of the report server to a domain name. To do this, follow these steps:

Open the Rsreportserver.config configuration file.
Modify the DefaultHostName setting as follows:
<DefaultHostName>DomainName</DefaultHostName>
Note DomainName is a placeholder for the domain name.

Method 2

In the Subscription page of Report Manager, make sure that all the e-mail addresses in the following fields are full e-mail addresses:

To
Cc
Bcc
Reply-To

Back to the top | Give Feedback

STATUS

This behavior is by design.

Back to the top | Give Feedback

MORE INFORMATION

Steps to reproduce the problem

On a Windows Vista-based computer or a on Windows Server 2008-based computer, install SQL Server 2005 Reporting Services.
Create a report.
Create an e-mail delivery subscription for the report by specifying an e-mail alias in the To field of the subscription.
Try to deliver the report to the e-mail subscription.

Back to the top | Give Feedback