Database Mail quit working

Question

Database Mail quit working

Ellen-477471

SSCrazy

Points: 2238
More actions
April 11, 2012 at 4:29 pm

#391996

Originally Database Mail worked fine on two of our SQL Server 2005 servers.
After some system issues and cloning a server the result is that Database Mail no longer works.
Below is the error message when trying to send a test email from the SQL Server 2005 server.
one server is at version 9.0.5259 [KB2489409]
the other is at 9.0.5292 [KB2494123]
I've run through the troubleshooting procedures and have dropped and recreated the mail profiles and accounts.
Does anyone have any ideas on what to look at? The error says that it cannot read the mail configuration from the database ...
Thank you in advance for any assistance.
1) Exception Information ===================
Exception Type: Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException
Message: Mail configuration information could not be read from the database.
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.CommandRunner.Run(DBSession db)
at Microsoft.SqlServer.Management.SqlIMail.IMailProcess.ThreadCallBack.MailOperation(Object o)
2) Exception Information ===================
Exception Type: System.IndexOutOfRangeException
Message: timeout
Data: System.Collections.ListDictionaryInternal TargetSite: Int32 GetOrdinal(System.String)
HelpLink: NULL
Source: System.Data
StackTrace Information ===================
at System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName)
at System.Data.SqlClient.SqlDataReader.GetOrdinal(String name)
at System.Data.SqlClient.SqlDataReader.get_Item(String name)
at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.DataAccessAdapter.GetAccount(Int32 accountID)

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

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

Chuck Hottle SSCarpal Tunnel Points: 4777 More actions · Answer 1

I did a Google search for "Mail configuration information could not be read from the database." and several decent links came back. If you haven't done that, give it a try. This is ffrom Microsoft Customer Service and Support (CSS) SQL Support.