1

I am getting a strange error randomly when i try to send emails using database mail using SQL Server.

The mail could not be sent to the recipients because of the mail server failure.Exception Message: Could not connect to mail server. (The requested name is valid, but no data of the requested type was found).

and whenever i restart SQL Server it starts working. Is there any clue or trouble shooting which i can do to resolve this error.

asked Aug 28, 2012 at 7:41

1 Answer 1

2

Sounds like a DNS issue. confirm by trying to resolve the smtp server name from a windows command prompt whenever you start getting errors again. (before you reboot the server)

testing
2711 gold badge2 silver badges10 bronze badges
answered Aug 28, 2012 at 10:11
3
  • thanks for your reply could you please do let me know it in more detail how can i resolve SMTP server name from a windows command. Commented Aug 28, 2012 at 10:46
  • in a windows command prompt type nslookup, followed by enter. then type the smtp server name exactly as you entered it in your database mail configuration and then hit enter. The DNS server should now reply with an ip adres. Commented Aug 28, 2012 at 12:03
  • how to promt it? using ping? Commented Jan 11, 2017 at 12:19

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.