Life with SQL server

Create a mail profile first using 1. Management - > Database Mail object 2. Create the desired user under Security -> Logins object Run the following permission script use msdb exec sp_addrolemember 'DatabaseMailUserRole' , 'sqlUser' EXECUTE msdb . dbo . sysmail_add_principalprofile_sp @ principal_name = 'sqlUser' , @ profile_name = 'sqlMailProfileName' , @ is_default = 0