We are receiving this error --- Execute Permission denied on stored procedures intermittently. We are baffled by this error since it only happens intermittently.
Example of the error:
The EXECUTE permission was denied on the object 'ProcGetEmailNotes', database 'ABCWF', schema 'dbo'.
The database is on a remote server (MS SQL Server 2005).
The web site is on a machine running under IIS default application pool using the Network Service account.
This account gets translated into DomainName\ServerName when accessing the remote database.
We gave this account db.owner permissions on the database.
Thanks,
choi