EXECUTE permission denied on object 'stored procedure name', database 'mydbname', schema 'dbo'.

Posted on 2006-04-25
Last Modified: 2012-08-14
I checked my stored procedure and gave the domain account which is running sql agent, etc. that I have designated to run all my SQL 2005 processes execute privilages to my stored procedure but still get that error when my aspx page loads.

My web.config

    <add name="DashboardConn"
         connectionString="Data Source=myservername;Initial Catalog=mydbname; integrated security=SSPI;persist security info=False; Trusted_Connection=Yes"
         providerName="System.Data.SqlClient" />
Question by:dba123
    LVL 52

    Expert Comment

    by:Carl Tawn
    If your site is running using Anonymous Access then it will be the ASPNET account that does not have Execute persmissions on the SP. Its the user accessing the SP not the account under which the service is running that needs permissions.

    If you are not using Anonymous Access, then it will be your Windows user account who needs permissions.
    LVL 1

    Author Comment

    It's running Integrated Windows authentification just like all my other sites.
    LVL 1

    Author Comment

    My windows user account does have access to that stored procedure.
    LVL 1

    Author Comment

    My other sites don't have this problem and are setup the same way.  I checked the stored procedures on those also, and I setup these just like those.
    LVL 1

    Author Comment

    ahh, here we go, I put the public database role in the permissions.  Now it's working.

    Accepted Solution

    Closed, 500 points refunded.
    The Experts Exchange
    Community Support Moderator of all Ages

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Lots of people ask this question on how to extend the “MembershipProvider” to make use of custom authentication like using existing database or make use of some other way of authentication. Many blogs show you how to extend the membership provider c…
    ASP.Net to Oracle Connectivity Recently I had to develop an ASP.NET application connecting to an Oracle database.As I am doing it first time ,I had to solve several problems. This article will help to such developers  to develop an ASP.NET client…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    This video discusses moving either the default database or any database to a new volume.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now