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

Error in logs:

Executing the query "EXECUTE msdb.dbo.sp_notify_operator @name=N'ds',@body=N'deleted files'" failed with the following error: "No global profile is configured. Specify a profile name in the @profile_name parameter.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

This means the Default Mail Profile in the Profile Security Section is not set.
To fix:
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 Next
6. 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.
Select a default profile in Manage Profile Security Window

8. Click Finish
9. Retest

Advertisements

One comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s