SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 DB-Mail not working:
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

jfro
Starting Member

1 Posts

Posted - 04/29/2012 :  07:23:11  Show Profile  Reply with Quote
Hi,

i have an issue with DB Mail.

I configured on a test and production system (both with same configurations) with SP4 installed

On the test system the DB Mail functionality is working. On the production system I am not able to send mails. At start of the sql service i get this Message:


[355] The mail system failed to initialize; check configuration settings

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)

 

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


Do some one have some hints how i can get this issue solved?

Kind regards,
Jochen

sarabpreet12
Starting Member

India
5 Posts

Posted - 05/01/2012 :  18:17:37  Show Profile  Reply with Quote
PLease try the below steps:

1. Enable DB Mail in SP_Configure : 'Database Mail XPs',1
2. REstart SQL Agent Service
3. Make sure the Server is added to the relay of Your Mail Gateway server. (however, this setting will affect the delivery of email only)

This should help you i guess.


Sarabpreet Singh Anand
Go to Top of Page
  Previous Topic Topic Next Topic  
 New 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.06 seconds. Powered By: Snitz Forums 2000