DatabaseMail

Question

Post reply

DatabaseMail

ramana3327

SSCoach

Points: 19722
More actions
December 14, 2013 at 2:15 pm

#287483

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

Viewing 9 posts - 1 through 8 (of 8 total)

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

LutzM SSC Guru Points: 107049 More actions · Answer 1

"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]

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 2

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)

ramana3327 SSCoach Points: 19722 More actions · Answer 3

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.

ramana3327 SSCoach Points: 19722 More actions · Answer 4

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.

Lowell SSC Guru Points: 323518 More actions · Answer 5

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!

ramana3327 SSCoach Points: 19722 More actions · Answer 6

I took the first option use the windows authentication

ramana3327 SSCoach Points: 19722 More actions · Answer 7

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

Lowell SSC Guru Points: 323518 More actions · Answer 8

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!