Re: 'EXECUTE PERMISSION DENIED' on executing Sproc

From: Mike L. (globalwebservices2005_at_yahoo.com)
Date: 01/30/05 

Date: Sun, 30 Jan 2005 21:29:43 +0700

Thanks Juan,

Yes, I forgot to mention that I got this prob on one of my hosted
application.
So, i don't have any privilege needed to change any permission on any of my
SQL objects.
Aren't all we have just login name, pwd and DB for which belong to us in
such hosted environment?
Anyway, my hosting server runs Win2K3, SQL Server 2K, .NET framework 1.1

thks & brgds,
mike

"Juan T. Llibre" <nomailreplies@nowhere.com> wrote in message
news:#l0isAtBFHA.2624@TK2MSFTNGP11.phx.gbl...
> Hi, Mike.
>
> Actually, it does *not* have anything to do
> with ASP.NET's settings/configurations.
>
> It has to do with SQL Server's security settings.
>
> Tod gave you a link with a good pointer to the answer.
>
> The answer is to allow execution permission for the Sproc,
> to the account you're using to work with your SQL server DB.
>
> That will depend on how you've configured SQL Server,
> and which account ASP.NET uses to work with SQL Server,
> which in turn depends on which version of IIS you're using.
>
> You did not mention whether you're using Windows security,
> or SQL Server security, or mixed-mode security, in SQL Server,
> and you did not mention which version of IIS you're running,
> and you did not mention which OS you're using, and you did
> not mention which version of ASP.NET/NET Framework
> you're using.
>
> Posting that information would have helped to
> give you a straighter, more accurate, answer.
>
> This is common in these newsgroups.
>
> Everybody who posts a question here should, at the very least,
> identify their OS, the version of IIS, and their .NET Framework
> version/ASP.NET version. Additionally, if the question involves
> database access, the version of their db platform.
>
> That will help those who are trying to help the poster find the
> answer quickly, and get the right answer back to the poster faster.
>
> So, check which account you're using to retrieve/write data
> from/to SQL Server, and give execute permission on the sproc
> to that account.
>
> The account will be either the SQL Server login you're using to retrieve
> data from SQL Server (look in your connection string to know which
> one it is), or the ASPNET account if you're running IIS 5, or the
> Network Service account if you are running IIS 6.
>
> Only you know which account you're using.
>
>
>
> Juan T. Llibre
> ASP.NET MVP
> ===========
> "Mike L." <globalwebservices2005@yahoo.com> wrote in message
> news:e5sULqpBFHA.4008@TK2MSFTNGP09.phx.gbl...
> > Hi Tod,
> >
> > Is it? So it's got nothing to do with my ASP.NET settings/configurations
> > or
> > whatever?
> > anyone else can help me with this?
> >
> > thks,
> > mike
> >
> > "Tod Birdsall" <nospam1@netsalad.com> wrote in message
> > news:1107067389.927132.193920@c13g2000cwb.googlegroups.com...
> >> Hi Mike,
> >>
> >> Technically, this is the wrong group for this question. You will
> >> probably have better luck posting in the following news group :
> >>
http://groups-beta.google.com/group/microsoft.public.sqlserver.programming
> >>
> >> The following news group thread will probably help :
> >> http://tinyurl.com/3ohj6
> >>
> >> Tod Birdsall, MCP
> >> http://tod1d.blogspot.com
> >>
> >
> >
>
>

Relevant Pages

  • Re: Newbie needs code pages for SQL Server 2000 access from asp.net page using vb.net
    ... It would make more sense if the error message described that permission was ... I am not sure what user to add where in IIS ... >> passing SQL server the account used to run the website. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Kerberos from XP to IIS hosting ASP.NET 2.0 Web Service help
    ... If your MS SQL Server is running under a custom /local/ account, ... not sure how Kerberos authentication is supposed to work. ... If SQL Server is running under a domain account, ... you are not authenticating to IIS as anonymous. ...
    (microsoft.public.inetserver.iis.security)
  • Windows Authentication with IIS on separate machines
    ... -Web Application is using Basic Authentication set in IIS ... -Added user account TESTUSER and gave read access to ... in SQL server but doesn't work if user account was ... Windows account, ...
    (microsoft.public.sqlserver.security)
  • Re: How to configure IIS 7 to use a built-in account
    ... make Read permission for IUSR... ... And I know that IIS actually does work because the new account I ... settings. ...
    (microsoft.public.inetserver.iis)
  • Re: Trusted sql connection failure
    ... Is the SQL Server located on a different machine to the IIS webserver? ... you probably need to run ASP.NET under a domain account (or find some ... it appears that you are running ASP.NET under a local account (either ...
    (microsoft.public.dotnet.framework.aspnet.security)