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.