Share via

How to fix SMTP server requires a secure connection or the client was not authenticated.The server response was 5.7.0

Uday Paleti 20 Reputation points
2024-06-20T17:36:51.46+00:00

Hi Everyone,

Could you please provide solution for SMTP issue. One of my client asking how to fix SMTP issue when the SQLDBmail failing to send DB emails due to SMTP server issue.

I have pasted error message below

User's image

Thanks

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,125 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. MikeyQiaoMSFT-0444 1,255 Reputation points
    2024-06-21T03:14:30.4+00:00

    Hi，Uday Paleti

    Ensure the port number and enable SSL connection.

    Use the SSMS UI tutorial：

    Enter the SMTP server name and port (usually 587 for TLS/SSL).

    Check the box for "This server requires a secure connection (SSL)" to enable SSL for SMTP.

    User's image

    Or with T-SQL：

    Create a Database Mail account

    ......

    @port = 587

    ......

    @enable_ssl = 1

    Best Regards,

    Mikey Qiao

    If you're satisfied with the answer, don't forget to "Accept it," as this will help others who have similar questions to yours.