Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Database mail not sending messsages
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

WWRDBA2
Starting Member

2 Posts

Posted - 12/29/2014 :  10:54:00  Show Profile  Reply with Quote
I have a 2005 server with a default instance and 2 named instances.
All are SQL Server 9.0.4294 (Cumulative Update Package 9 for SQL Server 2005 Service Pack 3).

The default instance not having issues sending mail, but the 2 named instances are. Message (see below) indicates a problem getting at the
TIMEOUT column because 2005 Service Pack 2 received a new version of the binary files and schema definitions.

I have experimented with the DatabaseMailUserRole in msdb, and also attempted to create different profiles and users ... none have solved the issue.

Any suggestions appreciated. Thanks.

Specific error text:

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)

seshurtz
Starting Member

USA
7 Posts

Posted - 03/09/2015 :  08:14:28  Show Profile  Reply with Quote
Hi WWRDBA2,

I have not run into this issue specifically but, I did some quick searches and turned up a few resources that may help. According to Microsoft, this appears to be an issue with 2005 and 2008. 2005 Service Pack 3 Cumulative Update 4 is supposed to resolve the issue but, from what I have read, this doesn't always happen. Here are some resources I have found:

Microsoft KB regarding the issue:
http://support.microsoft.com/kb/2008286

Talks about updating a stored proc:
http://www.practicalsqldba.com/2012/03/sql-server-2005-database-mail-stopped.html

SQL Server Central forum topic discussing the issue:
http://www.sqlservercentral.com/Forums/Topic800068-146-1.aspx

Stack Overflow forum topic discussing the issue. They used Profiler to capture further information:
http://stackoverflow.com/questions/13638347/database-mail-mail-configuration-information-could-not-be-read-from-the-databa


Hope this helps!

Steve Shurtz, MCP
Database Administrator
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000