SQL SERVER DB Mail 2005

Question

Post reply

SQL SERVER DB Mail 2005

leaders_j

SSC-Addicted

Points: 485
More actions
August 22, 2013 at 6:44 am

#151275

Hello,
I configured the DB Mail Feature of my SQL Server 2005 and created a valid profile, but on my Windows 7 OS it queues but the mail does not go out. Also, I configured the same profile on windows XP and it works.
Can anyone help me?

Viewing 8 posts - 1 through 7 (of 7 total)

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

HanShi SSC-Dedicated Points: 33508 More actions · Answer 1

Is a anti-virus application blocking the mail?

What if you temporarily(!) turn off the firewall?

** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

leaders_j SSC-Addicted Points: 485 More actions · Answer 2

leaders_j

SSC-Addicted

Points: 485

August 22, 2013 at 7:11 am

#1643898

No

HanShi SSC-Dedicated Points: 33508 More actions · Answer 3

What is the message stated in the [sysmail_event_log].[description] column if you execute the query below?

SELECT *

FROM msdb.dbo.sysmail_allitems

LEFT OUTER JOIN msdb.dbo.sysmail_event_log

ON sysmail_allitems.mailitem_id = sysmail_event_log.mailitem_id

ORDER BY

send_request_date desc

** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

leaders_j SSC-Addicted Points: 485 More actions · Answer 4

leaders_j

SSC-Addicted

Points: 485

August 22, 2013 at 7:23 am

#1643906

The description is NULL

leaders_j SSC-Addicted Points: 485 More actions · Answer 5

Considering sysmail_event_log the description is as follows

DatabaseMail process is started

1) Exception Information =================== Exception Type: System.NullReferenceException Message: Object reference not set to an instance of an object. 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.DataAccess.SessionManager.GetAccount(Int32 accountID) 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)

DatabaseMail process is shutting down

HanShi SSC-Dedicated Points: 33508 More actions · Answer 6

It looks like your configuration of Database Mail isn't correct. Run sp_configure to see if DatabaseMail XPs are enabled and then delete and reconfigure your mail profile and account settings (see http://technet.microsoft.com/en-us/library/hh245116.aspx).

** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

leaders_j SSC-Addicted Points: 485 More actions · Answer 7

Hello,

I'm still encountering some problems with DB Mail on my Windows 7 machine. Below are the error messages

The mail could not be sent to the recipients because of the mail server failure.

(Sending Mail using Account 3 (2013-08-30T10:48:46). Exception Message: Cannot send mails to mail server. (Service not available, closing transmission channel. The server response was: ). )

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 (2013-08-30T11:03:46). Exception Message: Cannot send mails to mail server. (The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.7.1 Authentication required). )

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 (2013-08-30T11:22:32). Exception Message: Cannot send mails to mail server. (Failure sending mail.). )

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 (2013-08-30T11:29:57). Exception Message: Could not connect to mail server. (No such host is known). )

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 (2013-08-30T11:40:54). Exception Message: Cannot send mails to mail server. (The operation has timed out.). )