Database Mail Configuration

  • Does Database Mail work with MX Records? Has anyone put in a solution on SQL 2000 and SQL 2005 using MC records?

    Any suggestions you can provide would be greatly appreciated.

    TIA...

  • whats MX and MC


    Everything you can imagine is real.

  • Long story short

    An MX record or Mail exchanger record is a type of resource record in the Domain Name System (DNS) specifying how Internet e-mail should be routed. MX records point to the servers that should receive an e-mail, and their priority relative to each other.

    Its like a virtual server that has a farm of exchange boxes that it can use to route email.

    You can read more at http://en.wikipedia.org/wiki/MX_record

     

  • I don't think so.  Database Mail is an SMTP Client, not an SMTP server.  You set it up to send mail to an SMTP server; that server will use MX DNS queries to decide where and how to route mail.  But unless I've missed something, I don't think it has the components to route mail itself, only to use the SMTP server you specify in the Account setup.

    Hope this helps.



    Mark

  • However

    It may be looking at the Database Mail within SQL Server 2005 as you can include multiple profiles for mail so that each one gets tried until the mail is sent.

    Or there is allways the SMTP service within Windows 2003 Server that can be configured as a relay .. not tried it with DBmail but SSRS (2k)

     

    Andy

  • Multiple accounts is definitely an option...

    Can you provide more information on how you integrated SSRS with Windows SMTP?

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

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