?
Solved

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

Posted on 2006-04-25
7
Medium Priority
?
379 Views
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

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

Expert Comment

by:Carl Tawn
ID: 16538835
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.
0
 
LVL 1

Author Comment

by:dba123
ID: 16543188
It's running Integrated Windows authentification just like all my other sites.
0
 
LVL 1

Author Comment

by:dba123
ID: 16543194
My windows user account does have access to that stored procedure.
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 1

Author Comment

by:dba123
ID: 16543202
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.
0
 
LVL 1

Author Comment

by:dba123
ID: 16543226
ahh, here we go, I put the public database role in the permissions.  Now it's working.
0
 

Accepted Solution

by:
GranMod earned 0 total points
ID: 16665839
Closed, 500 points refunded.
GranMod
The Experts Exchange
Community Support Moderator of all Ages
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article discusses the ASP.NET AJAX ModalPopupExtender control. In this article we will show how to use the ModalPopupExtender control, how to display/show/call the ASP.NET AJAX ModalPopupExtender control from javascript, how to show/display/cal…
In an ASP.NET application, I faced some technical problems. In this article, I list them out and show the solutions that I found.  I hope it will be useful. Problem: After closing a pop-up window, the parent page should be refreshed automaticall…
Integration Management Part 2
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

850 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