Debugging in VS.NET

From: Mike (Mike_at_discussions.microsoft.com)
Date: 08/25/04 

Date: Wed, 25 Aug 2004 13:01:08 -0700

I am attempting to debug a few stored procedures I created using the VS.NET
IDE.

After clicking "Run Stored Procedure" the IDE starts debugging, but almost
immediately throws the following error:

"Cannot debug stored procedures because the SQL Server database is not setup
correctly or user does not have permission to execute master.sp_sdidebug. Run
SQL Server setup or contact database administrator."

I found this error in conjunction with a bug in Windows XP SP2. I did have
the service pack installed at one point but uninstalled it earlier this week.

A few of the things I have tried include the following:
Debugging as SA
Setting sp_sdidebug to 'legacy_on"
Disabling my firewall
Changing DCOM settings to look like this (suggested in SQL Books)
  DCOMCNFG
  |
  |__ Application Tab
  | |
  | |_____ SQLDBREG
  | |
  | |______ Identity Tab
  | |
  | |_______ The interactive user
  |
  |__ Default Security Tab
   |
   |_____ Default Access Permissions
     |
     |______ Edit Default Button
      |
      |_______ Everyone (or domain\account and System)

And, beating my head on the desk.

None of these have worked for me. If anyone has any suggestions they would
be greatly appreciated!

Thanks in advance.

Mike