After creating a profile and account using gmail account smtp.gmail.com port 587 I get an error while trying to send a test email
The mail could not be sent to the recipients because of the mail server failure. Cannot send mail to mail servers(The SMTP server requires secure connection or the client was not authenticated).
Command for sending
EXEC msdb.dbo.sp_send_dbmail @profile_name = 'Test Profile', -- my profile name @recipients = 'email@example.com', -- my email address, the same one -- which is also configured above @body = 'This is a test email sent from TEST server', @subject = 'TEST EMAIL', @importance ='HIGH'
What I am doing wrong? Or should I change some settings from in my gmail account settings? Thanks