Friday, January 15, 2010

Simplifying Database Mail

Easy steps to configure this:

1. Add the SQL Server Agent service account to the msdb users and then to the DatabaseMailUserRole.

2. Configure the Database Mail to create a default SQL Mail profile - keeping 'Anonymous Authentication' for the SMTP account.

3, Map this SMTP profile to the SQL Server Agent - Properties -> Alert System.

4. Restart Agent.