Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.

share|improve this question
add comment

1 Answer

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)

share|improve this answer
    
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. –  Ashish Aug 28 '12 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. –  Edward Dortland Aug 28 '12 at 12:03
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.