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.
Best 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)