I have tried to send emails from SQL Server via sp_send_dbmail. I have setup the Database Mail with the details for Hotmail (I also tried Google). It doesn't send and the queue is up to 1070.

The queue State is RECEIVES_OCCURING.

I have just had this event:

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 15 (2024-11-20T09:25:29).

Exception Message: Cannot send mails to mail server. Service not available, closing transmission channel. The server response was: Cannot connect to SMTP server 204.79.197.212 (204.79.197.212:587), connect error 10060).

I have a profile called "SQL Admin":

• Server Name: smtp.live
• Port : 587
• This server requires a secure connection - Basic Authentication

I'm baffled, looking in sysmail.sentitems and its empty. please let me know what further information you need to help me