Database Mail: getting bounce info from Exchange?

Database Mail only sends SMTP email messages and logs problems
connecting to the mail server. However, I also need to log bounced
emails (bad address, etc).

Are there any clean ways to do this with Database Mail and Exchange?
Or will I have to mix Database Mail with SQL Mail to read bounces out
of the inbox? Or, have a .NET windows service that talks to the
Exchange API?"Manny Klystron" <manny.klystron@.gmail.comwrote in message
news:1177542209.460490.41620@.t39g2000prd.googlegro ups.com...

Quote:

Originally Posted by

Database Mail only sends SMTP email messages and logs problems
connecting to the mail server. However, I also need to log bounced
emails (bad address, etc).
>
Are there any clean ways to do this with Database Mail and Exchange?
Or will I have to mix Database Mail with SQL Mail to read bounces out
of the inbox? Or, have a .NET windows service that talks to the
Exchange API?

I'd have a separate API that handles this. It's not really a good duty for
SQL Server.

Quote:

Originally Posted by

>

--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

Database Mail: getting bounce info from Exchange?

Database Mail only sends SMTP email messages and logs problems
connecting to the mail server. However, I also need to log bounced
emails (bad address, etc).
Are there any clean ways to do this with Database Mail and Exchange?
Or will I have to mix Database Mail with SQL Mail to read bounces out
of the inbox? Or, have a .NET windows service that talks to the
Exchange API?
"Manny Klystron" <manny.klystron@.gmail.com> wrote in message
news:1177542209.460490.41620@.t39g2000prd.googlegro ups.com...
> Database Mail only sends SMTP email messages and logs problems
> connecting to the mail server. However, I also need to log bounced
> emails (bad address, etc).
> Are there any clean ways to do this with Database Mail and Exchange?
> Or will I have to mix Database Mail with SQL Mail to read bounces out
> of the inbox? Or, have a .NET windows service that talks to the
> Exchange API?
I'd have a separate API that handles this. It's not really a good duty for
SQL Server.

>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

Database Mail: getting bounce info from Exchange?

Database Mail only sends SMTP email messages and logs problems
connecting to the mail server. However, I also need to log bounced
emails (bad address, etc).
Are there any clean ways to do this with Database Mail and Exchange?
Or will I have to mix Database Mail with SQL Mail to read bounces out
of the inbox? Or, have a .NET windows service that talks to the
Exchange API?"Manny Klystron" <manny.klystron@.gmail.com> wrote in message
news:1177542209.460490.41620@.t39g2000prd.googlegroups.com...
> Database Mail only sends SMTP email messages and logs problems
> connecting to the mail server. However, I also need to log bounced
> emails (bad address, etc).
> Are there any clean ways to do this with Database Mail and Exchange?
> Or will I have to mix Database Mail with SQL Mail to read bounces out
> of the inbox? Or, have a .NET windows service that talks to the
> Exchange API?
I'd have a separate API that handles this. It's not really a good duty for
SQL Server.
>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

Database Mail: getting bounce info from Exchange?

Database Mail only sends SMTP email messages and logs problems
connecting to the mail server. However, I also need to log bounced
emails (bad address, etc).
Are there any clean ways to do this with Database Mail and Exchange?
Or will I have to mix Database Mail with SQL Mail to read bounces out
of the inbox? Or, have a .NET windows service that talks to the
Exchange API?"Manny Klystron" <manny.klystron@.gmail.com> wrote in message
news:1177542209.460490.41620@.t39g2000prd.googlegroups.com...
> Database Mail only sends SMTP email messages and logs problems
> connecting to the mail server. However, I also need to log bounced
> emails (bad address, etc).
> Are there any clean ways to do this with Database Mail and Exchange?
> Or will I have to mix Database Mail with SQL Mail to read bounces out
> of the inbox? Or, have a .NET windows service that talks to the
> Exchange API?
I'd have a separate API that handles this. It's not really a good duty for
SQL Server.

>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

database mail to send mail to multiple recipient from table

I am using database mail to send emails to our Lotus Notes SMTP server using sp_send_dbmail. I want to accomplish the following.

I have maintained department-wise users email address in one table . Now I want to send mail to one particular department and there can be 1-15 users as recipient for that mail. How can I do that using sp_send_dbmail?

Well, I have found answer to it. The following way, we can accomplish. Hope that will help those, who are searching for something similar.

DECLARE @.email VARCHAR(4000)
SET @.email = ''
SELECT @.email = RTRIM(@.email) + RTRIM(email) + ';'
FROM Users
WHERE email <> '' AND DepCode = 'A'
PRINT @.email

EXECUTE msdb.dbo.sysmail_add_account_sp
@.account_name = 'custoerders',
@.description = 'Customer Address Account',
@.email_address = @.email
@.mailserver_name = 'mail.anywhere.com'

database mail to send mail to multiple recipient from table

I am using database mail to send emails to our Lotus Notes SMTP server using sp_send_dbmail. I want to accomplish the following.

I have maintained department-wise users email address in one table . Now I want to send mail to one particular department and there can be 1-15 users as recipient for that mail. How can I do that using sp_send_dbmail?

Well, I have found answer to it. The following way, we can accomplish. Hope that will help those, who are searching for something similar.

DECLARE @.email VARCHAR(4000)
SET @.email = ''
SELECT @.email = RTRIM(@.email) + RTRIM(email) + ';'
FROM Users
WHERE email <> '' AND DepCode = 'A'
PRINT @.email

EXECUTE msdb.dbo.sysmail_add_account_sp
@.account_name = 'custoerders',
@.description = 'Customer Address Account',
@.email_address = @.email
@.mailserver_name = 'mail.anywhere.com'

Database Mail SQL 2005

I'm having a problem with database mail in SQL Server 2005. I have set up a default profile. My SMTP server is not a localhost instead i've fed SMTP ip address and port no. The same setting in Outlook express works fine for Incoming and outgoing mails. but in SQL 2005 i'm not able to send test emails. The following errors show up in the sql server agent log

Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 (2006-06-13T10:47:27). Exception Message: Could not connect to mail server. (An established connection was aborted by the software in your host machine).
)

Please help me out....

I have the same problem,

Help please!!!!!!

|||What about testing the sending of Emails using telnet ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||yea, got the same problem. We need help with this issue and not a direction to telnet. Thanks|||Yes, sure but telnet will help you to see which error the SMTP server is throwing back during the sending of the message. I don′t want to instruct you using telnet, but thats often the best way to debug the communication.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||i've got the same problem on 64-bit version.
but outlook has sent the e-mails from this computer.

i cannot find in internet some clarifying answer about this problem
|||GUYS!!!!!!

It WORK!!!

See:

Database Mail in SQL Server 2005
www.databasejournal.com/features/mssql/article.php/3626056|||

hii

sending mail is worked. now i need to send the mail to multirecipients from a table. how could we do that? thank you very much

|||

Hi,

I would use something like this:

use adventureworks

Declare @.Recipients varchar(4000)

select @.Recipients = coalesce(@.Recipients + ';' , '' ) + emailAddress

FROM Person.Contact

PRINT @.Recipients

The results:

a0@.adventure-works.com;a1@.adventure-works.com;aaron0@.adventure-works.com;aaron1@.adventure-works.com;aaron10@.adventure-works.com

|||you're perfect |||Drat - that didn't fix it for me, I still get:

Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 5 (2007-06-12T10:46:15). Exception Message: Cannot send mails to mail server. (The operation has timed out.).
)

Outlook express can send fine. I am trying to use a gmail account configured using these settings:

Database Mail SQL 2005

I'm having a problem with database mail in SQL Server 2005. I have set up a default profile. My SMTP server is not a localhost instead i've fed SMTP ip address and port no. The same setting in Outlook express works fine for Incoming and outgoing mails. but in SQL 2005 i'm not able to send test emails. The following errors show up in the sql server agent log

Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 (2006-06-13T10:47:27). Exception Message: Could not connect to mail server. (An established connection was aborted by the software in your host machine).
)

Please help me out....

I have the same problem,

Help please!!!!!!

|||What about testing the sending of Emails using telnet ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||yea, got the same problem. We need help with this issue and not a direction to telnet. Thanks|||Yes, sure but telnet will help you to see which error the SMTP server is throwing back during the sending of the message. I don′t want to instruct you using telnet, but thats often the best way to debug the communication.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||i've got the same problem on 64-bit version.
but outlook has sent the e-mails from this computer.

i cannot find in internet some clarifying answer about this problem
|||GUYS!!!!!!

It WORK!!!

See:

Database Mail in SQL Server 2005
www.databasejournal.com/features/mssql/article.php/3626056|||

hii

sending mail is worked. now i need to send the mail to multirecipients from a table. how could we do that? thank you very much

|||

Hi,

I would use something like this:

use adventureworks

Declare @.Recipients varchar(4000)

select @.Recipients = coalesce(@.Recipients + ';' , '' ) + emailAddress

FROM Person.Contact

PRINT @.Recipients

The results:

a0@.adventure-works.com;a1@.adventure-works.com;aaron0@.adventure-works.com;aaron1@.adventure-works.com;aaron10@.adventure-works.com

|||you're perfect |||Drat - that didn't fix it for me, I still get:

Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 5 (2007-06-12T10:46:15). Exception Message: Cannot send mails to mail server. (The operation has timed out.).
)

Outlook express can send fine. I am trying to use a gmail account configured using these settings:

Database Mail SQL 2005

I'm having a problem with database mail in SQL Server 2005. I have set up a default profile. My SMTP server is not a localhost instead i've fed SMTP ip address and port no. The same setting in Outlook express works fine for Incoming and outgoing mails. but in SQL 2005 i'm not able to send test emails. The following errors show up in the sql server agent log

Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 (2006-06-13T10:47:27). Exception Message: Could not connect to mail server. (An established connection was aborted by the software in your host machine).
)

Please help me out....

I have the same problem,

Help please!!!!!!

|||What about testing the sending of Emails using telnet ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||yea, got the same problem. We need help with this issue and not a direction to telnet. Thanks|||Yes, sure but telnet will help you to see which error the SMTP server is throwing back during the sending of the message. I don′t want to instruct you using telnet, but thats often the best way to debug the communication.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||i've got the same problem on 64-bit version.
but outlook has sent the e-mails from this computer.

i cannot find in internet some clarifying answer about this problem|||GUYS!!!!!!

It WORK!!!

See:

Database Mail in SQL Server 2005
www.databasejournal.com/features/mssql/article.php/3626056|||

hii

sending mail is worked. now i need to send the mail to multirecipients from a table. how could we do that? thank you very much

|||

Hi,

I would use something like this:

use adventureworks

Declare @.Recipients varchar(4000)

select @.Recipients = coalesce(@.Recipients + ';' , '' ) + emailAddress

FROM Person.Contact

PRINT @.Recipients

The results:

a0@.adventure-works.com;a1@.adventure-works.com;aaron0@.adventure-works.com;aaron1@.adventure-works.com;aaron10@.adventure-works.com

|||you're perfect |||Drat - that didn't fix it for me, I still get:

Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 5 (2007-06-12T10:46:15). Exception Message: Cannot send mails to mail server. (The operation has timed out.).
)

Outlook express can send fine. I am trying to use a gmail account configured using these settings:

Database Mail SQL 2005

I'm having a problem with database mail in SQL Server 2005. I have set up a default profile. My SMTP server is not a localhost instead i've fed SMTP ip address and port no. The same setting in Outlook express works fine for Incoming and outgoing mails. but in SQL 2005 i'm not able to send test emails. The following errors show up in the sql server agent log

Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 (2006-06-13T10:47:27). Exception Message: Could not connect to mail server. (An established connection was aborted by the software in your host machine).
)

