Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Kalaiselvan
Posting Yak Master
112 Posts |
 Posted - 2015-02-12 : 14:01:55
|
| Hi,We are using SQL Server 2008 RTM. And tried to send mail using Database. 1. Created 2 Profile and set up 2 User Acoount. One for Gmail and another with web server. 2. Port number for Gmail chosed as 587 with SSL enabled. 3. Port number for our server choosed as 25. 4. Even added SMTP Server and Telenet Client Features in windows server. 5. Using sa login am trying to send the Mail. But unable to sent mail. 1. For Gmail Account Error isThe mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 2 (2015-02-13T00:25:40). 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). )2. For Web server Account error isThe mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 (2015-02-13T00:05:25). Exception Message: Could not connect to mail server. (The requested address is not valid in its context 173.203.2.19:25). )Please help me to fix this ISsue and solution to sent Mail through DB.Regards,KalaiRegards,Kalai |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2015-02-16 : 01:50:05
|
| For web server account option. Are you able to ping and telnet the mail server. Try this on the server where you have SQL Server installed, but do it from the OS cmdlineJack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
|
|
|
DB MAIL ISSUE