SQL Server Permissions - User, Group, Role settings for ASP.NET 1.1 2003 applications

When debugging ASP.NET 1.1 applications and troubleshooting "permission denied" errors on SQL server views and stored procedures called from asp.net code, would it be useful to check or  verify SQL Server User, Group and Role settings, and if so, which ones and what should they be set to in order to ensure that the app can run the view or SP?

Thanks in advance.

Typical error:

EXECUTE permission denied on object 'procFranceCustomersAsp', database 'Northwind', owner 'dbo'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: EXECUTE permission denied on object 'procFranceCustomersAsp', database 'Northwind', owner 'dbo'.

Source Error:
Line 52:             Dim ds As DataSet = New DataSet
Line 53:     'Fill the dataset
Line 54:             da.Fill(ds, "Customers") '<<<<----  Crashing here
Line 55:     'And bind it to the datagrid
Line 56:             dgResults.DataSource = ds
 
Start Free Trial