Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Database Mail Issues

Author  Topic 

ashishashish
Constraint Violating Yak Guru

408 Posts

Posted - 2012-08-28 : 03:39:03
Hi,

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.

------------------------------------------------
The answer is always no till than you don't ask.

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2012-08-28 : 06:00:18
Recently i have observed same issue on one of our production server. Deleting and recreating database mail profile fixed this issue.

--------------------------
http://connectsql.blogspot.com/
Go to Top of Page
   

- Advertisement -