SQL Server 2012
SQL Server 2012
Configuring database mail in order to get alerts and notifications from
my SQL Server 2012, I am not able to send test emails.
Tried smtp.soho.com port 587
Tried smtp.soho.com port 465 ssl
Using my user@domain.com as user name and the proper password as authentication.
Sending to the same email address that is used as authentication!
Relevant link is https://help.zoho.com/portal/en/community/topic/sql-server-2008-databasemail-not-connecting-to-smtp-zoho-com-exception-message-cannot-send-mails-to-mail-server-the-operation-has-timed-out
Using anonymous relay for google server is working, (but only gmail
accounts can be notified) so, it is needed that zoho could accept MS SQL
Server emails.
Log error at following.
Date 10/1/2014 9:00:53 AM
Log Database Mail (Database Mail Log)
Log ID 24
Process ID 5608
Mail Item ID 9
Last Modified 10/1/2014 9:00:53 AM
Last Modified By sa
Message
The mail could not be sent to the recipients because of the mail server
failure. (Sending Mail using Account 1 (2014-10-01T09:00:53). 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: Must issue a STARTTLS command first.).
)