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"
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment