Issue with DBMail

• richardmgreen1

  SSChampion

  Points: 10349

  More actions

  November 18, 2024 at 9:38 am

  #4485294

  Hi all

   

  We've got 3 servers with the same setup for dbmail.

  They use the same account (just with a different display name as replies are ignored) and every was working perfectly until this weekend.

  I've now only got 1 server out of the 3 that is correctly sending emails automatically.

  Server1 is running SQL2012

  Server2 is running SQL2016

  Server3 is running SQL2022 (this is the only server that's sending emails correctly)

   

  This is the error message we're getting:-

  The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 (2023-11-15T05:59:30). Exception Message: 1) Exception Information =================== Exception Type: Microsoft.SqlServer.Management.SqlIMail.MailFramework.Exceptions.BaseMailFrameworkException Message: Cannot send mails to mail server. (The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.7.0 Must issue a STARTTLS command first) Data: System.Collections.ListDictionaryInternal TargetSite: Void Send(Microsoft.SqlServer.Management.SqlIMail.MailFramework.Framework.IMessage) HelpLink: NULL Source: DatabaseMailProtocols HResult: -2146232832 StackTrace Information =================== at Microsoft.SqlServer.Management.SqlIMail.MailFramework.Smtp.SmtpMailSender.Send(IMessage msg) at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.ProfileMailSender.SendMailToAccount(Account a, IMessageSender ms, OutMailItem si) 2) Exception Information =================== Exception Type: System.Net.Mail.SmtpException StatusCode: MustIssueStartTlsFirst Message: The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.7.0 Must issue a STARTTLS command first Data: System.Collections.ListDictionaryInternal TargetSite: Void CheckResponse(System.Net.Mail.SmtpStatusCode, System.String) HelpLink: NULL Source: System HResult: -2146233088 StackTrace Information =================== at System.Net.Mail.MailCommand.CheckResponse(SmtpStatusCode statusCode, String response) at System.Net.Mail.MailCommand.Send(SmtpConnection conn, Byte[] command, MailAddress from, Boolean allowUnicode) at System.Net.Mail.SmtpTransport.SendMail(MailAddress sender, MailAddressCollection recipients, String deliveryNotify, Boolean allowUnicode, SmtpFailedRecipientException& exception) at System.Net.Mail.SmtpClient.Send(MailMessage message) at Microsoft.SqlServer.Management.SqlIMail.MailFramework.Smtp.SmtpMailSender.Send(IMessage msg). )

   

  I've checked the setups on each machine and confirmed they are identical (except the display name as noted).  I've made sure the SSL box is ticked on all 3 and the correct port number has been entered.

  I've changed the password on the sending account (just in case it had expired) and updated it on all three machines.  The SQL2022 box is still the only one that's sending emails.

   

   

  ETA:-

  According tot he DBMail logs, we're getting this error:-

  The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 10 (2024-11-18T09:19:48). Exception Message: Cannot send mails to mail server. (A call to SSPI failed, see inner exception.). )

   

  Anyone any ideas where I go next?

   

  TIA

   

  Richard

  • This topic was modified 2 hours, 11 minutes ago by  richardmgreen1. Reason: Extra info