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 ac
-
viernes, 04 de mayo de 2012 12:56
Hi everyone.
I am new to sql server. i am sending email from sql server 2008 r2 [Full version].
Sql server 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). )Please tell me this is which type of error and whats solution for this problem. please help.
Thanks and Regards:
Ganpat Sharma
Todas las respuestas
-
lunes, 07 de mayo de 2012 2:54 Hi Ganpat Sharma,
Regarding to the error message, which might be the mail server is rejecting the connection. Have you tried using telnet from the sql server and connecting to the SMTP Port at gmail.
Maybe this link will be able to help you, it shows you the telnet method: http://techblissonline.com/troubleshoot-gmail-smtp-server-connection/
Meanwhile you can refer to these articles about how to configure database mail in SQL Server
1. SQL SERVER - 2008 - Configure Database Mail - Send Email From SQL Database http://www.codeproject.com/Articles/29060/SQL-SERVER-2008-Configure-Database-Mail-Send-Email
2. Database setup http://www.sqlservercentral.com/blogs/databaseexpertisecom/2010/05/12/database-mail-set-up-in-sql-server-2008/Regards, Amber zhang
- Marcado como respuesta Iric WenModerator viernes, 11 de mayo de 2012 8:47
-
lunes, 07 de mayo de 2012 5:15
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). )Please need help.
Thanks and Regards:
Ganpat Sharma- Combinado Stephanie LvModerator martes, 08 de mayo de 2012 2:04 duplicated thread
-
lunes, 14 de mayo de 2012 4:54
Thanks Amber zhang.
.png)
