Issue with Database mail

Question

Dear All,

I have SQL server 2016 SP2 installed along with latest Cumulative Update . Database mail is not working . When I am sending test mail, database mail log showing as "Activation successful" but no mail is getting delivered. Can anyone kindly assist asap.

Best Regards,
Sandy

Answer 1

Have you configured Database mail yet?
Configure Database Mail

Sending test mail will not work until this is done.

Hope that helps,

---

Phil Streiff, MCDBA, MCITP, MCSA

Answer 2

Hi Phil,

I have configured database mail and then only tried sending test email . Database mail log is showing "Activation Successful" but mail is not getting delivered.  I have SQL server 2016 with SP2 and latest CU installed .

Please assist.

Best Regards,
Sandy

Answer 3

Hi,

In these situations, sometimes the SQL service restart helps.

what is the result of the following command sysmail_help_queue_sp:

EXEC msdb.dbo.sysmail_help_queue_sp @queue_type = 'mail';

Could you please check that .net Framework 3.5 has been installed.

---

Avis de non-responsabilité:
Mon opinion ne peut pas coïncider avec la position officielle de Microsoft.

Bien cordialement, Andrei ...

MCP

Answer 4

Hi,

EXEC msdb.dbo.sysmail_help_queue_sp @queue_type = 'mail';

State is showing as Inactive .

I will install .Net Framework 3.5 and restart the SQL services and keep you posted .

Best Regards,
Sandy

Answer 5

Hi All,

I am now getting the message " Could not connect to mail server. (No connection could be made because the target machine actively refused " in my database mail log , please help.

Best Regards,
Sandy

Answer 6

It happened after what kind of manipulation? Could provide this log?

Make sure your smtp server doesn't require any kind of extra authentication such as ssl. 

---

Avis de non-responsabilité:
Mon opinion ne peut pas coïncider avec la position officielle de Microsoft.

Bien cordialement, Andrei ...

MCP

Answer 7

Ensure that the smtp service is started.

---

Avis de non-responsabilité:
Mon opinion ne peut pas coïncider avec la position officielle de Microsoft.

Bien cordialement, Andrei ...

MCP

Answer 8

It got resolved, thanks all for your help.

Answer 9

Sandy,

Could you tell me please the details, how did you solve the problem?

P.S. Perhaps your solution will help other users to solve similar problems.

Thank you.

---

Avis de non-responsabilité:
Mon opinion ne peut pas coïncider avec la position officielle de Microsoft.

Bien cordialement, Andrei ...

MCP

Answer 10

Hi All,

Sure Initially Mail profile was not set to public , I changed it to public , also there are some antivirus programs installed and so I take help from Infosec team to allow SQL server , that's it .

Best Regards,
Sandy