I've configured Database mail, but mails are not getting sent. Checked BOL & various blogs and forums, I'm performing correct steps, using correct smtp server name & port.
DM mail log says:
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 19 (2010-10-22T07:24:21). Exception Message: Could not connect to mail server. (A connection attempt failed because the connected party did not properly
respond after a period of time, or established connection failed because connected host has failed to respond <IP_ADD>:25).
On restarting SQL Agent, log says:
 The mail system failed to initialize; check configuration settings
 Unable to start mail session (reason: Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException: Mail configuration information could not be read from the database. ---> System.Data.SqlClient.SqlException: profile name is not valid
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStre)
View Complete Post