Microsoft KB Archive/931631

From BetaArchive Wiki
Knowledge Base


Error message when you try to configure SQL Server Agent to interact with Database Mail in SQL Server 2005 64-bit editions: "An attempt was made to send an email when no email session has been established"

Article ID: 931631

Article Last Modified on 2/22/2007



APPLIES TO

  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Standard X64 Edition
  • Microsoft SQL Server 2005 Standard Edition for Itanium-based Systems
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • Microsoft SQL Server 2005 Enterprise Edition for Itanium-based Systems



SYMPTOMS

Consider the following scenario. In Microsoft SQL Server 2005 64-bit editions, you try to configure SQL Server Agent to interact with Database Mail. You want Database Mail to send an e-mail message about the status of a SQL Server Agent job. In this scenario, you receive the following error message:

Message [264] An attempt was made to send an email when no email session has been established.

Note In this error message, the word "email" is a misspelling for the word "e-mail."

In SQL Server 2005 32-bit editions, you can configure SQL Server Agent to interact with Database Mail to send the e-mail message.

RESOLUTION

Service pack information

To resolve this problem, obtain the latest service pack for SQL Server 2005. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

913089 How to obtain the latest service pack for SQL Server 2005


WORKAROUND

To work around this problem, use the method that is described in Microsoft Knowledge Base article 908360 to send the e-mail message in SQL Server 2005 64-bit editions. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

908360 How to configure SQL Server Agent to send job status notifications and alert notifications in SQL Server 2005 64-bit editions


STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. This problem was first corrected in SQL Server 2005 Service Pack 1.

Keywords: kbqfe kbexpertiseadvanced kbsql2005engine kbprb KB931631