DB-Mail not working: - SQL Server Forums

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

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

DB-Mail not working:

Author

Topic

jfro
Starting Member

1 Post

Posted - 2012-04-29 : 07:23:11

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

5 Posts

Posted - 2012-05-01 : 18:17:37

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources