belle’s sql musings

Troubleshooting SQL Server 2005 "No global profile is configured…"

Posted in Issues/Troubleshooting by belle on December 17, 2007

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

About these ads

4 Responses

Subscribe to comments with RSS.

  1. timo hoen said, on May 4, 2009 at 7:17 am

    thank you :)

  2. /Arthur said, on May 31, 2010 at 2:54 am

    Strange te boys in Redmond could not write this down while its so simple
    thx a lot

  3. jasper said, on June 2, 2010 at 11:26 pm

    That worked, great :)

  4. hopperFi said, on September 9, 2011 at 5:27 am

    Thanks, that solved my issue! Now why the heck wouldn’t the first profile you create automatically be considered the default? At least prompt the user if they want this to be the default profile when they first create the profile. Thanks a lot Microsoft. At least I came across this post before I spent too much time on the issue…..


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

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: