profile name is not valid error when executing the sp send dbmail command

Question

I have a windows account with users group and trying to exec sp send dbmail but getting an error   profile name is not valid   However  when I logged in as administrator and execute the sp send dbmail  it managed to send the email so obviously the profile name does exist on the server

User · Answer

Did you enable the profile for SQL Server Agent  This a common step that is missed when creating Email profiles in DatabaseMail   Steps    Right-click on SQL Server Agent in Object Explorer  SSMS  Click on Properties Click on the Alert System tab in the left-hand navigation Enable the mail profile Set Mail System and Mail Profile Click OK Restart SQL Server Agent

User · Answer

In my case  I was moving a SProc between servers and the profile name in my TSQL code did not match the profile name on the new server    Updating TSQL profile name    New server profile name fixed the error for me

User · Answer

I got the same problem also  Here s what I did  If you re already done granting the user group the rights to use the profile name   Go to the configuration Wizard of Database Mail Tick Manage profile security On public profiles tab  check your profile name On private profiles tab  select NT AUTHORITY NETWORK SERVICE for user name and check your profile name Do  4 this time for NT AUTHORITY SYSTEM user name Click Next until Finish

User · Answer

profile name is not valid  SQLSTATE 42000   Error 14607    This happened to me after I copied job script from old SQL server to new SQL server  In SSMS  under Management  the Database Mail profile name was different in the new SQL Server  All I had to do was update the name in job script

User · Answer

You need to grant the user or group rights to use the profile   They need to be added to the msdb database and then you will see them available in the mail wizard when you are maintaining security for mail    Read up the security here   http   msdn microsoft com en-us library ms175887 aspx  See a listing of mail procedures here   http   msdn microsoft com en-us library ms177580 aspx  Example script for  TestUser  to use the profile named  General Admin Mail      USE  msdb  GO CREATE USER  TestUser  FOR LOGIN  testuser  GO USE  msdb  GO EXEC sp addrolemember N DatabaseMailUserRole   N TestUser  GO  EXECUTE msdb dbo sysmail add principalprofile sp      profile name    General Admin Mail        principal name    TestUser        is default   1

[sql-server] 'profile name is not valid' error when executing the sp_send_dbmail command

Examples related to sql-server

Examples related to sql-server-2008

Examples related to sp-send-dbmail