SQL Mail troubleshooting
A common SQL Mail error is addressed by monitoring and administration expert Kevin Kline.
"Error 22022: SQL ServerAgent Error: The SQL ServerAgent mail session is not running; check the mail profile and/or the SQL Server Agent service startup account in the SQLServerAgent Properties dialog."
Any suggestions?
SQLMail is troublesome and the reason for many support calls.
Your biggest issue, in my opinion, is the security context that SQL Server Agent is running under. Test SQLMail using the Windows user ID that the SQL Server Agent runs under.
You must first provide SQLMail with the Outlook mail profile used to test the mail client configuration. To do so, go to Enterprise Manger, then Support Services folder, right click SQL Mail and choose Properties.
You must then provide the mail profile to SQL Server Agent. To do so, go to Enterprise Manager, then Management folder, right click SQL Agent and choose Properties.
Do you have comments on this Ask the Expert Q&A? Let us know.
Dig Deeper on Microsoft SQL Server Installation
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our SQL Server experts
View all SQL Server questions and answers
Start the conversation
0 comments