Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Troubleshooting Database Mail: Profile not valid

This topic describes how to troubleshoot an error message stating that the profile is not valid.

There are two possible causes for this message. Either the profile specified does not exist, or the user running sp_send_dbmail (Transact-SQL) does not have permission to access the profile.

To check permissions for a profile, run the stored procedure sysmail_help_principalprofile_sp (Transact-SQL) with name of the profile. Use the stored procedure sysmail_add_principalprofile_sp (Transact-SQL) or the Database Mail Configuration Wizard to grant permission for a msdb user or group to access a profile.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft