Post reply

sp_send_dbmail - permissions error

  • December 15, 2010 at 10:27 am

    #232099

    I am getting the following error for all users except sysadmin. I did following troubleshooting steps so far

    1.GRant permission to the proc

    2.added user to 'DatabaseMailUserRole'

    3. Enabled Mails XP's

    but still getting the same error. any other steps to take?

    EXECUTE permission denied on object 'sp_send_dbmail', database 'msdb',

    schema 'dbo'.

  • December 15, 2010 at 12:09 pm

    #1263063

    Is this a SQL login? Any chance it's just a mismatched SID issue?

  • December 15, 2010 at 12:40 pm

    #1263087

    No, it is a windows login.

  • December 16, 2010 at 7:56 am

    #1263469

    any idea why this would happen?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply