Navigation

Search

Site Content

Syndicate

Home | SQL Server 2005 DBA

SQL 2005 Database Mail Troubleshooting

Mon, 12/31/2007 - 18:21 |  sqlguychuck
Your rating: None Average: 4.4 (5 votes)

After deploying SQL 2005 SP2 on 64bit Active-Active cluster, dbmail still had issues emailing. On one of the servers, it flat out doesn't work. Running a test mail works, so my profile was setup correctly, but SQL Agent jobs were not being sent. Error I found in SQL Agent Logs: [264] An attempt was made to send an email when no email session has been established. I found after a bit of research that my SQL Agent Alert System didn't have the Enable Mail Profile option box selected. SP2 install must have done this... Just right click SQL Agent in Management Studio and select properties|Alert System page. You will need to restart SQL Agent for this to take effect.

 

Share this  |  Login or register to post comments |  Tags: SQL 2005 DBA

Contact Us | Terms of Use | Trademarks | Privacy Statement
Copyright © 2010 SQLWebpedia. All Rights Reserved.

Creative Commons License
This work by Chuck Lathrope is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 United States License.

Disclaimer for all content: No warranty is expressed or implied by the authors' or owner's of this website or content linked externally. Use at your own risk.