SQL 2016 database mail not working even though I have tired many things
For some reason I am NOT able to get SQL Mail working on a particular server running SQL 2016. I can send a message from powershell no problem.
I have done the following:
When I run this query, I show all test messages in the UNSENT queue and 0 messages in the sent queue
SELECT * FROM msdb.dbo.sysmail_sentitems
SELECT * FROM msdb.dbo.sysmail_unsentite
I have done the following:
- Enabled database mail
- Checked the box for enable mail in the SQL agent
- Restarted both SQL Agent and SQL Server
- Attempted to send a test message.
- Started the SQL Browser
- Added the SQL Engine and agent account to the local admins group
When I run this query, I show all test messages in the UNSENT queue and 0 messages in the sent queue
SELECT * FROM msdb.dbo.sysmail_sentitems
SELECT * FROM msdb.dbo.sysmail_unsentite
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I had exactly the problem you've described -- all the way to the 'unsent' messages. After .net and the restart, everything worked fine. I also received all of the unsent messages that were previously unsent.
ASKER
You were correct. Once .net 3.5 was installed, all the mail came through.
ASKER
Thanks!
Excellent. Glad to have helped.
ASKER