When i use sp_send_dbmail stored procedure inside a Execute SQL task,the task is executed successfully.
But when i look in to 'Database Mail Log', it says
"The mail could not be sent to the recepient because of the mail server failure. Exception message: cannot send mails to mail server(The remote certificate is invalid according to the validation procedure)
In Database Mail configuration:
Windows Authentication is used , and i even tried Basic authentication.
Please let me know what can be the issue.
No one has replied yet! Why not be the first?
Sign in or Join us (it's free).