application role permission denied RRS feed

  • Question

  • I created an application role called "MyApp" and assign stored procedures execute rights to MySP.

    I goet permission was denied when execute MySP using MyApp.

    I can execute MySP using my login ID.

    I go to stored procedure property and go to permission tab.

    It shows execute rights on explicit tab, but on the effective tab shows the following message.

    cannot execute as the database principal because the principal "MyApp" does not exist. This type of principal cannot

    impersonated, or you do not have permission

    Are there any configuration or special rights to set application role execute rights or what I am missing here?

    Your help and information is great appreciated,



    Tuesday, April 8, 2014 2:34 PM