The Database Mail Configuration Wizard provides a convenient way to manage Database Mail configuration objects and enables Database Mail, if needed. To use this wizard, you must be a member of the sysadmin fixed server role. To send Database Mail, you must be a member of the DatabaseMailUserRole database role in the msdb database.

1. From Object Explorer, connect to an instance of SQL Server.

2. Expand Management, right-click Database Mail, and select Configure Database Mail.

3. Choose the Set up Database Mail option to set up Database Mail for the first time.

   Note:
   Enabling SQL Server Service Broker in any database requires a database lock. If Service Broker was deactivated in msdb, to enable Database Mail, first stop SQL Server Agent so that Service Broker can obtain the necessary lock.

4. Choose one of the other options for specific maintenance tasks:

   • Manage Database Mail accounts and profiles.
     
   • Manage profile security.
     
   • View or change system parameters.
     

 See Also

Reference

Database Mail Configuration Stored Procedures

Help and Information

Getting SQL Server 2008 Assistance