SQL Server 2005报表服务订阅电子邮件不工作在Windows Vista和Windows Server 2008中，如果您使用e-mail地址的别名_the mail server could not deliver the message to y-CSDN博客

注意：这篇文章也适用于微软SQL Server 2008 Reporting Services的社区技术预览（CTP）。

在Microsoft SQL Server 2005报表服务，电子邮件订阅不起作用之后您升级到Windows Vista或Windows Server 2008的报表服务器或远程SMTP服务器。这个问题发生的Reporting Services时，在任何平台上运行。在下列情况下会发生此问题。

回到顶端

方案1

您指定发件人的电子邮件订阅，而不是一个完整的e-mail地址的别名。当报表服务器试图提供一份报告，作为电子邮件订阅的一部分，您会收到以下错误消息：

至少有一个或发件人字段是必需的，既没有被发现。邮件将不会被重新发送。

回到顶端

方案2

升级后的计算机已安装到Windows Vista或Windows Server 2008的报告服务，您会收到以下错误消息时，报表服务器提供电子邮件订阅一份报告：

至少有一个收件人是必需的，但没有发现。邮件将不会被重新发送。

发生此问题，如果满足以下条件：

发件人的电子邮件地址是一个完整的e-mail地址。
在报表服务器上的配置文件DefaultHostName标签未设置。
在报表管理器的认购页，可以指定To字段的别名，而不是完整的e-mail地址。

如果至少有一个电子邮件地址在收件人字段是一个完整的e-mail地址，订阅不会失败。然而，该报告仅提供的是完整的e-mail地址，并在以下收件人字段中指定的地址：

至
CC
密件抄送
答复人

回到顶端

方案3

在您升级到Windows Vista或Windows Server 2008的远程SMTP服务器，您会收到以下错误消息时，报表服务器提供电子邮件订阅一份报告：

一个或多个收件人的e-mail地址是无效的。

发生此问题，如果满足以下条件：

发件人的电子邮件地址是一个完整的e-mail地址。
在报表服务器上的配置文件DefaultHostName标签未设置。
在报表管理器的认购页，可以指定To字段的别名，而不是完整的e-mail地址。

至
CC
密件抄送
答复人

回到顶端

原因

发生此问题，因为Windows Server 2003包含一个功能，充分发挥其e-mail地址解析别名。 SQL Server 2005报表服务取决于此功能允许使用电子邮件别名，而不是完整的e-mail地址。然而，以帮助过滤掉虚假的电子邮件地址，Windows Vista和Windows Server 2008中不包含此功能。

回到顶端

解决方案

要解决这个问题，你必须首先确保，一个完整的e-mail地址作为发件人的电子邮件地址为报表服务器指定。您可以通过使用下列方法之一：

在Reporting Services配置工具的电子邮件设置页面中，指定一个完整的e-mail地址，而不是发件人地址设置一个别名。
RSReportServer.config文件中，指定一个完整的e-mail地址，而不是位于下RSEmailDPConfiguration标签从标签的别名。默认情况下，配置文件位于以下文件夹中：
C：\ Program Files文件\的Microsoft SQL Server \ MSSQL的 X \ Reporting Services中\的ReportServer

然后，使用下列方法之一来解决这个问题。

回到顶端

方法1

设置报表服务器的配置文件域名 DefaultHostName设置。要做到这一点，请按照下列步骤：

打开rsreportserver.config配置文件。
修改的DefaultHostName的设置如下：
```
  <DefaultHostName>域名</ DefaultHostName的>
```
注意 DomainName是域名的占位符。

回到顶端

方法2

订阅页的报表管理，确保在以下领域的所有e-mail地址是完整的e-mail地址：

至
CC
密件抄送
答复人

回到顶端

状态

这种行为是由设计。

回到顶端

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

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.

Back to the top

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.

Back to the top

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

Back to the top

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

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

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.

Back to the top

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.

Back to the top

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

STATUS

This behavior is by design.

Back to the top

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