EXECUTE permission denied on object ’sp_sdidebug’, database ‘master’, owner ‘dbo’.
I got this error from one of my ASP.NET web services when I tried to fetch some data from a remote database. I tried searching online for a possible fix to this issue but found none to be convincing and so thought of publishing the solution that resolved the issue.
Please note that this solution may only be effective if you are debugging your ASP.NET page/web service and are manually attaching the worker process.
1. Attach to the worker process.
2. With the aspnet_wp.exe highlighted hit the “Select…” button at the top right hand side.
You will get the “Select Code Type” dialog with the “Automatically determine the type of code to debug” selected. Now for ASP.NET to use the “Managed” code type by checking the “Managed” checkbox.
Try it again and it should work without the “EXECUTE permission denied on object ’sp_sdidebug’, database ‘master’, owner ‘dbo’.” error.
Hope it helps. Let me know of any issues or alternate solutions in comments.
Written by askars. Read more great feeds at is source WEBSITE
1 comment.
Read more articles on howto and Misc and ASP.NET and .Net and Visual Studio and Tips and Tricks.
- [+] Digg: Feature this article
- [+] Del.icio.us: Bookmark this article
- [+] Furl: Bookmark this article
#1. November 30th, 2007, at 6:27 AM.
That did the trick, thanks a million.
It was set on automatically and it checked the T-SQL, thats why i keep on getting this error. I checked the project properties on the debug tab but SQLServer was unchecked. But now I know there is this setting ;-)
Thanks