Email from SQL Server 2008 R2 does not go out

Question

Post reply

Email from SQL Server 2008 R2 does not go out

pbyrum

SSCrazy

Points: 2785
More actions
June 28, 2012 at 1:07 pm

#263085

Hello,
I have configured Database Mail and have created an email profile and operator to be used in a maintenance plan. When I send a test email message from SQL Server, the message goes through. No problems. However, when I include a Notify Operator Task and and the task gets executed, the email message is not sent and an error message is created in the log:
[364] The Messenger service has not been started - NetSend notifications will not be sent.
Can you help solve this problem? I am using Windows Server 2008 R2 and SQL Server 2008 R2.
Thanks.

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

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

Can you verify if each of the steps in the following outline have been followed?

http://www.mssqltips.com/sqlservertip/1523/how-to-setup-sql-server-alerts-and-email-operator-notifications/

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

pbyrum SSCrazy Points: 2785 More actions · Answer 2

pbyrum

SSCrazy

Points: 2785

June 28, 2012 at 1:19 pm

#1506808

Yes, I had those steps completed.

Lowell SSC Guru Points: 323518 More actions · Answer 3

i was under teh impression that NET SEND doesn't exist on vista or windows 7 machines; could that be the problem?

http://superuser.com/questions/38967/how-do-i-get-the-net-send-messenger-service-working-on-windows-7

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

pbyrum SSCrazy Points: 2785 More actions · Answer 4

The SQL Server 2008 R2 (Standard Edition) is running on a Windows Server 2008 R2. So, is this feature on Windows Server 2008 R2?

Lowell SSC Guru Points: 323518 More actions · Answer 5

well the error you posted is related to NET SEND, and not database mail;

i think your mixing the two up a little bit, and

that NET SEND should not be checked in the alerts.

did you check to see if the mails are failing? the service might be fine, but the problems with the mail server itself?

SELECT

err.[description],

fail.*

FROM [msdb].[dbo].[sysmail_event_log] err

inner join [msdb].[dbo].[sysmail_faileditems] fail

ON err.mailitem_id = fail.mailitem_id

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

pbyrum SSCrazy Points: 2785 More actions · Answer 6

You are right, there is something wrong with the email server. The Net Send option is not checked. When I ran that script, I see this:

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2012-06-26T11:41:05). Exception Message: Cannot send mails to mail server. (A recipient must be specified.). )