+ Reply to Thread
Results 1 to 4 of 4

EXECUTE permission denied on object 'sp_send_dbmail', database 'msdb', schema 'dbo'.

  1. EXECUTE permission denied on object 'sp_send_dbmail', database 'msdb', schema 'dbo'.

    Im getting this error when trying to execute my stored procedure that has
    code within to email

    EXECUTE permission denied on object 'sp_send_dbmail', database 'msdb',
    schema 'dbo'.

    If i execute the procedure manually within management studio it works fine,
    email is sent and record is updated..

    We have other pages within our site that use similar procedures and they all
    work fine.. just dont know why this one isnt..

    here is the code within the procedure.. keeping in mind that it works if
    manually executed and does NOT if executed from the webpage.

    -- send the mail

    EXEC msdb.dbo.sp_send_dbmail

    @profile_name = 'CESync'

    ,@recipients = 'dchaatidgedotcom'

    ,@body = @tableHTML

    ,@subject = 'Credit Memo To Back Out'

    ,@body_format = 'HTML' ;


    --
    ASP, SQL2005, DW8 VBScript, Visual Studio 2005, Visual Studio 2008



  2. RE: EXECUTE permission denied on object 'sp_send_dbmail', database 'ms

    > If i execute the procedure manually within management studio it works fine,
    > email is sent and record is updated..


    Did you use the same login (to log into the SQL instance) that the web
    server was using?

    Linchi

    "Daniel" wrote:

    > Im getting this error when trying to execute my stored procedure that has
    > code within to email
    >
    > EXECUTE permission denied on object 'sp_send_dbmail', database 'msdb',
    > schema 'dbo'.
    >
    > If i execute the procedure manually within management studio it works fine,
    > email is sent and record is updated..
    >
    > We have other pages within our site that use similar procedures and they all
    > work fine.. just dont know why this one isnt..
    >
    > here is the code within the procedure.. keeping in mind that it works if
    > manually executed and does NOT if executed from the webpage.
    >
    > -- send the mail
    >
    > EXEC msdb.dbo.sp_send_dbmail
    >
    > @profile_name = 'CESync'
    >
    > ,@recipients = 'dchaatidgedotcom'
    >
    > ,@body = @tableHTML
    >
    > ,@subject = 'Credit Memo To Back Out'
    >
    > ,@body_format = 'HTML' ;
    >
    >
    > --
    > ASP, SQL2005, DW8 VBScript, Visual Studio 2005, Visual Studio 2008
    >
    >
    >


  3. Re: EXECUTE permission denied on object 'sp_send_dbmail', database 'ms

    No..

    the problem i cant figure out is why the same exact code i posted below i
    have in 2 other procedures within the same database and the others work
    fine.. but this one is having issues..
    all 3 execute fine manually.. and 2 of the 3 work fine from the webpages..

    so dont think its login issue.. im sure something has happened to
    permissions.. we work on virtual machines for our development.. and have
    found that there are times that the VM is moved to another server and things
    changed outside of SQL that have caused problems before.. but this seems
    internal to SQL..

    how can i check the execute permissions of the sp_send_dbmail??

    EXECUTE permission denied on object 'sp_send_dbmail', database 'msdb',
    schema 'dbo'.

    --
    ASP, SQL2005, DW8 VBScript, Visual Studio 2005, Visual Studio 2008
    "Linchi Shea" wrote in message
    news:723FF1B0-A11C-4164-9A2C-234ABEC9C243atmicrosoftdotcom...
    >> If i execute the procedure manually within management studio it works
    >> fine,
    >> email is sent and record is updated..

    >
    > Did you use the same login (to log into the SQL instance) that the web
    > server was using?
    >
    > Linchi
    >
    > "Daniel" wrote:
    >
    >> Im getting this error when trying to execute my stored procedure that has
    >> code within to email
    >>
    >> EXECUTE permission denied on object 'sp_send_dbmail', database 'msdb',
    >> schema 'dbo'.
    >>
    >> If i execute the procedure manually within management studio it works
    >> fine,
    >> email is sent and record is updated..
    >>
    >> We have other pages within our site that use similar procedures and they
    >> all
    >> work fine.. just dont know why this one isnt..
    >>
    >> here is the code within the procedure.. keeping in mind that it works if
    >> manually executed and does NOT if executed from the webpage.
    >>
    >> -- send the mail
    >>
    >> EXEC msdb.dbo.sp_send_dbmail
    >>
    >> @profile_name = 'CESync'
    >>
    >> ,@recipients = 'dchaatidgedotcom'
    >>
    >> ,@body = @tableHTML
    >>
    >> ,@subject = 'Credit Memo To Back Out'
    >>
    >> ,@body_format = 'HTML' ;
    >>
    >>
    >> --
    >> ASP, SQL2005, DW8 VBScript, Visual Studio 2005, Visual Studio 2008
    >>
    >>
    >>




  4. Re: EXECUTE permission denied on object 'sp_send_dbmail', database

    Try adding the DatabaseMailUserRole role to your web user (not the user
    you're logging into ssms with).

    "Daniel" wrote:

    > No..
    >
    > the problem i cant figure out is why the same exact code i posted below i
    > have in 2 other procedures within the same database and the others work
    > fine.. but this one is having issues..
    > all 3 execute fine manually.. and 2 of the 3 work fine from the webpages..
    >
    > so dont think its login issue.. im sure something has happened to
    > permissions.. we work on virtual machines for our development.. and have
    > found that there are times that the VM is moved to another server and things
    > changed outside of SQL that have caused problems before.. but this seems
    > internal to SQL..
    >
    > how can i check the execute permissions of the sp_send_dbmail??
    >
    > EXECUTE permission denied on object 'sp_send_dbmail', database 'msdb',
    > schema 'dbo'.
    >
    > --
    > ASP, SQL2005, DW8 VBScript, Visual Studio 2005, Visual Studio 2008
    > "Linchi Shea" wrote in message
    > news:723FF1B0-A11C-4164-9A2C-234ABEC9C243atmicrosoftdotcom...
    > >> If i execute the procedure manually within management studio it works
    > >> fine,
    > >> email is sent and record is updated..

    > >
    > > Did you use the same login (to log into the SQL instance) that the web
    > > server was using?
    > >
    > > Linchi
    > >
    > > "Daniel" wrote:
    > >
    > >> Im getting this error when trying to execute my stored procedure that has
    > >> code within to email
    > >>
    > >> EXECUTE permission denied on object 'sp_send_dbmail', database 'msdb',
    > >> schema 'dbo'.
    > >>
    > >> If i execute the procedure manually within management studio it works
    > >> fine,
    > >> email is sent and record is updated..
    > >>
    > >> We have other pages within our site that use similar procedures and they
    > >> all
    > >> work fine.. just dont know why this one isnt..
    > >>
    > >> here is the code within the procedure.. keeping in mind that it works if
    > >> manually executed and does NOT if executed from the webpage.
    > >>
    > >> -- send the mail
    > >>
    > >> EXEC msdb.dbo.sp_send_dbmail
    > >>
    > >> @profile_name = 'CESync'
    > >>
    > >> ,@recipients = 'dchaatidgedotcom'
    > >>
    > >> ,@body = @tableHTML
    > >>
    > >> ,@subject = 'Credit Memo To Back Out'
    > >>
    > >> ,@body_format = 'HTML' ;
    > >>
    > >>
    > >> --
    > >> ASP, SQL2005, DW8 VBScript, Visual Studio 2005, Visual Studio 2008
    > >>
    > >>
    > >>

    >
    >
    >


+ Reply to Thread