SQL Server database mail Gmail Configuration

Source: Internet
Author: User

SQL Server database mail configuration Gmail is always unable to send out a variety of errors, such:

Message
ExternalMailQueue received an invalid XML Message format. Conversation_handle: 57D4CA6E-5478-DE11-9AD5-0023544B6077. Message_type_name: {// www.microsoft.com/databasemail/messages?sendmailstatus. Message Body: <? Xml version = "1.0" encoding = "UTF-8"?>
<Responses: SendMail xmlns: xsi = "http://www.w3.org/2001/XMLSchema-instance" xsi: schemaLocation = "http://schemas.microsoft.com/databasemail/responses ResponseTypes. xsd" xmlns: responses = "http://schemas.microsoft.com/databasemail/responses">
<Information>
<Failure Message = "the email cannot be sent to the recipient due to a Failure of the email server. (Use account 2 (: 18: 31) to send an email. Abnormal Email: unable to connect to the email server. (The connection attempt fails because the connection fails to respond correctly after a period of time or the host to which the connection is made does not respond. 209.85.147.109: 456 ). & # XD; & # xA;) "/>

 

<Information>
<Failure Message = "the email cannot be sent to the recipient due to a Failure of the email server. (Use account 2 (2009-07-24T21: 00: 23) to send an email. Abnormal Email: the email cannot be sent to the email server. (The operation has timed out .). & # XD; & # xA;) "/>

 

There are two more errors, which cannot be found now. In short, it is wrong on the port. The specific configuration is as follows:

Enter the correct email address

The server name is: Port smtp.gmail.com must be written as port 587 (The problem is described here when it is configured in foxmail as "465". You can send an email, however, the configuration in sqlserver must be written as 587,465. Harm me ...)

Require that SSL be checked. If the basic information is properly filled in, it will be OK.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.