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

Question

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

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

1 answer

Your answer

Answer 1

MikeyQiaoMSFT-0444 3,300

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.

Uday Paleti 20 Reputation points

2024-06-21T12:15:10.66+00:00

Hi Mikey,
Thanks for the response. Before posting my question here I already tried by enabling SSL connection (Check the box for "This server requires a secure connection (SSL)" to enable SSL for SMTP) but no luck. For the DB email account we are using port: 25.

DB email worked fine until last week and suddenly it stopped working. Also performed ping and Telnet from DB server to SMTP server, it is working fine and no firewall issues.

My question is how to check SMTP server issue exactly and what are the components I need to verify to make sure SMTP server is working or not? I have access only on DB server.If SMTP is from client side what are the steps I need to suggest to fix the issue to them?

Thanks for looking to it.

DBmail log

Share via

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

1 answer

Your answer