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.Obj ects.Account
GetAccount(Int32)
HelpLink: NULL
Source: DatabaseMailEngine

StackTrace Information
===================
at
Microsoft.SqlServer.Management.SqlIMail.Server.Dat aAccess.DataAccessAdapter.GetAccount(Int32 accountID)
at
Microsoft.SqlServer.Management.SqlIMail.Server.Con troller.CommandFactory.CreateSendMailCommand(DBSes sion dbSession)
at
Microsoft.SqlServer.Management.SqlIMail.Server.Con troller.CommandFactory.CreateCommand(DBSession dbSession)
at
Microsoft.SqlServer.Management.SqlIMail.Server.Con troller.CommandRunner.Run(DBSession db)
at
Microsoft.SqlServer.Management.SqlIMail.IMailProce ss.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

You may need to put a couple of entries for the short and FQDN cluster names
in the hosts file on each node.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP




"Julien" <Julien (AT) discussions (DOT) microsoft.com> wrote

You may need to put a couple of entries for the short and FQDN cluster names
in the hosts file on each node.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP




"Julien" <Julien (AT) discussions (DOT) microsoft.com> wrote

You may need to put a couple of entries for the short and FQDN cluster names
in the hosts file on each node.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP




"Julien" <Julien (AT) discussions (DOT) microsoft.com> wrote

You may need to put a couple of entries for the short and FQDN cluster names
in the hosts file on each node.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP




"Julien" <Julien (AT) discussions (DOT) microsoft.com> wrote

You may need to put a couple of entries for the short and FQDN cluster names
in the hosts file on each node.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP




"Julien" <Julien (AT) discussions (DOT) microsoft.com> wrote

You may need to put a couple of entries for the short and FQDN cluster names
in the hosts file on each node.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP




"Julien" <Julien (AT) discussions (DOT) microsoft.com> wrote

You may need to put a couple of entries for the short and FQDN cluster names
in the hosts file on each node.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP




"Julien" <Julien (AT) discussions (DOT) microsoft.com> wrote

You may need to put a couple of entries for the short and FQDN cluster names
in the hosts file on each node.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP




"Julien" <Julien (AT) discussions (DOT) microsoft.com> wrote

You may need to put a couple of entries for the short and FQDN cluster names
in the hosts file on each node.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP




"Julien" <Julien (AT) discussions (DOT) microsoft.com> wrote