October 17, 2007 at 9:14 am
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)
Please let me know what can be the issue.
October 17, 2007 at 10:00 am
Can you check your authentication type? Go to Database mail configuration wizard -> Manage Existing account check the SMTP Authentication. Select the windows Authentication.
Tommy
Follow @sqlscribeOctober 17, 2007 at 10:44 pm
Hi Tommy,
I checked the authentication type and it is Windows Authentication.
October 18, 2007 at 11:23 am
Can you verify your SMTP relay via telnet - i.e.
technet.microsoft.com/en-us/library/003e4901-884f-4bc7-b3c3-557add4e5c3a.aspx
Tommy
Follow @sqlscribeViewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply