Post reply

Process suddenly failing with permissions error [SOLVED]

  • May 13, 2019 at 3:56 pm

    #3641563

    We have a .NET process that runs using a particular account.  That account is set up as a SQL login, and the user has execute permissions for the agent_datetime scalar function from the msdb system database.

    The process has been running fine, but after an automated SQL Server update, we're now seeing this error: "The EXECUTE permission was denied on the object 'agent_datetime', database 'msdb', schema 'dbo'."

    Any guidance on this would be greatly appreciated!

    • This topic was modified 5 years, 6 months ago by  tarr94.

  • May 13, 2019 at 6:05 pm

    #3641633

    A SQL Server update wiped the permissions from a different instance that also needed this permission set.  Once I put those back in place, this started working again.

  • May 13, 2019 at 6:36 pm

    #3641641

    Cool.  Thanks for posting what you found.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

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

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