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.