Re: Can't run views and stored procedures
- From: "John Dohn" <noemail@xxxxxxxxxxx>
- Date: Mon, 18 Feb 2008 12:59:34 -0500
Thanks. I am using Windows Authentication.
Do I need to manually set the permissions even if the view and stored proc
were created in VS 2003 Server Explorer (right click/ New)?
I am logged in as admin on the development machine which is running Win
Server 2003, SQL 2000, IIS 6, ASP.net 1.1 and VS 2003. I am a member of VS
developers group.
By the way, just as a sanity check, the same view and stored proc worked
just fine when I loaded VS with a windows forms app that contains the same
connection string (except a Modifiers property set to Friend whereas web
form conn str set to Protected - all by VS not me). The win form has the
same code behind as the web form. So it seems like the permissions are right
for windows but somehow not right for web.
"David Wier" <dw@xxxxxx> wrote in message
news:OH4Cc2kcIHA.1960@xxxxxxxxxxxxxxxxxxxxxxx
If you've got Windows authentication on your connectionstring to SQL
Server, you must grant execute permissions on sProcs to the same user
named in the connectionstring
David Wier
http://aspnet101.com
http://iWritePro.com - One click PDF, convert .doc/.rtf/.txt to HTML with
no bloated markup
"John Dohn" <noemail@xxxxxxxxxxx> wrote in message
news:OUhWzzkcIHA.5208@xxxxxxxxxxxxxxxxxxxxxxx
I can work with them just fine in VS but when I run my app, I get a select
permission denied error on any view and execute permission denied on any
SP in my web app.
All was worked fine until Friday and not since then.
Win Server 2003 SP4
VS 2003
ASP.NET 1.1
IIS 6.0
I am developing on the server machine and am logged in with admin
privileges.
My account is in the VS Developers group.
Looking for the best way to troubleshoot this.
Much obliged.
.
- Follow-Ups:
- Re: Can't run views and stored procedures
- From: David Wier
- Re: Can't run views and stored procedures
- References:
- Can't run views and stored procedures
- From: John Dohn
- Re: Can't run views and stored procedures
- From: David Wier
- Can't run views and stored procedures
- Prev by Date: UpdatePanel not behaving as expected
- Next by Date: Re: UpdatePanel not behaving as expected
- Previous by thread: Re: Can't run views and stored procedures
- Next by thread: Re: Can't run views and stored procedures
- Index(es):
Relevant Pages
|
