SQL 2005 Database Mail

• mdefreak

  Grasshopper

  Points: 13

  More actions

  February 18, 2010 at 10:01 pm

  #216935

  Greetings,

  I apologize if this has previously been posted, but I can't seem to find an answer to my question. I am trying to set up Database Mail in 2005 and I am unsuccessful in sending a test email. I've enabled the Alert System for my SQL Server Agent and have it set to Database Mail along with my profile name.

  This is the error that I am receiving:

  Message

  1) Exception Information

  ===================

  Exception Type: Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException

  Message: Could not retrieve item from the queue.

  Data: System.Collections.ListDictionaryInternal

  TargetSite: Microsoft.SqlServer.Management.SqlIMail.Server.Controller.ICommand CreateSendMailCommand(Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.DBSession)

  HelpLink: NULL

  Source: DatabaseMailEngine

  StackTrace Information

  ===================

  at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandFactory.CreateSendMailCommand(DBSession dbSession)

  at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandFactory.CreateCommand(DBSession dbSession)

  at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandRunner.Run(DBSession db)

  at Microsoft.SqlServer.Management.SqlIMail.IMailProcess.ThreadCallBack.MailOperation(Object o)

  I did find something similar in these threads and tried that user's resolution, but I continue to get the same error.

  Any ideas?

  Thanks,

  Matt

• Henrico Bekker

  One Orange Chip

  Points: 27652

  More actions

  February 19, 2010 at 12:18 am

  #1121585

  What sort of authentication to your exchange server, did you use in your mail profile?

  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  February 19, 2010 at 2:17 am

  #1121629

  Have you checked the following threads:

  http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=118247

  http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=102116

  http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=104334

  http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/e4421665-215a-42e6-bdb8-0aa6cca2a78c

  http://support.microsoft.com/kb/2008286

  http://www.sqlservercentral.com/Forums/Topic800068-146-1.aspx#bm800361

  http://blog.sqlauthority.com/2008/08/23/sql-server-2008-configure-database-mail-send-email-from-sql-database/

  http://www.bigresource.com/MS_SQL-Database-Mail-bC5q1LdQ.html

  I hope this helps 🙂

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/