DB Mail could not sent mail to the recipients because of the mail server failure in sql server 2012
I have tried to send database mail but the following issue occurs.
The mail could not be sent to the recipients because of the mail server failure.
(Sending Mail using Account 3 (2018-11-13T13:05:31).
Exception Message: Could not connect to mail server.
(A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond).)
I have done the few configuration as per suggestion in google search but still the same issue occurs.
Below are the steps which I have performed so far.
- I have enabled is_broker_enabled
- Enabled inbound and outbound rules for both 465 and 587 ports
Ran the following stored procedure
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Database Mail XPs', 1;
GO
RECONFIGURE
GO
sql
sql-server dbmail sqlmail edited Nov 13 '18 at 8:28
Rahul Neekhra
6001627
asked Nov 13 '18 at 8:13
VengatVengat
100110
add a comment |
I have tried to send database mail but the following issue occurs.
The mail could not be sent to the recipients because of the mail server failure.
(Sending Mail using Account 3 (2018-11-13T13:05:31).
Exception Message: Could not connect to mail server.
(A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond).)
I have done the few configuration as per suggestion in google search but still the same issue occurs.
Below are the steps which I have performed so far.
- I have enabled is_broker_enabled
- Enabled inbound and outbound rules for both 465 and 587 ports
Ran the following stored procedure
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Database Mail XPs', 1;
GO
RECONFIGURE
GO
sql
sql-server dbmail sqlmail edited Nov 13 '18 at 8:28
Rahul Neekhra
6001627
asked Nov 13 '18 at 8:13
VengatVengat
100110
This definitely won't work with windows authentication. Use Basic authentication. Then you need to ensure that your gmail account is configured to accept emails from this server. Does this help?mathaywardhill.com/2017/03/01/…
– Nick.McDermaid
Nov 13 '18 at 10:54
@Nick.McDermaid I have not face any error while troubleshoot Gmail SMTP server connection. The Telnet smtp.gmail.com prompt showed the message like "Connecting to smtp.gmail.com..." for few minutes and closed automatically.
– Vengat
Nov 13 '18 at 14:36
Unfortunately the page I linked is only half useful. It doesn't tell you what a successful telnet test looks like. Your test actually failed - it timed out. You're meant to see a screen that says 'connected'. Something like this: mailtrap.io/blog/2016-07-26-how-to-test-smtp-server . I have deleted my other comment because that page is so useless!
– Nick.McDermaid
Nov 14 '18 at 0:49
1
To reiterate: you cannot connect to gmail. The issue is at the network level. You need to investigate firewalls etc.
– Nick.McDermaid
Nov 14 '18 at 0:50
add a comment |
I have tried to send database mail but the following issue occurs.
The mail could not be sent to the recipients because of the mail server failure.
(Sending Mail using Account 3 (2018-11-13T13:05:31).
Exception Message: Could not connect to mail server.
(A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond).)
I have done the few configuration as per suggestion in google search but still the same issue occurs.
Below are the steps which I have performed so far.
- I have enabled is_broker_enabled
- Enabled inbound and outbound rules for both 465 and 587 ports
Ran the following stored procedure
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Database Mail XPs', 1;
GO
RECONFIGURE
GO
sql
sql-server dbmail sqlmail edited Nov 13 '18 at 8:28
Rahul Neekhra
6001627
asked Nov 13 '18 at 8:13
VengatVengat
100110
I have tried to send database mail but the following issue occurs.
The mail could not be sent to the recipients because of the mail server failure.
(Sending Mail using Account 3 (2018-11-13T13:05:31).
Exception Message: Could not connect to mail server.
(A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond).)
I have done the few configuration as per suggestion in google search but still the same issue occurs.
Below are the steps which I have performed so far.
- I have enabled is_broker_enabled
- Enabled inbound and outbound rules for both 465 and 587 ports
Ran the following stored procedure
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Database Mail XPs', 1;
GO
RECONFIGURE
GO
sql
sql-server dbmail sqlmail sql
sql-server dbmail sqlmail edited Nov 13 '18 at 8:28
Rahul Neekhra
6001627
asked Nov 13 '18 at 8:13
VengatVengat
100110
edited Nov 13 '18 at 8:28
Rahul Neekhra
6001627
asked Nov 13 '18 at 8:13
VengatVengat
100110
edited Nov 13 '18 at 8:28
Rahul Neekhra
6001627
edited Nov 13 '18 at 8:28
Rahul Neekhra
6001627
edited Nov 13 '18 at 8:28
Rahul Neekhra
6001627
6001627
asked Nov 13 '18 at 8:13
VengatVengat
100110
asked Nov 13 '18 at 8:13
VengatVengat
100110
asked Nov 13 '18 at 8:13
VengatVengat
100110
100110
This definitely won't work with windows authentication. Use Basic authentication. Then you need to ensure that your gmail account is configured to accept emails from this server. Does this help?mathaywardhill.com/2017/03/01/…
– Nick.McDermaid
Nov 13 '18 at 10:54
@Nick.McDermaid I have not face any error while troubleshoot Gmail SMTP server connection. The Telnet smtp.gmail.com prompt showed the message like "Connecting to smtp.gmail.com..." for few minutes and closed automatically.
– Vengat
Nov 13 '18 at 14:36
Unfortunately the page I linked is only half useful. It doesn't tell you what a successful telnet test looks like. Your test actually failed - it timed out. You're meant to see a screen that says 'connected'. Something like this: mailtrap.io/blog/2016-07-26-how-to-test-smtp-server . I have deleted my other comment because that page is so useless!
– Nick.McDermaid
Nov 14 '18 at 0:49
1
To reiterate: you cannot connect to gmail. The issue is at the network level. You need to investigate firewalls etc.
– Nick.McDermaid
Nov 14 '18 at 0:50
add a comment |
This definitely won't work with windows authentication. Use Basic authentication. Then you need to ensure that your gmail account is configured to accept emails from this server. Does this help?mathaywardhill.com/2017/03/01/…
– Nick.McDermaid
Nov 13 '18 at 10:54
@Nick.McDermaid I have not face any error while troubleshoot Gmail SMTP server connection. The Telnet smtp.gmail.com prompt showed the message like "Connecting to smtp.gmail.com..." for few minutes and closed automatically.
– Vengat
Nov 13 '18 at 14:36
Unfortunately the page I linked is only half useful. It doesn't tell you what a successful telnet test looks like. Your test actually failed - it timed out. You're meant to see a screen that says 'connected'. Something like this: mailtrap.io/blog/2016-07-26-how-to-test-smtp-server . I have deleted my other comment because that page is so useless!
– Nick.McDermaid
Nov 14 '18 at 0:49
1
To reiterate: you cannot connect to gmail. The issue is at the network level. You need to investigate firewalls etc.
– Nick.McDermaid
Nov 14 '18 at 0:50
This definitely won't work with windows authentication. Use Basic authentication. Then you need to ensure that your gmail account is configured to accept emails from this server. Does this help?mathaywardhill.com/2017/03/01/…
– Nick.McDermaid
Nov 13 '18 at 10:54
This definitely won't work with windows authentication. Use Basic authentication. Then you need to ensure that your gmail account is configured to accept emails from this server. Does this help?mathaywardhill.com/2017/03/01/…
– Nick.McDermaid
Nov 13 '18 at 10:54
@Nick.McDermaid I have not face any error while troubleshoot Gmail SMTP server connection. The Telnet smtp.gmail.com prompt showed the message like "Connecting to smtp.gmail.com..." for few minutes and closed automatically.
– Vengat
Nov 13 '18 at 14:36
@Nick.McDermaid I have not face any error while troubleshoot Gmail SMTP server connection. The Telnet smtp.gmail.com prompt showed the message like "Connecting to smtp.gmail.com..." for few minutes and closed automatically.
– Vengat
Nov 13 '18 at 14:36
Unfortunately the page I linked is only half useful. It doesn't tell you what a successful telnet test looks like. Your test actually failed - it timed out. You're meant to see a screen that says 'connected'. Something like this: mailtrap.io/blog/2016-07-26-how-to-test-smtp-server . I have deleted my other comment because that page is so useless!
– Nick.McDermaid
Nov 14 '18 at 0:49
Unfortunately the page I linked is only half useful. It doesn't tell you what a successful telnet test looks like. Your test actually failed - it timed out. You're meant to see a screen that says 'connected'. Something like this: mailtrap.io/blog/2016-07-26-how-to-test-smtp-server . I have deleted my other comment because that page is so useless!
– Nick.McDermaid
Nov 14 '18 at 0:49
1
1
To reiterate: you cannot connect to gmail. The issue is at the network level. You need to investigate firewalls etc.
– Nick.McDermaid
Nov 14 '18 at 0:50
To reiterate: you cannot connect to gmail. The issue is at the network level. You need to investigate firewalls etc.
– Nick.McDermaid
Nov 14 '18 at 0:50
add a comment |
1 Answer
1
active
oldest
votes
You can try with Basic authentication,
IN User Name: Your mail ID.
Password: Your Gmail Password.
answered Nov 13 '18 at 8:26
Bhargav J PatelBhargav J Patel
945
I have tried it, but again the same issue occurs.
– Vengat
Nov 13 '18 at 8:36
@Vengat - Pretty sure this is the right answer. I believe you'll need to turn on access for less secure apps on your Gmail account though: support.google.com/accounts/answer/6010255?hl=en
– Bridge
Nov 13 '18 at 8:38
@Bridge i have enabled that option in both sender and receiver mails.
– Vengat
Nov 13 '18 at 8:44
@Vengat Can you Try port 465 After entering Email and Password?
– Bhargav J Patel
Nov 13 '18 at 8:52
@BhargavJPatel tried those combination but same issue.
– Vengat
Nov 13 '18 at 9:35
|
show 2 more comments
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53276527%2fdb-mail-could-not-sent-mail-to-the-recipients-because-of-the-mail-server-failure%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
You can try with Basic authentication,
IN User Name: Your mail ID.
Password: Your Gmail Password.
answered Nov 13 '18 at 8:26
Bhargav J PatelBhargav J Patel
945
I have tried it, but again the same issue occurs.
– Vengat
Nov 13 '18 at 8:36
@Vengat - Pretty sure this is the right answer. I believe you'll need to turn on access for less secure apps on your Gmail account though: support.google.com/accounts/answer/6010255?hl=en
– Bridge
Nov 13 '18 at 8:38
@Bridge i have enabled that option in both sender and receiver mails.
– Vengat
Nov 13 '18 at 8:44
@Vengat Can you Try port 465 After entering Email and Password?
– Bhargav J Patel
Nov 13 '18 at 8:52
@BhargavJPatel tried those combination but same issue.
– Vengat
Nov 13 '18 at 9:35
|
show 2 more comments
You can try with Basic authentication,
IN User Name: Your mail ID.
Password: Your Gmail Password.
answered Nov 13 '18 at 8:26
Bhargav J PatelBhargav J Patel
945
I have tried it, but again the same issue occurs.
– Vengat
Nov 13 '18 at 8:36
@Vengat - Pretty sure this is the right answer. I believe you'll need to turn on access for less secure apps on your Gmail account though: support.google.com/accounts/answer/6010255?hl=en
– Bridge
Nov 13 '18 at 8:38
@Bridge i have enabled that option in both sender and receiver mails.
– Vengat
Nov 13 '18 at 8:44
@Vengat Can you Try port 465 After entering Email and Password?
– Bhargav J Patel
Nov 13 '18 at 8:52
@BhargavJPatel tried those combination but same issue.
– Vengat
Nov 13 '18 at 9:35
|
show 2 more comments
You can try with Basic authentication,
IN User Name: Your mail ID.
Password: Your Gmail Password.
answered Nov 13 '18 at 8:26
Bhargav J PatelBhargav J Patel
945
You can try with Basic authentication,
IN User Name: Your mail ID.
Password: Your Gmail Password.
answered Nov 13 '18 at 8:26
Bhargav J PatelBhargav J Patel
945
answered Nov 13 '18 at 8:26
Bhargav J PatelBhargav J Patel
945
answered Nov 13 '18 at 8:26
Bhargav J PatelBhargav J Patel
945
answered Nov 13 '18 at 8:26
Bhargav J PatelBhargav J Patel
945
945
I have tried it, but again the same issue occurs.
– Vengat
Nov 13 '18 at 8:36
@Vengat - Pretty sure this is the right answer. I believe you'll need to turn on access for less secure apps on your Gmail account though: support.google.com/accounts/answer/6010255?hl=en
– Bridge
Nov 13 '18 at 8:38
@Bridge i have enabled that option in both sender and receiver mails.
– Vengat
Nov 13 '18 at 8:44
@Vengat Can you Try port 465 After entering Email and Password?
– Bhargav J Patel
Nov 13 '18 at 8:52
@BhargavJPatel tried those combination but same issue.
– Vengat
Nov 13 '18 at 9:35
|
show 2 more comments
I have tried it, but again the same issue occurs.
– Vengat
Nov 13 '18 at 8:36
@Vengat - Pretty sure this is the right answer. I believe you'll need to turn on access for less secure apps on your Gmail account though: support.google.com/accounts/answer/6010255?hl=en
– Bridge
Nov 13 '18 at 8:38
@Bridge i have enabled that option in both sender and receiver mails.
– Vengat
Nov 13 '18 at 8:44
@Vengat Can you Try port 465 After entering Email and Password?
– Bhargav J Patel
Nov 13 '18 at 8:52
@BhargavJPatel tried those combination but same issue.
– Vengat
Nov 13 '18 at 9:35
I have tried it, but again the same issue occurs.
– Vengat
Nov 13 '18 at 8:36
I have tried it, but again the same issue occurs.
– Vengat
Nov 13 '18 at 8:36
@Vengat - Pretty sure this is the right answer. I believe you'll need to turn on access for less secure apps on your Gmail account though: support.google.com/accounts/answer/6010255?hl=en
– Bridge
Nov 13 '18 at 8:38
@Vengat - Pretty sure this is the right answer. I believe you'll need to turn on access for less secure apps on your Gmail account though: support.google.com/accounts/answer/6010255?hl=en
– Bridge
Nov 13 '18 at 8:38
@Bridge i have enabled that option in both sender and receiver mails.
– Vengat
Nov 13 '18 at 8:44
@Bridge i have enabled that option in both sender and receiver mails.
– Vengat
Nov 13 '18 at 8:44
@Vengat Can you Try port 465 After entering Email and Password?
– Bhargav J Patel
Nov 13 '18 at 8:52
@Vengat Can you Try port 465 After entering Email and Password?
– Bhargav J Patel
Nov 13 '18 at 8:52
@BhargavJPatel tried those combination but same issue.
– Vengat
Nov 13 '18 at 9:35
@BhargavJPatel tried those combination but same issue.
– Vengat
Nov 13 '18 at 9:35
|
show 2 more comments
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53276527%2fdb-mail-could-not-sent-mail-to-the-recipients-because-of-the-mail-server-failure%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
This definitely won't work with windows authentication. Use Basic authentication. Then you need to ensure that your gmail account is configured to accept emails from this server. Does this help?mathaywardhill.com/2017/03/01/…
– Nick.McDermaid
Nov 13 '18 at 10:54
@Nick.McDermaid I have not face any error while troubleshoot Gmail SMTP server connection. The Telnet smtp.gmail.com prompt showed the message like "Connecting to smtp.gmail.com..." for few minutes and closed automatically.
– Vengat
Nov 13 '18 at 14:36
Unfortunately the page I linked is only half useful. It doesn't tell you what a successful telnet test looks like. Your test actually failed - it timed out. You're meant to see a screen that says 'connected'. Something like this: mailtrap.io/blog/2016-07-26-how-to-test-smtp-server . I have deleted my other comment because that page is so useless!
– Nick.McDermaid
Nov 14 '18 at 0:49
1
To reiterate: you cannot connect to gmail. The issue is at the network level. You need to investigate firewalls etc.
– Nick.McDermaid
Nov 14 '18 at 0:50