SQL user test mail not working?

• SQL Galaxy

  One Orange Chip

  Points: 29472

  More actions

  October 8, 2012 at 3:27 am

  #269030

  Hi,

  Mail session working fine with sysadmin user sa, etc

  after connect SQL user test mail seesion is not working.

  I try to add username as blow is not hope.

  exec msdb..sp_addrolemember @rolename = 'DatabaseMailUserRole'

  ,@membername = '<myuser>';

  an error occurred:Msg 15014, Level 16, State 1, Procedure sp_addrolemember, Line 36

  The role 'DatabaseMailUserRole' does not exist in the current database.

• Suresh B.

  SSC-Insane

  Points: 22986

  More actions

  October 8, 2012 at 3:55 am

  #1546625

  USE MSDB before running the above...

  use msdb;

  go

  exec msdb..sp_addrolemember @rolename = 'DatabaseMailUserRole'

  ,@membername = '<myuser>';