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

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

  • Duplicate post. Direct replies here. http://www.sqlservercentral.com/Forums/Topic1432424-149-1.aspx

    _______________________________________________________________

    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 Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

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

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