Database Mail Stopping

Question

Currently having issues on two separate SQL 2022 servers with Database Mail.

The service won't auto start up as it should do - I can manually start it and it seems to run for just less than an hour or so and then shuts down and won't restart itself again.

ERROR CODE:

The description for Event ID 0 from source DatabaseMail cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:

Database Engine Instance=servername;Mail PID=14004;Error Message:The connection is not open.

The message resource is present but the message was not found in the message table

Answer 1

Have you checked this old thread ? :

I got this error after creating an event source under the Application Log from the command line using "EventCreate". This command creates a new key under: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application If you look at the Key that's been created (e.g. SourceTest) there will be a string value calledEventMessageFile, which for me was set to %SystemRoot%\System32\EventCreate.exe. Change this to c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\EventLogMessages.dll Delete theCustomSource and TypesSupported values. This should stop the "The description for Event ID...." message.

Answer 2

Hi @Rabia Kurnaz ,

Please use select @@version to check your SQL server version and share the result to us.

Please use the sysmail_event_log view to check for any errors or messages related to the Database Mail service. 

SELECT * FROM msdb.dbo.sysmail_event_log ORDER BY log_date DESC;

Please ensure that your SQL Server instance has enough resources (CPU, memory) to handle the Database Mail service. Resource constraints can sometimes cause services to stop unexpectedly.

Please ensure that there are no scheduled jobs or maintenance tasks that might be stopping the Database Mail service.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it.