October 1, 2011 at 10:21 am
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.
October 6, 2011 at 12:42 pm
Any ideas?
October 6, 2011 at 12:49 pm
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply