我无法从SQL Server 2005发送电子邮件 [英] I can not send Email from SQL Server 2005

问题描述

大家好，

我想从SQL Server 2005发送电子邮件，
我使用SQL Server管理创建配置文件和帐户，
我使用了此存储过程:

Hi guys,

I want to send Email from SQL Server 2005,
I create Profile and Account by using SQL Server Management,
I used this Stored Procedure:

EXEC msdb.dbo.sp_send_dbmail
				@profile_name = 'MyProfileName',
				@recipients = '[e-mail]',
				@subject = 'New Islamic Topics',
				@body_format = 'HTML',    
				@body = 'Welcome in my Website.';

一切正常，运行过程msdb.dbo.sp_send_dbmail"时，此消息显示为" 邮件已排队. "，

但是当我打开我的电子邮件或垃圾邮件时都没有收到该电子邮件，

我尝试了所有事情，但是没有办法，这是日志中的错误消息:

由于邮件服务器故障，邮件无法发送给收件人. (使用帐户4(2012-10-09T09:09:03发送邮件.)异常消息:无法将邮件发送到邮件服务器.(SMTP服务器需要安全连接或客户端未通过身份验证.服务器响应为:5.5. 1要求身份验证.有关更多信息，请参见.)

every thing is work nice and this message appear ''Mail queued.'' when run the Procedure msdb.dbo.sp_send_dbmail,

but the Email not received when i open my email nor in Junk mail,

I try every thing but no way, this the error message from log:

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 4 (2012-10-09T09:09:03). 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.5.1 Authentication Required. Learn more at).

推荐答案

参考:
数据库邮件故障排除:邮件已排队，未送达 [ ^ ]
数据库邮件故障排除:邮件已排队，sysmail_event_log或Windows应用程序事件日志中没有条目 [ ^ ]

类似的讨论:
发送自动电子邮件SQL Server 2005 [使用SQL Server Job Schedular的自动电子邮件通知 [ ^ ]
SQL Server 2005中的电子邮件功能 [在SQL Server中使用数据库邮件发送电子邮件2005 [ ^ ]

Refer:
Troubleshooting Database Mail: Mail queued, not delivered[^]
Troubleshooting Database Mail: Mail queued, no entries in sysmail_event_log or Windows Application Event Log[^]

Similar discussion:
Send automatic email SQL server 2005[^]

Some articles:
Automated Email Notifications using SQL Server Job Schedular[^]
E-Mail Functionality in SQL Server 2005[^]
Sending E-mail with Database Mail in SQL Server 2005[^]

http://aspsnippets.com/Articles/Send-SMTP-Email-using-SQL- Server.aspx [ ^ ]

如果您能够追踪问题，请检查链接...

http://social.technet.microsoft.com/Forums/br/exchange2010/thread/b6e99b1e-790c-4694-82da-57c2ea7db52b[^]

http://aspsnippets.com/Articles/Send-SMTP-Email-using-SQL-Server.aspx[^]

Please check the link if u can able to trace the problem...

这篇关于我无法从SQL Server 2005发送电子邮件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！