从Sql Server 2008 R2发送数据库邮件失败.像错误无法连接到邮件服务器. (试图以一种其访问权限禁止的方式访问套接字吗?

问题描述:

大家好.
我正在从sql server 2008 r2发送电子邮件.

数据库邮件配置详细信息设置为:
-------------------------------------------------- ------------
伺服器名称:smtp.gmail.com
端口号:587
设置基本身份验证:用户名,密码

我尝试了更多,但是电子邮件发送失败并且发生错误是-:

由于邮件服务器故障,邮件无法发送给收件人. (使用帐户2(2012-05-03T15:46:30发送邮件.异常消息:无法连接到邮件服务器.)(试图以一种受其访问权限禁止的方式访问套接字173.194.79.108:587 ).)


致谢:
Ganpat Sharma

Hi everyone.
i am sending email from sql server 2008 r2.

database mail configuration details set as :
--------------------------------------------------------------
Server Name : smtp.gmail.com
Port No : 587
Set Basic Authentication : User Name, Password

i tried more but email sending is failed and error occur is-:

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 2 (2012-05-03T15:46:30). Exception Message: Could not connect to mail server. (An attempt was made to access a socket in a way forbidden by its access permissions 173.194.79.108:587). )


Thanks and Regards:
Ganpat Sharma

可能是由于各种原因.您需要一一看待它们.

港口开放吗?防火墙权限到位了吗?
进一步确保已将数据库配置为发送电子邮件.看这里:
SQL SERVER – 2008 –配置数据库邮件–从SQL数据库发送电子邮件 [ CP:SQL SERVER-2008-配置数据库邮件-从发送电子邮件SQL数据库 [ ^ ]
It can be because of various reasons. You need to look at them one by one.

Is the port open? Firewall permissions in place?
Further make sure you have configured database to send emails. Look here:
SQL SERVER – 2008 – Configure Database Mail – Send Email From SQL Database[^]
CP: SQL SERVER - 2008 - Configure Database Mail - Send Email From SQL Database[^]