I finally figured out that only the professional versions of Visual Studio will allow debugging. I installed a fresh copy of Visual Studio 2008 Professional from MSDN and I'm up and running. It was so easy to set up that I'm mad I didn't get it going sooner. Unfortunately, the documentation out there is pretty abysmal regarding this topic.
On a related note, DebugView is pretty handy for sidebar gadget development as well.