  Setting up SQL Server to send automatic email notifications was a nice little challenge for me. Things that I discovered along the way 1. You must have Outlook installed on the Server as default email client, 2. If you use Outlook 2002, the client app must be running to send emails, 3. Your SQL services must start with a Windows authenticated account These are the links that helped me urlLink Common SQL Mail Problems urlLink How to Configure SQL Mail urlLink FAQ - SQL Server - SQL Mail 
