Share via

ENHANCEMENT - Database Mail in SQL 2005 64 bit and SP1

  • Article

Database Mail is a new feature in SQL 2005 that provides enterprise class mailing functionality in SQL 2005 32 bit and 64 bit versions.

SQL Server 2005 RTM x64/IA64

In SQL 2005 RTM x64 and IA64 bit versions, you can use Database Mail features just as you would on 32 bit versions of SQL.

However, on 64 bit, you cannot have SQL Agent interact with Database Mail to send notification of job failure/success etc. This is by design.

This is not the case with 32 bit versions. On SQL Server 2005 32 bit RTM versions, SQLAgent can interact with and use Database Mail subsystem.

Workaround for RTM versions of SQL 2005 x64/IA64

On 64 bit versions of SQL, you can use SQLAgent Mail through a MAPI profile, as documented in this article - https://support.microsoft.com/kb/908360/en-us

Service Pack 1 enhancement

With the launch of Service Pack 1, Microsoft has improved on this functionality.

Now, you can use Database Mail as the mailing system for your SQL Agent on x64/IA64 versions, after applying SP1.

Comments

  • Anonymous
    June 01, 2006
    Can you use Database Mail with notification services?

  • Anonymous
    August 10, 2006
    All this is nice, but we were using SQL Mail to parse emails from an exchange 2003 mailbox.
    Now that we moved to 2005 x64 we cannot use this functionality.
    Huge problem...

  • Anonymous
    August 11, 2006
    Yes, SQLMAIL was NOT designed to work on x64 bit. It was also not designed to work on Clusters.

    That's why we introduced the concept of SQL DBMAIL which can be used with x64 bit and also on a cluster.

    Let me know if you have any further questions and I will be glad to assist.

    Sanchan

  • Anonymous
    August 11, 2006
    The comment has been removed

  • Anonymous
    August 18, 2006
    I am sorry, but I couldnt get back to you earlier.

    Yes, you are right. DBMAIL is designed as a way to send emails and not as a way to receive it.

    So I am not sure how you used SQLMAIL earlier for this work, but do let me know and I will try to help as much as I can.

    Sanchan

  • Anonymous
    February 07, 2007
    We're running SP1 on an x64 cluster and still cannot get the Agent to sucessfully send notifications via DBMail.  Restarting the Agent doesn't help.  The Agent is configured to use DBMail.  The Agent log generates the same error others have resolved by restarting the service: "An attempt was made to send an email when no mail..."   Any ideas?

  • Anonymous
    June 13, 2009
    PingBack from http://thestoragebench.info/story.php?id=6588