• pramodkumar.singh 17457 (9/3/2015)


    Hello,

    I have received the same error like below.

    The EXECUTE permission was denied on the object 'xp_sysmail_activate', database 'mssqlsystemresource', schema 'sys'.'

    I have resolved it on my machine, please check the below things.

    Please check the owner of dbo in msdb database.

    Verify if the login mapped to dbo user is a member of sysadmin fixed server.

    If not add the login to sysadmin role and try sending the test mail again.

    Check for any error in the application log and view database mail log.

    Thanks,

    Pramodkumar.

    7 year old thread.