Cannot run SQL Debugger

[3251962]

I installed SQL 2000, but I'm using Visual Studio Management screen to connect to my databases. While I have no problem to open, create or do almost anything I cannot debug my stored procedures. I get the following message:

Unable to connect to debugger on HOMEOFFICE\MYSQL (Error = 0x80040154). Ensure that client-side components, such as SQLDBREG.EXE, are installed and registered on HOMEOFFICE. Debugging disabled for connection 52.

I'm running Windows XP Professional SP2. I have tried several thigs, like making sure DCOM is configured for debugging or trying to register SQLDBG.DLL, etc, but nothing seems to work. Any ideas, please?

 

[SQLSister]

SQL Server 2000 has a debugger in Query analyzer but it's not worth the effort to try to get it to work. Not sure about using visual studio as no one I know uses that to do t-SQl programming. All I can do is point you to the FAq on how I debug stored procs.

http://www.tek-tips.com/faqs.cfm?fid=4314

Questions about posting. See faq183-874