SQL Server Send message error type and cause

Set up alerts

In the general items, make the following settings

1. New Alert
2. Set Alert name
3. Select Database
4. Select severity

The following settings can be made in response items

1. Select an operator to mail notifications
2. You can set up an alert job to execute

The following settings can be made in the options

1. Set how alert error text is set
2. Choose how mail is Sent
3. You can customize the other content to send

Configuring the operator

"Operator" message in SQL Agent new operator

make the following settings in "General"

1. Set name
2. Set e-mail address ()
3. Set e-mail address
4. Set up a paging duty schedule

Set in "Notifications"

1. Tick the alert that you want to send an email to

Enable Database Mail

In Database Mail, management, database log, do the following

1. Select configuration Tasks
2. Enter a configuration file name and description
3. Add an SMTP account
4. Enter the specified SMTP account name and description
5. Set send email address like [email protected]*****.com
6. Set the sender name in the message
7. Setting up an SMTP server such as QQ smtp.exmail.qq.com (port 25)
8. Enable SSL secure connection access, because the SMTP test does not support SSL send mail, so do not check the SSL option
9. Select Basic Authentication, enter email account information such as [email protected]*****.com account information, to ensure correct

Test messages in Database Mail, management, database logs whether the message is configured for a successful operation

1. Right click on " Database Mail " and select Send Test message
2. Enter recipient and message content
3. Right click on " View Database Mail log ", you can see whether the message sent a successful various log instructions, according to the instructions to modify the configuration

" error log during Database Mail configuration "

Error description 1

Date 2012-5-24 8:59:20
Log Database Mail (Database Mail log)

Log ID 53
Process ID 3976
Mail item ID 23
Last modified on 2012-5-24 8:59:20

Last modified by * *

News
The message could not be sent to the recipient because of a mail server failure. (Use Account 2 (2012-05-24t08:59:20) to send mail.) Exception message: The message could not be sent to the mail server. (There is a syntax error in the parameter or variable.) The server responds as: Mail from address must is same as authorization user).
)

Cause of error

Incorrect user name or password

Error description 2

Date 2012-5-24 8:56:31
Log Database Mail (Database Mail log)

Log ID 48
Process ID 3976
Mail item ID 20
Last modified on 2012-5-24 8:56:31
Last modified by * *

News
The message could not be sent to the recipient because of a mail server failure. (Use Account 2 (2012-05-24t08:56:31) to send mail.) Exception message: Unable to connect to the mail server. (The connection attempt failed because the connecting party did not respond correctly after a period of time or the connected host was unresponsive.) 119.147.74.45:456). )

Error description

The port number of the SMTP setting does not match the port number of the SMTP provided by the Mail service provider

Error 3
Date 2012-5-24 8:56:09
Log Database Mail (Database Mail log)

Log ID 47
Process ID 3976
Mail item ID 21
Last modified on 2012-5-24 8:56:09
Last modified by * *

News
The message could not be sent to the recipient because of a mail server failure. (Use Account 2 (2012-05-24t08:56:09) to send mail.) Exception message: The message could not be sent to the mail server. (The server does not support secure connections.) )。
)

Cause of error

SSL secure Connection not supported

Error description 4

Date 2012-5-23 20:56:11
Log Database Mail (Database Mail log)

Log ID 35
Process ID 844
Mail item ID 14
Last modified on 2012-5-23 20:56:11
Last modified by * *

News
The message could not be sent to the recipient because of a mail server failure. (Use Account 2 (2012-05-23t20:56:11) to send mail.) Exception message: The message could not be sent to the mail server. (Command order is incorrect.) The server responds as: Error:need EHLO and AUTH first!).
)

Cause of error

The SMTP service in the sender's mailbox is not enabled, go to the "settings", "Account" in the mailbox enable Pop3/smtp/imap switch

Error description 5

Date 2012-5-23 20:19:42
Log Database Mail (Database Mail log)

Log ID 23
Process ID 4384
Mail Item ID 9
Last modified on 2012-5-23 20:19:42
Last modified by * *

News
The message could not be sent to the recipient because of a mail server failure. (Use account 1 (2012-05-23t20:19:42) to send mail.) Exception message: Unable to connect to the mail server. (Do not know such a host.) )。
)

Cause of error

Error setting SMTP server name, incorrect format

SQL Server Send message error type and cause