Troubleshooting SQL Server 2005 “No global profile is configured…”

1. Open Management Studio
2. Expand Management
3. Right click on Database Mail
4. Select Configure Database Mail
5. In the Welcome to Database Mail Configuration Wizard, click Next6. In Select Configuration Task window, select Manage Profile Security
7. In Manage Profile Security window, make sure you have a profile that is selected as default.
8. Click Finish
9. Retest

No mail send with SQL Maintenance Plan

Yesterday I setup a Maintenance plan for SQL 2005 with a notification trough mail.
This morning I checked my mailbox, but no mail from the SQL server.

After a quick look in the history from the Maintenance plan, I’ve saw the following error.

Could not generate mail report.An exception occurred while executing a Transact-SQL statement or batch.No global profile is configured. Specify a profile name in the @profile_name parameter.

Turns out that I forgot to set the default profile in the database mail.
This is how I resolved the problem.

  1. Go to Database mail
  2. Right Click  Click on Configure Database mail.
  3. Click next
  4. Select Manage Profile security
  5. Click Next
  6. Beside Profile name  by default there will be no , change to “Yes”
  7. Finish