October 19, 2004

EXECUTE permission denied on object 'sp_sdidebug', database 'master', owner 'dbo'.

Just after I was able to debug my web applications in VS.Net, another
problem came. The call to any stored procedure always resulted in error
"EXECUTE permission denied on object 'sp_sdidebug', database 'master',
owner 'dbo'.". I googled it on the web and found it was because I didn't
give permission for the designated user (whose account was used to drive
the web application) of access to master database and the procedure. So
I did following two steps,

1. Grant the user as a "public" user of database "master"

2. Grant the user access to stored procedure "sp_sdidebug"



No comments: