'profile name is not valid' error when executing the sp_send_dbmail command

user_384080 0
Viewed 134926

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.

sp-send-dbmail sql-server-2008 sql-server
6 Answers

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_21811880

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_15412240

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_5421160

In case you are using SQL Managed Instance (SQL MI) as I was, the answer is that you need to create a Database Mail Profile called "AzureManagedInstance_dbmail_profile" which is automatically used by its SQL Server Agent. This works for sending job completion notifications.

user_3838070
Related