SQL Server 2008中的数据库邮件功能 [英] Database mail feature in SQL Server 2008

问题描述

我是debuggin sp_Exec_SendEmail，我收到了错误

I am debuggin sp_Exec_SendEmail, and I got the error
"

@out_desc   The transport failed to connect to the server.


And when I am running 
use master
 go
 sp_configure 'show advanced options',1
 go
 reconfigure with override
 go
 sp_configure 'Database Mail XPs',1
 --go
 --sp_configure 'SQL Mail XPs',0
 go
 reconfigure
 go

I got the messages:
Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.
Configuration option 'Database Mail XPs' changed from 1 to 1. Run the RECONFIGURE statement to install.

Thank you for your time

推荐答案

我没有收到电子邮件通知

我必须提到我正在使用一个包含2条记录的表，其中包含今天的ExpiryDate字段值和我的hotmail.com和yahoo.com帐户的电子邮件收件人，我没有收到电子邮件。

在数据库配置电子邮件中我使用的服务器名称：smtp.gmail.com port 587

我按照这里的说明进行了大量故障排除

我检查了Service Broker是否已启用（并且可以从sys.databases中选择is_broker_enabled，其中name ='MSDB'（结果为is_enabled） = 1））

检查用户是否是DatabaseMailUserRole的成员......

EXEC msdb.sys.sp_helprolemember'DatabaseMailUserRole';

我尝试发送测试E_Mail，当连接到本地服务器并使用我的个人资料工作（我收到了电子邮件）（gmail a ccount）。所以，我不知道是什么问题

如果您有任何建议请告诉我

谢谢

I am not getting the email notification
I have to mention that I am using a table with 2 records with today's value for ExpiryDate field and my hotmail.com and yahoo.com account for email recipients, and I don't get the email.
In Database Configuration email I am using server name: smtp.gmail.com port 587
I followed the instructions from here and troubleshooting a lot
I checked if Service Broker is enabled (and it is OK Select is_broker_enabled from sys.databases where name=’MSDB’ (results is_enabled=1))
Checked if the users are member of the DatabaseMailUserRole......
EXEC msdb.sys.sp_helprolemember 'DatabaseMailUserRole';
I tried Send test E_Mail , when connected to the local server and works(I got the email) with my profile (gmail account). So, I don't know what's the problem
Please, let me know if you have any suggestions
Thank you

这篇关于SQL Server 2008中的数据库邮件功能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！