locked
The EXECUTE permission was denied on the object 'RetrieveNonblockingInstanceStateIds' RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    The EXECUTE permission was denied on the object 'RetrieveNonblockingInstanceStateIds', database 'mytestdb', schema 'dbo'.

     

     

    I keep getting this error if I execute my app with a user other than SA.  Any ideas on why it is happening?

     

    thanks

    Xavier

     

    Monday, September 10, 2007 9:37 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

     

    Hi Xavier,

     

    You should check the EXECUTE permissions associated with your 'RetrieveNonblockingInstanceStateIds', object in your database. The user you are running that object as should have EXECUTE permissions or it should be a member of a group with EXECUTE permissions. I hope this helps.

     

    Please address this kind of issues on a SQL related forum for more details.

     

    Thanks,

    -Constantin

    Tuesday, September 11, 2007 5:07 PM