I want to send Email from SQL Server 2005,
I create Profile and Account by using SQL Server Management,
I used this Stored Procedure:
@profile_name = 'MyProfileName',
@recipients = 'MyEmail@hotmail.com',
@subject = 'New Islamic Topics',
@body_format = 'HTML',
@body = 'Welcome in my Website.';
every thing is work nice and this message appear 'Mail queued.
' when run the Procedure msdb.dbo.sp_send_dbmail,
but the Email not received when i open my email nor in Junk mail,
I try every thing but no way, this the error message from log:
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 4 (2012-10-09T09:09:03). Exception Message: Cannot send mails to mail server. (The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.5.1 Authentication Required. Learn more at).