No global profile is configured. Specify a profile name in the @profile_name parameter

 

With Database Mail, you can get this error when you want to send mail using msdb.dbo.sp_send_dbmail. This is because none of the Database Mail Profiles are set as global profiles. You can solve the problem as follows.

Right click on Database Mail and click Configure Database Mail.

In the next screen, select “Skip this page in the future” anc click Next.

Select “Manage profile security” in the next screen as follows and click Next.

On the next screen, select the corresponding profile,then select Yes from the Default Profile section and click Next and Finish.

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *