Database Mail Reply To account

  • Jack Corbett

    SSC Guru

    Points: 184360

    I have setup database mail and can send email using it. I added a reply to account to the DBMail account and assumed when I reply to the SQL generated email I would see the reply go to the Reply To account. But, alas, it only is returned to the sending email account. When I look at sp_send_dbmail, I do not see a Reply To parameter. Having found this I am forced to assume that MS never actually implemented the Reply To functionality. Has anyone else tried this? If you have, had you had success?


    Jack Corbett Consultant Straight Path Solutions Dont let the good be the enemy of the best. -- Paul FlemingAt best you can say that one job may be more secure than another, but total job security is an illusion. -- Rod at workCheck out these links on how to get faster and more accurate answers: Forum Etiquette: How to post data/code on a forum to get the best helpNeed an Answer? Actually, No ... You Need a QuestionHow to Post Performance Problems[/url]Crosstabs and Pivots or How to turn rows into columns Part 1[/url][url url=http://www.sqlservercent

  • Todd Engen

    SSCrazy Eights

    Points: 9869

    Can only confirm what you're seeing.

    Both sp_send_dbmail and the SQL Agent didn't appear to use of the "Reply e-mail" even though it was configured.

    From looking at a packet capture of the SMTP traffic, 'Reply-To:' was nowhere to be found in the message body.

    This issue at connect.microsoft.com appears similar and is still open for feedback:

    https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=264498

  • Jack Corbett

    SSC Guru

    Points: 184360

    Thanks for the confirmation Todd. I did a quick google and did not find anything so I made this quick post hoping someone would have a little more information. I have only been working with 2005 for a few months so I thought someone would have seen this.


    Jack Corbett Consultant Straight Path Solutions Dont let the good be the enemy of the best. -- Paul FlemingAt best you can say that one job may be more secure than another, but total job security is an illusion. -- Rod at workCheck out these links on how to get faster and more accurate answers: Forum Etiquette: How to post data/code on a forum to get the best helpNeed an Answer? Actually, No ... You Need a QuestionHow to Post Performance Problems[/url]Crosstabs and Pivots or How to turn rows into columns Part 1[/url][url url=http://www.sqlservercent

  • Joe Clifford

    SSCrazy Eights

    Points: 8739

    You aren't by chance using Exchange server as your SMTP server are you? Exchange will ignore/rewrite reply-to/from addresses if the reply-to/from address you're using is not on the list of valid email addresses of the sending account - dependent on relay-settings as well.

    Joe

  • Lynn Pettis

    SSC Guru

    Points: 442118

    Interesting. I have a reply-to address setup for my Database Mail profiles and it seems to work just fine. I'd be interested in hear what you find in regard to this problem.

    😎

  • Jack Corbett

    SSC Guru

    Points: 184360

    Joe Clifford (3/20/2008)


    You aren't by chance using Exchange server as your SMTP server are you? Exchange will ignore/rewrite reply-to/from addresses if the reply-to/from address you're using is not on the list of valid email addresses of the sending account - dependent on relay-settings as well.

    Joe

    Yes we are using Exchange. I'll try it using gmail.


    Jack Corbett Consultant Straight Path Solutions Dont let the good be the enemy of the best. -- Paul FlemingAt best you can say that one job may be more secure than another, but total job security is an illusion. -- Rod at workCheck out these links on how to get faster and more accurate answers: Forum Etiquette: How to post data/code on a forum to get the best helpNeed an Answer? Actually, No ... You Need a QuestionHow to Post Performance Problems[/url]Crosstabs and Pivots or How to turn rows into columns Part 1[/url][url url=http://www.sqlservercent

  • Jack Corbett

    SSC Guru

    Points: 184360

    A quick update. I switched to using gmail as the smtp server and still no joy on the Reply To setting.

    Lynn,

    What mail server are using for SMTP? I am on SQL 2005 64-bit SP2. Any differences with your setup? I have tried our local exchange server and gmail now.


    Jack Corbett Consultant Straight Path Solutions Dont let the good be the enemy of the best. -- Paul FlemingAt best you can say that one job may be more secure than another, but total job security is an illusion. -- Rod at workCheck out these links on how to get faster and more accurate answers: Forum Etiquette: How to post data/code on a forum to get the best helpNeed an Answer? Actually, No ... You Need a QuestionHow to Post Performance Problems[/url]Crosstabs and Pivots or How to turn rows into columns Part 1[/url][url url=http://www.sqlservercent

  • Adam Bean

    One Orange Chip

    Points: 26440

    My reply to works just fine ... curious to hear what you find out ... Anything you'd like me to find out from our exchange guy?

    ---
    SQLSlayer
    Making SQL do what we want it to do.

  • Jack Corbett

    SSC Guru

    Points: 184360

    Todd Engen (3/19/2008)


    Can only confirm what you're seeing.

    Both sp_send_dbmail and the SQL Agent didn't appear to use of the "Reply e-mail" even though it was configured.

    From looking at a packet capture of the SMTP traffic, 'Reply-To:' was nowhere to be found in the message body.

    This issue at connect.microsoft.com appears similar and is still open for feedback:

    https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=264498

    Adam,

    Did you check out the link Todd posted? I did and it seems that it is a bug. Are you using 32 or 64-bit SQL? I am using 64-bit. I will try it on the 32-bit version I am running on my desktop to see if that may be the issue.


    Jack Corbett Consultant Straight Path Solutions Dont let the good be the enemy of the best. -- Paul FlemingAt best you can say that one job may be more secure than another, but total job security is an illusion. -- Rod at workCheck out these links on how to get faster and more accurate answers: Forum Etiquette: How to post data/code on a forum to get the best helpNeed an Answer? Actually, No ... You Need a QuestionHow to Post Performance Problems[/url]Crosstabs and Pivots or How to turn rows into columns Part 1[/url][url url=http://www.sqlservercent

  • Adam Bean

    One Orange Chip

    Points: 26440

    Well, I'll be damned ... I wasn't looking at it properly due to the email address being a group ...

    Anyways, both in x86 and x64, I changed the replyto email, and when I reply, it is in fact using the sender in the reply to.

    Just tried it in the latest CTP of 2008, and the same problem resides. So now more than ever I'm curious to as what is causing this.

    ---
    SQLSlayer
    Making SQL do what we want it to do.

  • Jack Corbett

    SSC Guru

    Points: 184360

    Adam Bean (3/21/2008)


    Well, I'll be damned ... I wasn't looking at it properly due to the email address being a group ...

    Anyways, both in x86 and x64, I changed the replyto email, and when I reply, it is in fact using the sender in the reply to.

    Just tried it in the latest CTP of 2008, and the same problem resides. So now more than ever I'm curious to as what is causing this.

    Great! I just assumed it was a something not-quite finished in 2005 and they forgot to remove the reply to filed from the wizard and the account sp and it would be there in 2008. I posted on my blog about this and called it the The Ghost of Reply To in Sql Server 2005 Database Mail.

    Thanks for testing it out. Pretty interesting.


    Jack Corbett Consultant Straight Path Solutions Dont let the good be the enemy of the best. -- Paul FlemingAt best you can say that one job may be more secure than another, but total job security is an illusion. -- Rod at workCheck out these links on how to get faster and more accurate answers: Forum Etiquette: How to post data/code on a forum to get the best helpNeed an Answer? Actually, No ... You Need a QuestionHow to Post Performance Problems[/url]Crosstabs and Pivots or How to turn rows into columns Part 1[/url][url url=http://www.sqlservercent

  • Lynn Pettis

    SSC Guru

    Points: 442118

    Jack Corbett (3/21/2008)


    A quick update. I switched to using gmail as the smtp server and still no joy on the Reply To setting.

    Lynn,

    What mail server are using for SMTP? I am on SQL 2005 64-bit SP2. Any differences with your setup? I have tried our local exchange server and gmail now.

    We are using Exchange as our SMTP server.

    😎

  • Lynn Pettis

    SSC Guru

    Points: 442118

    Okay, I used sp_send_dbmail to send an email to one of my coworkers, who replied to it, and it went just where I expected it to go, me. So I know the the reply to part of my database mail setup is working correctly.

    Perhaps we should compare how things are setup.

    😎

  • Lynn Pettis

    SSC Guru

    Points: 442118

    I will be leaving work shortly. I have a school event for my youngest followed with my hitting the High School pitch (got a JV game to officiate!).

    Next week I will be in an on-site SQL Server 2005 training class, but i'll check back when I can. Also, tonight I can copy down my setup and post it if that will help.

    😎

  • Jack Corbett

    SSC Guru

    Points: 184360

    Have fun officiating. I used to that quite often as well. I thought DBA's were supposed to be geeks!

    If you could post the setup I'd appreciate it. I will be looking into more on Monday as well. I actually had today off for Good Friday.;)


    Jack Corbett Consultant Straight Path Solutions Dont let the good be the enemy of the best. -- Paul FlemingAt best you can say that one job may be more secure than another, but total job security is an illusion. -- Rod at workCheck out these links on how to get faster and more accurate answers: Forum Etiquette: How to post data/code on a forum to get the best helpNeed an Answer? Actually, No ... You Need a QuestionHow to Post Performance Problems[/url]Crosstabs and Pivots or How to turn rows into columns Part 1[/url][url url=http://www.sqlservercent

Viewing 15 posts - 1 through 15 (of 36 total)

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