We help IT Professionals succeed at work.
Get Started

SQL Database Mail Office 365 Access error

2,276 Views
Last Modified: 2014-03-05
Since moving over to Office 365 our SQL Database Mail has stopped running. At first i thought i knew what this problem was. As we no longer used our on site exchange server as everything is now running via Office 365. I would simply have to replace the local SMTP path, port to the online Office 365 path. Along with the correct email account and password.

I've logged onto the Office 365 admin portal and retrieved the correct SMTP path entered the path in the SQL Database Mail Configure page, ran a test email but nothing happens. The error i can see within the database mail log is as follows:

Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 18 (2014-01-14T09:24:37). Exception Message: Could not connect to mail server. (An attempt was made to access a socket in a way forbidden by its access permissions 132.245.194.249:587).
)

Any advice would be appreciated.
Comment
Watch Question
Commented:
This problem has been solved!
Unlock 1 Answer and 6 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE