Post reply

Sending mail from On Prem server to Off prem exchange

  • July 12, 2013 at 12:20 pm

    #395135

    Im having some troubles getting my SQL mail setup using an off premise exchange with office 365. I can get the server to send through googles smtp but cant get it to work with office365.

    Has anyone gotten this type of setup to work ? Ive found through searching that i may have to setup an SMTP server locally to route to the online exchange ?? Below is a link to a description.

  • July 14, 2013 at 11:28 am

    #1632234

    Hi,

    I have successfully used Office 365 (Cloud) to send mails from SQL's Database mail.

    1. Once you login to portal, go to the See other options section where you will have to find out your office 365 DNS name, TLS port for SMTP which i believe will be 587.

    2. Install telnet on the server where you're configuring database mail and run this from command prompt "telnet yourserveraddress 587" this should return something, if it fails then there is a problem with your firewall or your proxy.

    3. Ensure the From email address is same as the account used for authenticating SMTP because office 365 by default it does not allow to impersonate or Send As even if it was admin account unless you used Powershell to make the change.

    Regards,

  • July 17, 2013 at 12:37 pm

    #1633416

    What option are you using for SMTP authentication ?

    Windows Authentication

    Basic Authentication

    Anonymous Authentication

  • July 17, 2013 at 10:01 pm

    #1633510

    Basic Authentication and enter the SMTP's account credentials.

  • July 19, 2013 at 1:37 pm

    #1634181

    Finally got it working, found out that i didnt have the right SMTP address after all.

    Thanks

  • July 19, 2013 at 11:03 pm

    #1634231

    Great!. Glad i could help you 🙂

    Regards,

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply