Failing Database mail in clustered environment.

Question

Hi,
we had set up database mail which used to work fine. But now its been failing giving this messages:

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.CommandFactory.CreateCommand(DBSession dbSession)
   at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandRunner.Run(DBSession db)
   at Microsoft.SqlServer.Management.SqlIMail.IMailProcess.ThreadCallBack.MailOperation(Object o)



I am completely out of clue. Any help would be appreciated.

Thanks

Answer 1

Hi,

From the stacktrace information you provided, here are the potential causes :

First, please make sure that the Database mail account can visist the SMTP server, e.g if the account has the permission to visit that, if the password has been changed, or if the account is not in the domain that SMTP server in.

Second, you need to make sure if the firewall has prevent the account linking to the SMTP server. If you have installed the firewall or you have changed the protecting rule recently, I suggest that you can undo those changes and try again.

Thanks.

---

Microsoft Online Community Support Please remember to mark the replies as answers if they help and unmark them if they provide no help.