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.

Scott Guthrie announced today that Microsoft is opening up the source code for the .NET Framework library with the release of the .NET Framework 3.5 and Visual Studio 2008 later this year. Microsoft will begin by offering the source code (with source file comments included) for the .NET Base Class Libraries (System, System.IO, System.Collections, System.Configuration, System.Threading, System.Net, System.Security, System.Runtime, System.Text, etc), ASP.NET (System.Web), Windows Forms (System.Windows.Forms), ADO.NET (System.Data), XML (System.Xml), and WPF (System.Windows).  It will then be adding more libraries in the months ahead (including WCF, Workflow, and LINQ).  The source code will be released under the Microsoft Reference License (MS-RL).

Source: Scott Guthrie