Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Location
    Philly
    Posts
    51

    Unanswered: cdonts send mail T-SQL - IIS SMTP setup

    hello,

    I would like to send mail from sql server using CDONTS.

    I have the sql code for this and it works for internal addresses.

    I get an error/warning saying that it cannot relay for external addresses when I try an outside domain.

    Is there settings in IIS for the SMTP service that I can change to allow it to relay to the external domains?

    I have everything running on the SQL Server, and I do not have access to the exchange server.

    Thanks

  2. #2
    Join Date
    Jan 2006
    Posts
    27
    CDONTS sends email to the Local SMTP server. You can specify a "smart host" that the local server can forward any email it can't deliver.

    Search the help for the IIS SMTP Virtual Server. It's likely the network blocks any unapproved system from using the smtp port, and it's also likely the approved ones will need to allow your system to relay through them.

    Jay Grubb
    Technical Consultant
    OpenLink Software
    Web: http://www.openlinksw.com:
    Product Weblogs:
    Virtuoso: http://www.openlinksw.com/weblogs/virtuoso
    UDA: http://www.openlinksw.com/weblogs/uda
    Universal Data Access & Virtual Database Technology Providers

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •