Database Mail error

Question

Post reply

Database Mail error

aksh.2411

Right there with Babe

Points: 762
More actions
March 11, 2010 at 10:57 pm

#139290

Already a database mail is configured on SQL Server 2005 server & it used to send
mails continuesly but some times its stop sending mails with the error typed in
as follows. Finally the mail service get stopped automatically. The only
way to get this start sending mail is to run the databasemail90.exe file.
After starting databasemail90.exe also 689 mails are in unsent list.
pls suggest the way to push the unsent mails & the solution/fix for the
following error.
This Error is found in errorlog od database mail :
Error,5519,1) Exception
Information<nl/>===================<nl/>Exception Type: System
t.NullReferenceException<nl/>Message: Object reference not set to an instance of an
object.<nl/>Data: System.Collections.ListDictionaryInternal<nl/>TargetSite:
Microsoft.SqlServer.Management.SqlIMail.Server.Objects.Account
GetAccount(Int32)<nl/>HelpLink: NULL<nl/>Source:
DatabaseMailEngine<nl/><nl/>StackTrace
Information<nl/>===================<nl/> at
Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.DataAccessAdapter.GetAccount(Int32
accountID)<nl/> at
Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.SessionManager.GetAccount(Int32
accountID)<nl/> at
Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandFactory.CreateSendMailCommand(DBSession
dbSession)<nl/> at
Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandRunner.Run(DBSession
db)<nl/> at
Microsoft.SqlServer.Management.SqlIMail.IMailProcess.ThreadCallBack.MailOperation(Object
o),2620,,,2/11/2010 10:19:42 AM,EEFT\locsmart151

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

Is this server clustered or a VM?

Try the following if clustered:

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

Try the following if a VM:

Insert a Hosts file entry that points the short VirtualServer name to the virtual IP address of the SQL instance.

Then Database mail can find the clustered/vm instance correctly.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events