Last chance to get discounted tickets to Codegarden... Price goes up on Tuesday at 20:00 CEST!

Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Dave Clinton 14 posts 67 karma points
    1 week ago
    Dave Clinton
    0

    Running stored procedures in a live Umbraco Cloud environment results in EXECUTE permission was denied

    We're having issues trying to run a stored procedure in our live Umbraco Cloud environment. The error raised in the log is:

    "System.Data.SqlClient.SqlException (0x80131904): The EXECUTE permission was denied on the object 'XXX', database 'XXX', schema 'dbo".

    I've tried adding the execute permission to the db user but it fails with "Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself."

    Anyone have any ideas how we can resolve this?

  • Paul Sterling 692 posts 1367 karma points MVP 2x admin c-trib
    1 week ago
    Paul Sterling
    0

    Hi Dave -

    For sure you'll need to get in touch with the Umbraco HQ support folks to resolve this. I don't know if Stored Procedures are supported with Umbraco Cloud - I don't see why not, just not sure they are. Anyhow, the support folks are super helpful so just reach out to them on the chat in the Cloud Portal. An, if you would, post the resolution back here so we all know.

    Thanks

  • Dave Clinton 14 posts 67 karma points
    1 week ago
    Dave Clinton
    0

    Hi Paul,

    Thanks for the reply, we did try contacting support first but we were told as we only have a Starter plan support isn't included and were advised to try the forums.

    All the procs work fine on the local copy it's just when we try running them in the live Umbraco Cloud instance we get this issue. Will update in here if we do find an answer though!

    Cheers, Dave

Please Sign in or register to post replies

Write your reply to:

Draft