Database Mail not working after SQL Server 2016 SP3

• Belmiro

  SSC Enthusiast

  Points: 173

  More actions

  March 17, 2022 at 2:46 pm

  #4001306

  Expensive,

  After installing SQL SERVER 2016 SP3, my DB server no longer sends emails. I have some job that notifies me and this is not happening anymore.

  I'm using SQL SERVER 2016 ENTERPRISE SP3.

  Database Mail Log error message: The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2022-03-17T11:25:47). Exception Message: Cannot send mails to mail server. (Failure sending mail.).

  The result of the SQL query below shows correct result.

  SELECT * FROM msdb.sys.service_queues WHERE name = N'ExternalMailQueue'

  SQL Agent Alert System is enabled.

  Our email account is Office 365. Testing of sending email with the account works.

  Remembering, it stopped working after I updated to SP3. Help?

• ratbak

  Ten Centuries

  Points: 1379

  More actions

  March 17, 2022 at 4:08 pm

  #4001334

  Is .NET 3.5 installed?

  Take a look at these for diagnosis/related workarounds:

  https://support.microsoft.com/en-us/topic/kb3186435-fix-sql-server-2016-database-mail-does-not-work-on-a-computer-that-does-not-have-the-net-framework-3-5-installed-or-stops-working-after-applying-sql-server-update-3480beb6-1329-74d6-0f3a-e8e3d893326c

  https://joeydantoni.com/2016/07/27/sql-server-2016-database-mail-not-working/

   

• Belmiro

  SSC Enthusiast

  Points: 173

  More actions

  March 18, 2022 at 4:57 pm

  #4001992

  Ratbak,

  Thanks for your interest in helping. I have already performed the steps above, but without success.

  I have some servers and they are all having the same problem (DB server and Reports). I don't know what to think anymore.

  Reinstalling at least 3 servers is a lot of work. Thinking of uninstalling SP3? Will I succeed?

  Thank you very much in advance!