0

SQL Server 2016 Enterprise Edition SP1

Database Mail was working fine with no problem until a server patching was performed. I tried to do all the troubleshooting available but still all mails got queued and no records in the log.

Finally when I checked the database mail program I didn't find the executable file in the Binn folder or any other folders!

My questions are how this happened and how to solve it ?

Improve this question
0

2 Answers 2

Reset to default
3

I certainly can't explain why any Windows patching would remove executables from your Binn folder; that sounds more like the work of "security" software or manual intervention.

In any case, there are a couple of things you can try:

  • run setup and try a repair against the SQL Server installation. Maybe start with just the shared components.
  • copy the missing files from the Binn folder of another installation that works and is the exact same edition and @@VERSION. If you don't have one of these readily available, you could probably install Evaluation Edition on your workstation or a VM. But really you should have a mirrored installation somewhere that matches production so that you can test Windows patching and any other updates there first before you "try it out" in production.
Improve this answer
0

I found this Microsoft link which mentioned that this is a bug in SQL Server 2016 SP1 CU

[https://support.microsoft.com/en-us/help/3186435/sql-server-2016-database-mail-doesn-t-work-when-net-framework-3-5]

This was resolved by installing ,net framework 3.5

Improve this answer

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.