Using Live/Hotmail/MSN for SQL Server 2008 Database Mail

Using Live/Hotmail/MSN for SQL Server 2008 Database Mail

Rate This
  • Comments 5

Over the weekend, I was playing around with trying to use my hotmail email account for SQL Server 2008 Database Mail. After searching, I found a promising post on the MSDN Forum under SQL Tools. In the forum posted, it was suggested that you need to use a premium account – this is not true. What you need to know is that on the account page, you need to leave the Display name and Reply e-mail fields blank for the DB Mail to successfully send emails and shown below:

image

For some reason, adding the Display name or Reply e-mail causes email server to reject the email with an error message that looks like this:

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2009-03-27T20:50:40). Exception Message: Cannot send mails to mail server. (Mailbox unavailable. The server response was: 5.7.3 Requested action aborted; user not authenticated).

Knowing the Server name for MSN,Live,Hotmail as smtp.live.com and the Port number as 25 are also helpful. With this information, you can follow the step-by-step instructions configuring DB Mail that SQL MVP Pinal Dave posted on this blog.

Leave a Comment
  • Please add 6 and 1 and type the answer here:
  • Post
  • PingBack from http://www.anith.com/?p=24193

  • This post is how to configure SQL Agent to use Database Mail for sending an email to an operator in the

  • Thank You Very Much for this. Perfect

  • Very useful information. Thanks a lot!

  • I still get this error: The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 5 (2013-10-21T13:43:18). Exception Message: Could not connect to mail server. (An attempt was made to access a socket in a way forbidden by its access permissions 65.55.96.11:25). ) Any help?

Page 1 of 1 (5 items)