Please help me out....

I have the same problem,

Help please!!!!!!

|||What about testing the sending of Emails using telnet ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||yea, got the same problem. We need help with this issue and not a direction to telnet. Thanks|||Yes, sure but telnet will help you to see which error the SMTP server is throwing back during the sending of the message. I don′t want to instruct you using telnet, but thats often the best way to debug the communication.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||i've got the same problem on 64-bit version.
but outlook has sent the e-mails from this computer.

i cannot find in internet some clarifying answer about this problem
|||GUYS!!!!!!

It WORK!!!

See:

Database Mail in SQL Server 2005
www.databasejournal.com/features/mssql/article.php/3626056|||

hii

sending mail is worked. now i need to send the mail to multirecipients from a table. how could we do that? thank you very much

|||

Hi,

I would use something like this:

use adventureworks

Declare @.Recipients varchar(4000)

select @.Recipients = coalesce(@.Recipients + ';' , '' ) + emailAddress

FROM Person.Contact

PRINT @.Recipients

The results:

a0@.adventure-works.com;a1@.adventure-works.com;aaron0@.adventure-works.com;aaron1@.adventure-works.com;aaron10@.adventure-works.com

|||you're perfect |||Drat - that didn't fix it for me, I still get:

Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 5 (2007-06-12T10:46:15). Exception Message: Cannot send mails to mail server. (The operation has timed out.).
)

Outlook express can send fine. I am trying to use a gmail account configured using these settings:

Database Mail SQL 2005

I'm having a problem with database mail in SQL Server 2005. I have set up a default profile. My SMTP server is not a localhost instead i've fed SMTP ip address and port no. The same setting in Outlook express works fine for Incoming and outgoing mails. but in SQL 2005 i'm not able to send test emails. The following errors show up in the sql server agent log

Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 (2006-06-13T10:47:27). Exception Message: Could not connect to mail server. (An established connection was aborted by the software in your host machine).
)

Please help me out....

I have the same problem,

Help please!!!!!!

|||What about testing the sending of Emails using telnet ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||yea, got the same problem. We need help with this issue and not a direction to telnet. Thanks|||Yes, sure but telnet will help you to see which error the SMTP server is throwing back during the sending of the message. I don′t want to instruct you using telnet, but thats often the best way to debug the communication.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||i've got the same problem on 64-bit version.
but outlook has sent the e-mails from this computer.

i cannot find in internet some clarifying answer about this problem
|||GUYS!!!!!!

It WORK!!!

See:

Database Mail in SQL Server 2005
www.databasejournal.com/features/mssql/article.php/3626056|||

hii

sending mail is worked. now i need to send the mail to multirecipients from a table. how could we do that? thank you very much

|||

Hi,

I would use something like this:

use adventureworks

Declare @.Recipients varchar(4000)

select @.Recipients = coalesce(@.Recipients + ';' , '' ) + emailAddress

FROM Person.Contact

PRINT @.Recipients

The results:

a0@.adventure-works.com;a1@.adventure-works.com;aaron0@.adventure-works.com;aaron1@.adventure-works.com;aaron10@.adventure-works.com

|||you're perfect |||Drat - that didn't fix it for me, I still get:

Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 5 (2007-06-12T10:46:15). Exception Message: Cannot send mails to mail server. (The operation has timed out.).
)

Outlook express can send fine. I am trying to use a gmail account configured using these settings:

Database Mail SQL 2005

I'm having a problem with database mail in SQL Server 2005. I have set up a default profile. My SMTP server is not a localhost instead i've fed SMTP ip address and port no. The same setting in Outlook express works fine for Incoming and outgoing mails. but in SQL 2005 i'm not able to send test emails. The following errors show up in the sql server agent log

Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 (2006-06-13T10:47:27). Exception Message: Could not connect to mail server. (An established connection was aborted by the software in your host machine).
)

