No database mail on SQL 2005 SP2 64 bit EE cluster.

Question

I've got database mail working on all my other servers except my cluster machine (running Windows Server 2003 64 bit EE).

I'm up-to-date on my service packs.  The setup of database mail seems to work fine.  Outlook Express works on that machine with the same account.  My other database can send mail.

I've add all relevant machine information to the hosts file.  I've dropped and recreate the profile.  I've restarted the SQL Server Agent.

I get the successful "Mail queued" message, but I never receive anything.

Here's the message I get in my mail log:


1) Exception Information  ===================  Exception Type: System.NullReferenceException  Message: Object reference not set to an instance of an object.  Data: System.Collections.ListDictionaryInternal  TargetSite: Microsoft.SqlServer.Management.SqlIMail.Server.Objects.Account GetAccount(Int32)  HelpLink: NULL  Source: DatabaseMailEngine    StackTrace Information  ===================     at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.DataAccessAdapter.GetAccount(Int32 accountID)     at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandFactory.CreateSendMailCommand(DBSession dbSession)     at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandRunner.Run(DBSession db)     at Microsoft.SqlServer.Management.SqlIMail.IMailProcess.ThreadCallBack.MailOperation(Object o)



Anyone seen anything like this?  Again, this is my only machine where database mail doesn't work.

Answer 1

Please refer to the following link.  Similar issues that were specific to pix firewall configuration.  Unfortunately the kb article referenced in the forum is no longer active.

 

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=584081&SiteID=1

 

Answer 2

Database Mail works with SQL2005 64bit SP2.

Check for this:

In Database Mail Configuration Wizard, go into Manage profile security, select a profile to be default by clicking under "Default Profile" and selecting Yes from the drop-down box.  You must also check the box under "Public" for the same Profile Name.  Click Next and Finish.

Note: Although in Agent Properites, Alert Systems TEST button will be grayed out, still  Database Mail will work with SQL Agent.

Answer 3

Yes, I have made this profile my default profile.  And I have made it public.  This was not my issue.

 

Again, I have database mail working on all my other (non-clustered) machines.

 

I've seen newsgroup postings about adding the cluster name to the hosts file, but I can't find anything official from Microsoft about this.  Has anyone else come across this problem?

Answer 4

Have you enabled Database Mail and SQL Mail in Surface Area Configuration for Virtual Server for the Clustred Instance?

 

Answer 5

I am getting the same error as Patrick has wrote,

 

I have also the same environment. i have sql server 2005 64 Bit Enterprise edition in a cluster Environment, but when trying to send a mail,

it gives the same error as this

 

 

Message
1) Exception Information
===================
Exception Type: System.NullReferenceException
Message: Object reference not set to an instance of an object.
Data: System.Collections.ListDictionaryInternal
TargetSite: Microsoft.SqlServer.Management.SqlIMail.Server.Objects.Account GetAccount(Int32)
HelpLink: NULL
Source: DatabaseMailEngine

StackTrace Information
===================
   at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.DataAccessAdapter.GetAccount(Int32 accountID)
   at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandFactory.CreateSendMailCommand(DBSession dbSession)
   at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandRunner.Run(DBSession db)
   at Microsoft.SqlServer.Management.SqlIMail.IMailProcess.ThreadCallBack.MailOperation(Object o)

 

 

Plz Help in solving this problem

Answer 6

I am having the same problem. Does anybody found the soultion? If yes, please help us out.