473,322 Members | 1,232 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

'EXECUTE PERMISSION DENIED' on executing Sproc

Hi,

I got this 'EXECUTE permission denied on object <mySproc>' error message
everytime I try executing my SQL server Sproc.
What's this and how to fix this err?

many thnaks in advance,
mike
Nov 19 '05 #1
7 1723
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/...er.programming

The following news group thread will probably help :
http://tinyurl.com/3ohj6

Tod Birdsall, MCP
http://tod1d.blogspot.com

Nov 19 '05 #2
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" <no*****@netsalad.com> wrote in message
news:11**********************@c13g2000cwb.googlegr oups.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/...er.programming

The following news group thread will probably help :
http://tinyurl.com/3ohj6

Tod Birdsall, MCP
http://tod1d.blogspot.com

Nov 19 '05 #3
Mike,

This is a database user right issue. Try first to get it working in your
database client tools with the same database authentication you are using in
your asp.net program.

Eliyahu

"Mike L." <gl*******************@yahoo.com> wrote in message
news:e5**************@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" <no*****@netsalad.com> wrote in message
news:11**********************@c13g2000cwb.googlegr oups.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/...er.programming
The following news group thread will probably help :
http://tinyurl.com/3ohj6

Tod Birdsall, MCP
http://tod1d.blogspot.com


Nov 19 '05 #4
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." <gl*******************@yahoo.com> wrote in message
news:e5**************@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" <no*****@netsalad.com> wrote in message
news:11**********************@c13g2000cwb.googlegr oups.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/...er.programming

The following news group thread will probably help :
http://tinyurl.com/3ohj6

Tod Birdsall, MCP
http://tod1d.blogspot.com


Nov 19 '05 #5
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" <no***********@nowhere.com> wrote in message
news:#l**************@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." <gl*******************@yahoo.com> wrote in message
news:e5**************@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" <no*****@netsalad.com> wrote in message
news:11**********************@c13g2000cwb.googlegr oups.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/...er.programming
The following news group thread will probably help :
http://tinyurl.com/3ohj6

Tod Birdsall, MCP
http://tod1d.blogspot.com



Nov 19 '05 #6
re:
So, i don't have any privilege needed to change
any permission on any of my SQL objects.
You can request your ISP to make the permission change.

Juan T. Llibre
ASP.NET MVP
===========
"Mike L." <gl*******************@yahoo.com> wrote in message
news:OK**************@tk2msftngp13.phx.gbl... 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" <no***********@nowhere.com> wrote in message
news:#l**************@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." <gl*******************@yahoo.com> wrote in message
news:e5**************@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" <no*****@netsalad.com> wrote in message
> news:11**********************@c13g2000cwb.googlegr oups.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/...er.programming >>
>> The following news group thread will probably help :
>> http://tinyurl.com/3ohj6
>>
>> Tod Birdsall, MCP
>> http://tod1d.blogspot.com
>>
>
>



Nov 19 '05 #7
Loggin (authentication) and permission (authorization) are different thing
Authentication just proves who you are. Once your identity is proven, the
system will decide what you can do/vannot do, according to your identity.
You may be able to logged in but cannot do anything if no permission is
given. In your case, you have logged in, but you are not given the
permission to use that Sproc (and maybe more). If you desgned the ASP.NET
system, you need to study more on the security issue. Or ask the SQL Server
administrator to give you (or the ASP.NET user) permission to use that Sproc
(and others).

"Mike L." <gl*******************@yahoo.com> wrote in message
news:OK**************@tk2msftngp13.phx.gbl...
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" <no***********@nowhere.com> wrote in message
news:#l**************@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." <gl*******************@yahoo.com> wrote in message
news:e5**************@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" <no*****@netsalad.com> wrote in message
news:11**********************@c13g2000cwb.googlegr oups.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/...er.programming>
> The following news group thread will probably help :
> http://tinyurl.com/3ohj6
>
> Tod Birdsall, MCP
> http://tod1d.blogspot.com
>



Nov 19 '05 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Bob Garbados | last post by:
I'm pretty new to php\linux and I'm trying to encrypt a file using gpg from a php page on a linux box and it's not working. The following code works for executing 'ls', but not gpg... ...
2
by: PM Creyghton | last post by:
I got this error without using frames: First of all, I'm developing an ASP application, and once in a while my activeX components crash or hang, I got page-not-found errors, errors generated by...
5
by: Ivan Simurina | last post by:
I m getting the following error once i initiate a page that connects with database. SqlException: EXECUTE permission denied on object 'sp_items_for_sale', database 'bids', owner 'dbo'.] what...
8
by: Jiggaz | last post by:
Hi, In my ASPX Page, i have a form for signup. And whene user click on the button, the event Button1_Click must use a stored procedure. But instead of use stored proc, i get this exception :...
7
by: Ken | last post by:
Hi guys, this is a curios thing, everything was working fine then I had to restore my development machine( VS.NET, SQL server etc) now I'm receiveing this error from my asp aplication only in...
1
by: david | last post by:
I am using MS ASP.NET course matrial in Model 16. I have the above problem. I have setup user machin\ASPNET as Reeder and Writer for doctors database More informatin are in following...
3
by: teddysnips | last post by:
I'm trying to use the SPROC below (courtesy of Erland!) to capture the error message but it fails owing to insufficient permissions (I can't reproduce it just now, but I think it's because it can't...
0
by: debug03 | last post by:
I am executing a DTS package on a Windows 2000 sp4 server running SQL Server 2000 and IBM DB2 V7 client. The DTS package source data(SQL Server) is selected from SQL server table and inserts data to...
1
by: Jeff | last post by:
asp.net 3.5 I've created a database in Sql Server 2005 for my asp.net project. I used aspnet_regsql to add membership tables and stored procedures. Then I added a login/user to this database....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.