DatabaseMail

  • I am trying to configure database mail through my gmail. Before it works fine to me but now when I am sending test mail it is not working. The port no I am using is 587. I am using server name

    smtp.gmail.com

  • "It's not working" doesn't really help us to help you in any way.

    What's the exact error message you receive?



    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • ramana3327 (12/14/2013)


    I am trying to configure database mail through my gmail. Before it works fine to me but now when I am sending test mail it is not working. The port no I am using is 587. I am using server name

    smtp.gmail.com

    For that question, the answer would be to find out what changed. If it was working before and now it doesn't, then something changed. Find that and you'll have your answer.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • Actually, I install SQLServer2008R2 developer edition. At that time I configured database mail it works fine to me. After I uninstalled and and re-install the instance again. But this time when I tried to configured the database mail again, the mail is not going. When I see database mail log there is the following message

    The mail couldn't send to the recipients because of the mail server failed. Can't send mails to mail server. The SMTP server requires a secure connection or the client was not authenticated. The server response was 5.5.1. Authentication required.

  • Actually, I install SQLServer2008R2 developer edition. At that time I configured database mail it works fine to me. After I uninstalled and and re-install the instance again. But this time when I tried to configured the database mail again, the mail is not going. When I see database mail log there is the following message

    The mail couldn't send to the recipients because of the mail server failed. Can't send mails to mail server. The SMTP server requires a secure connection or the client was not authenticated. The server response was 5.5.1. Authentication required.

  • 5.5.1 implies you did not set up your db mail to send the basic authentication to have the username and password:

    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!

  • I took the first option use the windows authentication

  • If I took Basic authentication and gave gmail account as user name & Gmail account password in the password then it is working fine but if I use windows authentication it is not working. so that means the remaining two options doesn't work.

    Instead of gmail account if you took yahoo account shall we use the same port number?

    Thanks

  • ramana3327 (12/19/2013)


    If I took Basic authentication and gave gmail account as user name & Gmail account password in the password then it is working fine but if I use windows authentication it is not working. so that means the remaining two options doesn't work.

    Instead of gmail account if you took yahoo account shall we use the same port number?

    Thanks[/quotemail settings depend on your server.

    for windows authentication the mail server would be inside your lan -an exchange server.forexample.

    to allow anonymous authentication typically thenmail server adds your sql servers IP to its white list and passes any mailnat all coming from that macchine.

    Most smtp servers (all?!) SUPPORT basic authentication so thats thenmost common.

    Not sure on the mail settings for yahoo mail youd have to goofle it.

    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 9 posts - 1 through 8 (of 8 total)

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