Cumulative Update 23 - KB5074819 - Database Mail - No longer working.

  • Hi there,

    Has anyone else had any trouble with Database Mail in Cumulative Update 23 - KB5074819?

    When we upgraded from CU 22 to CU 23, we suddenly stopped getting email alerts on two of our SQL Servers that we upgraded.  The other SQL Servers that are on CU 22, database mail continues to work successfully.

    When looking in msdb.dbo.sysmail_allitems you can see the database mail items in there with a sent_status of "unsent":

    SELECT 
    mailitem_id,
    send_request_date,
    sent_status,
    sent_date,
    recipients,
    subject,
    last_mod_date
    FROM msdb.dbo.sysmail_allitems
    WHERE send_request_date >= DATEADD(day, -3, GETDATE())
    ORDER BY send_request_date DESC;

    Using Command Prompt on the problem SQL Servers, when I execute DatabaseMail.exe I get the following error:

    Could not load file or assembly 'Microsoft.SqlServer.DatabaseMail.XEvents, Version=16.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

    Using Command Prompt on the good SQL Servers, when I execute DatabaseMail.exe, no error is thrown.

    I uninstalled CU 23 via the following process:

    01. Control Panel

    02. Programs

    03. View Installed Updates

    04. Uninstall - Hotfix 4235 for SQL Server 2022 (KB5074819) (64-bit)

    05. Reboot.

    After the reboot I tried sending a test email and it worked successfully.

    From there, I manually installed CU 23 and rebooted the SQL Server.  Again, database mail stops working with the same issue as before.

    Any ideas?

    Kind regards,

    Chris

  • Sounds like a bug to me. I'd reach out to Microsoft about it and see if there is a fix or known workaround.

    That being said, looks like someone reported this to Microsoft already:

    https://learn.microsoft.com/en-us/answers/questions/5724634/databasemail-exe-fails-after-sql-server-2022-from

    So you may just need to wait for CU 24 or a hotfix to CU23.

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

  • Magic, thanks for pointing me in the direction of that post on the Microsoft website, much appreciated =)

    We'll roll back and wait for a fix.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply