Post reply

error:"The role 'DatabaseMailUserRole' does not exist in the current database

  • July 24, 2010 at 1:54 pm

    #225378

    I have a user in one of my databases that I wish to give permissions to send database mail.

    I have read the following articles for guidance on this topic and am unable to make headway.

    http://msdn.microsoft.com/en-us/library/ms188719.aspx

    http://msdn.microsoft.com/en-us/library/ms189879.aspx

    The above articles suggest that DatabaseMailUserRole is a built in role, yet I am getting an error that it doesn't exist. If it doesn't how do I grant permissions to the db_owner of the database in question, to send mail via Database Mail?

  • July 27, 2010 at 2:54 am

    #1198588

    This role exists in MSDB database.

    Hope this tip helps you to fix the problem.

  • June 3, 2015 at 8:12 am

    #1802633

    Hello

    I'm having the same problem.

    I don't see the DatabaseMailUserRole in my sql database.

    Is this due to the sql mail maybe not installed?

    I am able to configure it but when I send email it odes not work. No user in the role but I don't have that role.

  • September 8, 2015 at 12:03 pm

    #1825227

    Hello,

    As Suresh pointed out, this role is in the MSDB database.

    You don't assign it from each specific database, you just assign it from the MSDB database, so you won't find that role in a User Created database.

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

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