+ Reply to Thread
Results 1 to 4 of 4

SMTP mail - where does it go and how

  1. SMTP mail - where does it go and how

    Does the SMTP mail need to use the IIS authentication for Integrated Windows
    Authentication to send out email?

    http://support.microsoft.com/kb/304897

    We setup the SMTP mail on the 2003 64 bit server and are discovering that it
    still requires additional tweaking at the Exchange side of the server. Is
    this normal?

    Review steps: (something odd here - the account 3 listed below is not the
    default account profile

    SELECT items.subject,
    items.last_mod_date,
    l.description FROM dbo.sysmail_faileditems as items
    JOIN dbo.sysmail_event_log AS l
    ON items.mailitem_id = l.mailitem_id

    error:The mail could not be sent to the recipients because of the mail
    server failure. (Sending Mail using Account 3 (2007-02-26T09:15:51).
    Exception Message: Cannot send mails to mail server. (Mailbox unavailable.
    The server response was: 5.7.1 Unable to relay for myemail@somplace.com). )



    --
    Regards,
    Jamie

  2. RE: SMTP mail - where does it go and how

    Hi Jamie

    "thejamie" wrote:

    > Does the SMTP mail need to use the IIS authentication for Integrated Windows
    > Authentication to send out email?
    >
    > http://support.microsoft.com/kb/304897
    >
    > We setup the SMTP mail on the 2003 64 bit server and are discovering that it
    > still requires additional tweaking at the Exchange side of the server. Is
    > this normal?
    >
    > Review steps: (something odd here - the account 3 listed below is not the
    > default account profile
    >
    > SELECT items.subject,
    > items.last_mod_date,
    > l.description FROM dbo.sysmail_faileditems as items
    > JOIN dbo.sysmail_event_log AS l
    > ON items.mailitem_id = l.mailitem_id
    >
    > error:The mail could not be sent to the recipients because of the mail
    > server failure. (Sending Mail using Account 3 (2007-02-26T09:15:51).
    > Exception Message: Cannot send mails to mail server. (Mailbox unavailable.
    > The server response was: 5.7.1 Unable to relay for myemail@somplace.com). )
    >
    >
    >
    > --
    > Regards,
    > Jamie


    Are you referring to the account being set up with Windows Authentication
    using Database Engine service credentials? Which will connect to the SMTP
    server using the credentials configured for the SQL Server Database Engine
    service i.e. your service account needs to have permissions to connect to
    your exchange server.

    Regardless of your authentication method the SMTP server/relay will need
    configuring to accept those connections, your Exchange admin should be able
    to do this, and it is not really an issue with SQL Server!

    John

  3. RE: SMTP mail - where does it go and how

    John,

    After playing with this for a while we managed to get Exchange to allow SMTP
    permission to send from the SQL Server. The part that wasn't working was
    the reference to the email server itself. Apparently SMTP.mydomain.com did
    not work nor did the actual name of the Exchange server (2003)
    (myexchname.mydomain.com). We tried the ip address xxx.xxx.xxx.xxx and this
    enabled the mail to flow.

    I was confused about the permission because IIS enabled SMTP is sending the
    email to the Exchange server (I think this is what is happening). I thought
    it might be something on my end after the NetAdmin assured me the Exchange
    was receiving from the SQL Server without error.

    --
    Regards,
    Jamie


    "John Bell" wrote:

    > Hi Jamie
    >
    > "thejamie" wrote:
    >
    > > Does the SMTP mail need to use the IIS authentication for Integrated Windows
    > > Authentication to send out email?
    > >
    > > http://support.microsoft.com/kb/304897
    > >
    > > We setup the SMTP mail on the 2003 64 bit server and are discovering that it
    > > still requires additional tweaking at the Exchange side of the server. Is
    > > this normal?
    > >
    > > Review steps: (something odd here - the account 3 listed below is not the
    > > default account profile
    > >
    > > SELECT items.subject,
    > > items.last_mod_date,
    > > l.description FROM dbo.sysmail_faileditems as items
    > > JOIN dbo.sysmail_event_log AS l
    > > ON items.mailitem_id = l.mailitem_id
    > >
    > > error:The mail could not be sent to the recipients because of the mail
    > > server failure. (Sending Mail using Account 3 (2007-02-26T09:15:51).
    > > Exception Message: Cannot send mails to mail server. (Mailbox unavailable.
    > > The server response was: 5.7.1 Unable to relay for myemail@somplace.com). )
    > >
    > >
    > >
    > > --
    > > Regards,
    > > Jamie

    >
    > Are you referring to the account being set up with Windows Authentication
    > using Database Engine service credentials? Which will connect to the SMTP
    > server using the credentials configured for the SQL Server Database Engine
    > service i.e. your service account needs to have permissions to connect to
    > your exchange server.
    >
    > Regardless of your authentication method the SMTP server/relay will need
    > configuring to accept those connections, your Exchange admin should be able
    > to do this, and it is not really an issue with SQL Server!
    >
    > John


  4. RE: SMTP mail - where does it go and how

    Hi Jamie

    "thejamie" wrote:

    > John,
    >
    > After playing with this for a while we managed to get Exchange to allow SMTP
    > permission to send from the SQL Server. The part that wasn't working was
    > the reference to the email server itself. Apparently SMTP.mydomain.com did
    > not work nor did the actual name of the Exchange server (2003)
    > (myexchname.mydomain.com). We tried the ip address xxx.xxx.xxx.xxx and this
    > enabled the mail to flow.
    >

    This sounds like a DNS issue?

    John


+ Reply to Thread