Running Stored Procedure security error 1

[daveonion]

Hi,

I have created a page which runs a stored procedure on sql server, this works on my local pc but once published i get an execute permission denied error, the page is set up to use integrated windows authentication so i am unsure why i dont have the required permissions. Am i missing something?
Thanks in advance

 

[jmeckley]

1. is impersonation set to true in the config file?
2. is IIS configured to use IWA?
3. is anonymous access disabled in IIS?
4. is the user account configured in SQL Server to access: the server, the database, execute the stored proc?

Jason Meckley
Programmer
Specialty Bakers, Inc.

faq855-7190
faq732-7259

 

[daveonion]

Thanks, i didnt have impersonate set to true.