Database Mail Configuration Problem in a cluster env. (SQL 2005 SP

Giganews Newsgroups
Subject: Database Mail Configuration Problem in a cluster env. (SQL 2005 SP
Posted by:  Julien (Juli…@discussions.microsoft.com)
Date: Sun, 3 Feb 2008

Hello,

I'm trying to configure Database Mail on our Cluster running 2 SQL server
2005 SP2 node.

The configuratoin wizard is running fine and I presume  the details entered
are correct:
- Existing user
- FQN mail server etc..

I also made sure the cluster nodes were authorized to relay email on our
exchange mail server.

Trying to send a test mail flags up the following error in the Database Mail
error log:
"Date        07/12/2007 17:18:54
Log        Database Mail (Database Mail Log)

Log ID        49
Process ID        4372
Last Modified        07/12/2007 17:18:54
Last Modified By        DOMAIN\xxxx

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)
(Please see code for message)"

I also restarted the database server as well as the SQL agent after this
modifications but still no success.

Any ideas?

Thanks

Julien

Replies