"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."
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
Related Q&A from Kevin Kline
Monitoring and Administration expert Kevin Kline discusses the obstacles of database administration when a publisher resides on a different domain. Continue Reading
Monitoring and Administration expert Kevin Kline discusses the installation of SQL Server client tools on Windows XP Pro. Continue Reading
Monitoring and Administration expert Kevin Kline discusses how to fix incorrect drive letter assignments. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.