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.