SQL Server 2005 Database Mail - Mail configuration information could not be read from the database.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » SQL Server 2005 Database Mail - Mail...

SQL Server 2005 Database Mail - Mail configuration information could not be read from the database.

Rate Topic

Display Mode

Topic Options

Author

Message

mstock

Posted Monday, March 18, 2013 6:20 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, March 19, 2013 7:17 AM
Points: 3, Visits: 1

I'm trying to setup Database Mail and send a test message, but it's not working.

I've done several step-by-steps and all and I can't get it to work. Also checked several posts in this forum but none helped. I think it used to work before (2 months ago) but we had to turn it off.

I've enabled it in Surface Configuration, have tried recreating all profiles, restarted SQL Agent, checked version mismatch...

I check the Database Mail and I get the following message:

Log
Database Mail (Database Mail Log)

Log ID
152
Process ID
7684
Last Modified
3/14/2013 6:49:58 PM
Last Modified By
SPEEDLING\sqlservice

Message
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)

Post #1432424

Sean Lange

Posted Monday, March 18, 2013 9:12 PM

SSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 2:34 PM
Points: 8,592, Visits: 8,233

Try this thread. http://www.sqlservercentral.com/Forums/Topic800068-146-1.aspx

Seems they walked through a number of issues with dbmail including the error you ran into.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

Post #1432455

« Prev Topic | Next Topic »

Permissions