Have you ever configured database mail using Gmail account? There are many articles on the internet describing the steps. In this blog, we would learn about fixing an error “The SMTP server requires a secure connection or the client was not authenticated” which you might see when database mail is used. Note that this can also appear for non-Gmail setups also. So, here we go.
THE PROBLEM
I was working on a project with my client and they had a requirement to send alerts via database mail. They wanted to use Google’s email service i.e. Gmail for this. As soon as they configured and sent a test email, we received below error while sending a test email.
Log Database Mail (Database Mail Log)
Process ID: 2654
Mail Item ID: 23
Last Modified By: sa
Message: The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 4 (DateTime). 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).)
And of course, mail went to unsent/failed state.
SOLUTION/WORKAROUND
It took a while to find a solution as there were many solutions available on the internet. In our case, it was a checkbox. If you run into the same error, make sure that you check below checkbox under account setting section of database mail.
After this, we sent another test email and it was successfully delivered to the recipient.
While searching on the internet, I was also able to find another error which is fixed by the same setting. Here is the error:
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.7.0 Must issue a STARTTLS command first).’
Above error is also due to SSL checkbox.
Reference: Pinal Dave (https://blog.sqlauthority.com)
11 Comments. Leave new
Hi, I’m still getting that error though I checked that box.
I got the same error.
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 4 (2018-08-23T23:57:04). 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).
)
even if the settings and credential in my outlook is the same.
I had a similar issue, after checking everything I deleted and re-created the mail account and profile and it worked.
Worked for me, thank you!
Hi Pinal,
I got below error while configuring db mail in SQL 2017.
Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2019-07-04T11:13:02). Exception Message: Cannot send mails to mail server. (Mailbox unavailable. The server response was: 5.7.1 Unable to relay for EMAILID).
I am getting below error and I did many things still when send a mail DBMail stopped itself
Date 6/29/2020 10:46:11 PM
Log Database Mail (Database Mail Log)
Log ID 7575
Process ID 13880
Last Modified 6/29/2020 10:46:11 PM
Last Modified By NT AUTHORITYNETWORK SERVICE
Message
1) Exception Information
===================
Exception Type: Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException
Message: The Transaction not longer valid.
Data: System.Collections.ListDictionaryInternal
TargetSite: Void ValidateConnectionAndTransaction()
HelpLink: NULL
Source: DatabaseMailEngine
HResult: -2146232832
StackTrace Information
===================
at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.ConnectionManager.ValidateConnectionAndTransaction()
at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.ConnectionManager.RollbackTransaction()
at Microsoft.SqlServer.Management.SqlIMail.IMailProcess.QueueItemProcesser.GetDataFromQueue(DataAccessAdapter da, Int32 lifetimeMinimumSec)
at Microsoft.SqlServer.Management.SqlIMail.IMailProcess.QueueItemProcesser.ProcessQueueItems(String dbName, String dbServerName, Int32 lifetimeMinimumSec, LogLevel loggingLevel, Byte[] encryptionKey, Int32 connectionTimeout)
Can you help me please…
What worked for me, was to include the full email address in the User Name field of the “Basic Authentication” section of the Database Mail Configuration Wizard. Previously I had just used the user name but that still caused the error.
Hi ,
Can someone help me out with the below error. I cant even uninstall properly SQL server 2019, Tried many ways from Google but no luck..
How To Fix Error – “The Instance ID ‘MSSQLSERVER’ Is Already In Use By SQL Server Instance ‘MSSQLSERVER.INACTIVE’