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

Geoff
I am new. I get a similar error (below)
We also have a clustered server.

SELECT * FROM sysmail_allitems
and I get 3 entires for the e-mails I tried to sent.
The field,  status=UNSENT

Any idea how to fix this ?

MW



    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.DataAccessAdap
ter.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.Mail
Operation(Object o)


*** Sent via Developersdex http://www.developersdex.com ***

date: Wed, 13 Feb 2008 11:16:21 -0800   author:   M W

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

Did the hosts file modification not work?

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


"M W"  wrote in message 
news:OPG$rTnbIHA.5400@TK2MSFTNGP03.phx.gbl...
>
> Geoff
> I am new. I get a similar error (below)
> We also have a clustered server.
>
> SELECT * FROM sysmail_allitems
> and I get 3 entires for the e-mails I tried to sent.
> The field,  status=UNSENT
>
> Any idea how to fix this ?
>
> MW
>
>
>
>    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.DataAccessAdap
> ter.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.Mail
> Operation(Object o)
>
>
> *** Sent via Developersdex http://www.developersdex.com ***

date: Wed, 13 Feb 2008 15:03:09 -0500   author:   Geoff N. Hiten