Database Mail + Linux?

  • We use Database Mail with gmail account to send email. Our clients uses mail server based on Linux. Is it possible to use Database Mail and mail server on Linux? We gave Linux Machine Ip address as smtp client and assigned 25 port but was not able to send mail.

  • Any ideas?

  • WaitingWonder2 (10/1/2011)


    We use Database Mail with gmail account to send email. Our clients uses mail server based on Linux. Is it possible to use Database Mail and mail server on Linux? We gave Linux Machine Ip address as smtp client and assigned 25 port but was not able to send mail.

    SQL Server database mail simply sends the email to any SMTP mail server...it doesn't matter where or what OS that mail server uses, as long as it handles the mail requests...

    so you can set up a profile and accoutn in SQl server that uses the credentials that point to that SMTP server...

    it's about the same as saying can I use Outlook or Thunderbird to send an email to that server....none of those applications care aobut the server's behind the curtain details, just that it handles the request.

    when you tried sending the mail, you really need to review the failed mail and see what the specific error or failure was...

    SELECT

    err.[description],

    fail.*

    FROM [msdb].[dbo].[sysmail_event_log] err

    inner join [msdb].[dbo].[sysmail_faileditems] fail

    ON err.mailitem_id = fail.mailitem_id

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 3 posts - 1 through 2 (of 2 total)

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