Please help me out....

I have the same problem,

Help please!!!!!!

|||What about testing the sending of Emails using telnet ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||yea, got the same problem. We need help with this issue and not a direction to telnet. Thanks|||Yes, sure but telnet will help you to see which error the SMTP server is throwing back during the sending of the message. I don′t want to instruct you using telnet, but thats often the best way to debug the communication.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||i've got the same problem on 64-bit version.
but outlook has sent the e-mails from this computer.

i cannot find in internet some clarifying answer about this problem
|||GUYS!!!!!!

It WORK!!!

See:

Database Mail in SQL Server 2005
www.databasejournal.com/features/mssql/article.php/3626056|||

hii

sending mail is worked. now i need to send the mail to multirecipients from a table. how could we do that? thank you very much

|||

Hi,

I would use something like this:

use adventureworks

Declare @.Recipients varchar(4000)

select @.Recipients = coalesce(@.Recipients + ';' , '' ) + emailAddress

FROM Person.Contact

PRINT @.Recipients

The results:

a0@.adventure-works.com;a1@.adventure-works.com;aaron0@.adventure-works.com;aaron1@.adventure-works.com;aaron10@.adventure-works.com

|||you're perfect |||Drat - that didn't fix it for me, I still get:

Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 5 (2007-06-12T10:46:15). Exception Message: Cannot send mails to mail server. (The operation has timed out.).
)

Outlook express can send fine. I am trying to use a gmail account configured using these settings:

Database Mail SMTP Settings

