Login or Sign Up to become a member!
LessThanDot Sit Logo

LessThanDot

Data Management

Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.

LTD Social Sitings

Lessthandot twitter Lessthandot Linkedin Lessthandot friendfeed Lessthandot facebook Lessthandot rss

Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.

Your profile

    Search

    XML Feeds

    Google Ads

    « Mirroring Hands On with Developer EditionSQL Connections Suburban Chicago Wrap Up »
    comments

    So today I was working on setting up DB Mail on our new dev box (MS SQL 2008), but I ran into a little snag. Emails were sending fine to my email address, but all attempts to email our developers distribution group failed to be delivered. These was no sign on SQL Server that the email wasn't delivered, it just didn't appear in my inbox.

    I got to talking with my network admin, and he said that unauthenticated emails are blocked on distributions groups in the company (spam reasons). This got me to thinking. I had set up the profile on the server to use anonymous authentication!

    old profile settings

    I changed the settings to use the Database Engine Service Credential to authenticate the email. Still no dice.

    new profile settings

    I talked to the admin again, and he had an aha! moment. Apparently in our company distribution groups are set so that they only receive email from anyone in the all-company distribution group. He changed the settings to be From authenticated users only and From everyone.

    new distribution group settings

    It worked! And he tested by sending an external email to the distribution group and the email was blocked. Success! Now I can email my distribution group internally and external emails are still blocked.

    About the Author

    I have an A.S. in Computer Programming. I am currently a Database Developer (April 2008-Present) for a development group at a contract research lab, where we build in-house applications using Microsoft SQL Server (2005 and 2008) and ASP.Net 3.5. I have a part-time job (April 2007-Present) as a dba/db developer/web developer/designer. I use: SQL Server 2005/08/R2, HTML, CSS, PHP, and Java Script. Penguins are awesome, but I'm not a linux person. If you have any questions feel free to email me at dforck@gmail.com
    Social SitingsTwitterFacebookLTD RSS Feed
    Instapaper

    1 comment

    Comment from: steve t [Visitor]
    steve t I'm facing a similiar/same problem and I've checked my settings and the email guys sent me a screenshot which looks exactly like yours, but I still get a permission denied. Any thoughts?
    12/06/10 @ 15:41

    Leave a comment


    Your email address will not be revealed on this site.

    Your URL will be displayed.
    (Line breaks become <br />)
    (Name, email & website)
    (Allow users to contact you through a message form (your email will not be revealed.)