Post reply

EXECUTE permission denied on object ''sp_OACreate'', database ''master'', owner ''dbo''.

  • November 10, 2006 at 11:27 am

    #171262

    wrote:

    I want to send email using sql stored procedure.my code is work fine in my local sqlserver account. when I use my online sql server it display this error.

    EXECUTE permission denied on object 'sp_OACreate', database 'master', owner 'dbo'.

    EXECUTE permission denied on object 'sp_OASetProperty', database 'master', owner 'dbo'.

    EXECUTE permission denied on object 'sp_OAMethod', database 'master', owner 'dbo'.

    EXECUTE permission denied on object 'sp_OADestroy', database 'master', owner 'dbo'.

    How canI solove this problem?

    Please let me do fastly.

  • November 10, 2006 at 11:33 am

    #671159

    I'll state the obvious.  Are you sure that the Online SQL Server Account has permissions to execute the stored Procedures?  If the account doesn't have high enough permissions to allow execute of all procedures, you may want to check the permissions of the user to see if it has been granted Execute on those SP's. 

    TJP8

Viewing 2 posts - 1 through 1 (of 1 total)

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