SQL Server 2016 - Database Mail doesn't work without .NET 3.5
In installed SQL Server Standard on Windows Server 2012 R2 (VM Ware 5.5 virtual machine).
- DB engine
- SQL Server Replication.
After creating all my jobs and alerts I realized that Database Mail (properly configured) doesn't work. I checked everything... a lot of times...
Messages still remained in "unsent" status.
Database Mail Log empty.
EXEC msdb.dbo.sysmail_help_queue_sp @queue_type = 'mail';
queue_type length state
mail 295 RECEIVES_OCCURRING
Finally I decided to install SQL Server 2014, during setup it asked me to install .NET Framework 3.5. After I added required roles in Server Manage (before installing SQL Server 2014), I checked Database Mail - it works..ów)