Hi All,
The Sql server will send emails when I am connected to it on the LAN but not
when I am remote or connected via a VPN. I am using the fully qualified
hostname for the smtp server in the database mail configuration.
Here is the error message:
The mail could not be sent to the recipients because of the mail server
failure. (Sending Mail using Account 3 (2007-06-08T16:36:07). Exception
Message: Cannot send mails to mail server. (The operation has timed out.).
Thanks for your help.
JN
On Jun 11, 4:11 pm, "JN" <j...@.ecconsulting.com> wrote:
> Hi All,
> The Sql server will send emails when I am connected to it on the LAN but not
> when I am remote or connected via a VPN. I am using the fully qualified
> hostname for the smtp server in the database mail configuration.
> Here is the error message:
> The mail could not be sent to the recipients because of the mail server
> failure. (Sending Mail using Account 3 (2007-06-08T16:36:07). Exception
> Message: Cannot send mails to mail server. (The operation has timed out.).
> Thanks for your help.
> JN
Hi
Can you ping/telnet the mail server?
Has the server been set to exclude connections via VPNs?
John
|||It looks like the problem is caused by the firewall blocking port 25 on the
smtp server.
Thanks.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:1181581014.987361.279000@.q69g2000hsb.googlegr oups.com...
> On Jun 11, 4:11 pm, "JN" <j...@.ecconsulting.com> wrote:
> Hi
> Can you ping/telnet the mail server?
> Has the server been set to exclude connections via VPNs?
> John
>

Database Mail SMTP Settings

Hi All,
The Sql server will send emails when I am connected to it on the LAN but not
when I am remote or connected via a VPN. I am using the fully qualified
hostname for the smtp server in the database mail configuration.
Here is the error message:
The mail could not be sent to the recipients because of the mail server
failure. (Sending Mail using Account 3 (2007-06-08T16:36:07). Exception
Message: Cannot send mails to mail server. (The operation has timed out.).
Thanks for your help.
JNOn Jun 11, 4:11 pm, "JN" <j...@.ecconsulting.com> wrote:
> Hi All,
> The Sql server will send emails when I am connected to it on the LAN but not
> when I am remote or connected via a VPN. I am using the fully qualified
> hostname for the smtp server in the database mail configuration.
> Here is the error message:
> The mail could not be sent to the recipients because of the mail server
> failure. (Sending Mail using Account 3 (2007-06-08T16:36:07). Exception
> Message: Cannot send mails to mail server. (The operation has timed out.).
> Thanks for your help.
> JN
Hi
Can you ping/telnet the mail server?
Has the server been set to exclude connections via VPNs?
John|||It looks like the problem is caused by the firewall blocking port 25 on the
smtp server.
Thanks.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:1181581014.987361.279000@.q69g2000hsb.googlegroups.com...
> On Jun 11, 4:11 pm, "JN" <j...@.ecconsulting.com> wrote:
>> Hi All,
>> The Sql server will send emails when I am connected to it on the LAN but
>> not
>> when I am remote or connected via a VPN. I am using the fully qualified
>> hostname for the smtp server in the database mail configuration.
>> Here is the error message:
>> The mail could not be sent to the recipients because of the mail server
>> failure. (Sending Mail using Account 3 (2007-06-08T16:36:07). Exception
>> Message: Cannot send mails to mail server. (The operation has timed
>> out.).
>> Thanks for your help.
>> JN
> Hi
> Can you ping/telnet the mail server?
> Has the server been set to exclude connections via VPNs?
> John
>

Database Mail SMTP authentication

I am trying to configure my database mail. It gives me this error when ever I try to send an email out of my domain:

The mail could not be sent to the recipients because of the mail server error.... Mailbox unavailable: The server response was: 5.7.1 unable to relay....

Any suggestions on how to fix this issues. I have read other posts here but not a definitive solution.

Thanks,

Hi Rob - You'll probably get more and better responses from another forum or newsgroup. This one is dedicated to SQL Server Notification Services, which despite the similar name, is not the same technology as Database Mail.|||

Thanks Joe,

Do you know which forum might I try to get an answer to this issue.

|||

Hi Rob. Did you ever get an answer to this question? I'm experiencing the same issues.

Thanks!

|||Relaying is not allowed at the most SMTP servers. It will have to be allowed for either an IPAdress as a source of relaying or as destination domains. These settings can be configured on the remote SMTP server. If its an external one, rather than an internal you are probably out of luck as most providers that only host mail addresses will not allow it.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

Database Mail SMTP authentication

I am trying to configure my database mail. It gives me this error when ever I try to send an email out of my domain:

The mail could not be sent to the recipients because of the mail server error.... Mailbox unavailable: The server response was: 5.7.1 unable to relay....

Any suggestions on how to fix this issues. I have read other posts here but not a definitive solution.

Thanks,

Hi Rob - You'll probably get more and better responses from another forum or newsgroup. This one is dedicated to SQL Server Notification Services, which despite the similar name, is not the same technology as Database Mail.|||

Thanks Joe,

Do you know which forum might I try to get an answer to this issue.

|||

Hi Rob. Did you ever get an answer to this question? I'm experiencing the same issues.

Thanks!

|||Relaying is not allowed at the most SMTP servers. It will have to be allowed for either an IPAdress as a source of relaying or as destination domains. These settings can be configured on the remote SMTP server. If its an external one, rather than an internal you are probably out of luck as most providers that only host mail addresses will not allow it.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

Database Mail SMTP authentication

SS 2005 Standard 64bit

I configured database mail and I suspect the SMTP authentication credentials are not being sent. Here are the two scenarios I have tried:

1) Use a local exchange server with basic authentication passing network credentials that have access to use the exchange service. I have a SS 2000 machine that is configure this way. Sending email to an address outside the domain fails with

"mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2006-08-25T14:02:23). Exception Message: Cannot send mails to mail server. (Mailbox unavailable. The server response was: 5.7.1 Unable to relay for ...."

I can send emails within the domain no matter what the credentials specified in basic authentication are, including invalid users.

2) Use a remote smtp server with basic authentication passing username (email address) and password, which fails with "The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2006-08-25T12:56:22). Exception Message: Cannot send mails to mail server. (Transaction failed. The server response was: 5.7.1 myaddress@.me.com: Sender address rejected: Access denied)."

any idears?

Hi,

I have the same problem, I can't even send emails within the domain.

Help Please!!!!

|||

You'll probably have more luck in another forum or newsgroup. This one is dedicated to SQLNS.

But for starters, try this link:

http://groups.google.com/group/microsoft.public.sqlserver.server/browse_frm/thread/fc3ca8d7d6589a0f/8c9a329972d2feeb?lnk=st&q=database+mail+sql+server+authentication&rnum=1&hl=en#8c9a329972d2feeb

HTH...

Joe

Database Mail SMTP authentication

SS 2005 Standard 64bit

I configured database mail and I suspect the SMTP authentication credentials are not being sent. Here are the two scenarios I have tried:

1) Use a local exchange server with basic authentication passing network credentials that have access to use the exchange service. I have a SS 2000 machine that is configure this way. Sending email to an address outside the domain fails with

"mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2006-08-25T14:02:23). Exception Message: Cannot send mails to mail server. (Mailbox unavailable. The server response was: 5.7.1 Unable to relay for ...."

I can send emails within the domain no matter what the credentials specified in basic authentication are, including invalid users.

2) Use a remote smtp server with basic authentication passing username (email address) and password, which fails with "The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2006-08-25T12:56:22). Exception Message: Cannot send mails to mail server. (Transaction failed. The server response was: 5.7.1 myaddress@.me.com: Sender address rejected: Access denied)."

any idears?

Hi,

I have the same problem, I can't even send emails within the domain.

Help Please!!!!

|||

You'll probably have more luck in another forum or newsgroup. This one is dedicated to SQLNS.

But for starters, try this link:

http://groups.google.com/group/microsoft.public.sqlserver.server/browse_frm/thread/fc3ca8d7d6589a0f/8c9a329972d2feeb?lnk=st&q=database+mail+sql+server+authentication&rnum=1&hl=en#8c9a329972d2feeb

HTH...

Joe

Database Mail SMTP authentication

SS 2005 Standard 64bit

I configured database mail and I suspect the SMTP authentication credentials are not being sent. Here are the two scenarios I have tried:

1) Use a local exchange server with basic authentication passing network credentials that have access to use the exchange service. I have a SS 2000 machine that is configure this way. Sending email to an address outside the domain fails with

"mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2006-08-25T14:02:23). Exception Message: Cannot send mails to mail server. (Mailbox unavailable. The server response was: 5.7.1 Unable to relay for ...."

I can send emails within the domain no matter what the credentials specified in basic authentication are, including invalid users.

2) Use a remote smtp server with basic authentication passing username (email address) and password, which fails with "The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2006-08-25T12:56:22). Exception Message: Cannot send mails to mail server. (Transaction failed. The server response was: 5.7.1 myaddress@.me.com: Sender address rejected: Access denied)."

any idears?

Hi,

I have the same problem, I can't even send emails within the domain.

Help Please!!!!

|||

You'll probably have more luck in another forum or newsgroup. This one is dedicated to SQLNS.

But for starters, try this link:

http://groups.google.com/group/microsoft.public.sqlserver.server/browse_frm/thread/fc3ca8d7d6589a0f/8c9a329972d2feeb?lnk=st&q=database+mail+sql+server+authentication&rnum=1&hl=en#8c9a329972d2feeb

HTH...

Joe

Database Mail and Sent Items folder

We are using SQL2005 Database Mail and sending emails using our Exchange
Server as the smtp server. There is an account set up in exchange that
Database Mail uses and it works great.
However, is there a way to have all emails that that account sends put into
the "Sent Items" folder for that account?
Any assistance would be greatly appreciated.
Sincerely,
Glen WolinskyHello Glen,
You may want to bcc to this account and configure rule for the account when
receing mail from itself, it routed it to sent item folder.
Or, you may want to use SQL mail which uses MAPI so that Exchange will save
sent items automatically.
Since the issue is related to Exchange, you may also ask in Exchange
newsgroup so that you may get more qualified answer.
Thanks & Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.