Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ann
Posting Yak Master
220 Posts |
 Posted - 2008-02-12 : 11:21:03
|
| I wasn't sure where to post this - so please forgive.I am trying to get my application (.net c#) to run some sp's. I can finally connect to my db, but when I get to the part that executes the sp's I get the infamous EXECUTE permission denied on object blah blah blah....!When I check the permissions on the stored procedure, I have granted execute on the sp for the user - so I don't understand why I can't execute it!Sorry if I sound frustrated, it's because I am.Can someone please explain exactly how to grant the permission - I am probably missing something - but when the user is granted permission to execute a sp, that should be enough..no?Any help would be soo appreciated - I am so tired of this!Thanks |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-02-12 : 11:33:55
|
How do your connection string look like?www.connectionstrings.comAre you using SSPI? Trusted connection?
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
ann
Posting Yak Master
220 Posts |
Posted - 2008-02-12 : 11:37:58
|
| Is there something else I should add to this connection string? I have always used it successfully when I was pointing to 2000, but maybe 2005 wants more? <add key="SqlConnect" value="SERVER=***\***;Initial Catalog=Faster;UID=user;PWD=pass;" /> |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-02-12 : 11:42:29
|
Are you using Asp.Net?Then you must make sure authentication is enabled, otherwise query will execute as "MACHINENAME$IUSR" something.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
ann
Posting Yak Master
220 Posts |
Posted - 2008-02-12 : 11:45:06
|
| using asp .net 1.1:<authentication mode="Windows" /> <authorization> <allow users="*" /> <!-- Allow all users --> |
|
|
|
|
|
|
EXECUTE permission denied on object