SQL Server 2005报表服务订阅电子邮件不工作在Windows Vista和Windows Server 2008中，如果您使用e-mail地址的别名

在此页中

•  SYMPTOMS 症状
  •  Scenario 1方案1
  •  Scenario 2方案2
  •  Scenario 3方案3
•  CAUSE 原因
•  RESOLUTION 解决方案
  •  Method 1方法1
  •  Method 2方法2
•  STATUS 状态
•  MORE INFORMATION 更多信息
  •  Steps to reproduce the problem步骤来重现问题

全部展开 | 全部折叠

症状

注意：这篇文章也适用于微软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地址。

如果至少有一个电子邮件地址在收件人字段是一个完整的e-mail地址，订阅不会失败。 然而，该报告仅提供的是完整的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设置。 要做到这一点，请按照下列步骤：

1. 打开rsreportserver.config配置文件。
2. 修改的DefaultHostName的设置如下：

     <DefaultHostName>域名</ DefaultHostName的>

   注意 DomainName是域名的占位符。

 回到顶端

方法2

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

• 至
• CC
• 密件抄送
• 答复人

 回到顶端

状态

这种行为是由设计。

 回到顶端

更多信息

步骤来重现问题

1. 在基于Windows Vista的计算机或基于Windows Server 1 2008的计算机上，安装SQL Server 2005报表服务。
2. 创建一个报告。
3. 创建报告交付指定要订阅的领域中的一个电子邮件别名电子邮件订阅。
4. 尝试提供该报告的电子邮件订阅

-------------------------------------------------------原文--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------原文--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------原文--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------原文------------------------------------------------------------------------------------------------------------------------------------------------------------------------

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.

On This Page

•  症状 SYMPTOMS
  •  方案1 Scenario 1
  •  方案2 Scenario 2
  •  方案3 Scenario 3
•  原因 CAUSE
•  解决方案 RESOLUTION
  •  方法1 Method 1
  •  方法2 Method 2
•  状态 STATUS
•  更多信息 MORE INFORMATION
  •  步骤来重现问题 Steps to reproduce the problem

Expand all | Collapse all

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.

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

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:

1. Open the Rsreportserver.config configuration file.
2. 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

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

 Back to the top

---

APPLIES TO

• Microsoft SQL Server 2005 Reporting Services

 Back to the top

Keywords:

kberrmsg kbtshoot kbprb kbsql2005rs kbexpertiseadvanced KB945601

 Back to the top