debugger interface

Help,
I used to be able to debug a stored procedure in the query analyser.
But now I get an error indicating that I should re-run setup and add the
debugger interface.
the debugger is installed!!!!
if I take a look at the eventviewer I see following error
DCOM got error "the operation completed successfully" and was unable to
togon , \SQLdebugger in order to run the server.
What can I do to correct this problem and switch debugging on again?
Thanks,
MarcIt sounds like the DCOM permissions may no longer set
correctly. Check the topic in books online: Troubleshooting
the Transact-SQL Debugger
Make sure you follow all the steps, especially those for
DCOMCNFG.EXE
You should also check the following knowledge base article:
INF: T-SQL Debugger Is Turned Off By Default for Earlier
Clients After You Install SQL Server 2000 Service Pack 3
http://support.microsoft.com/?id=328151
-Sue
On Tue, 12 Apr 2005 09:40:48 +0200, "marc" <heev@.msn.com>
wrote:
>Help,
>I used to be able to debug a stored procedure in the query analyser.
>But now I get an error indicating that I should re-run setup and add the
>debugger interface.
>the debugger is installed!!!!
>if I take a look at the eventviewer I see following error
>DCOM got error "the operation completed successfully" and was unable to
>togon , \SQLdebugger in order to run the server.
>What can I do to correct this problem and switch debugging on again?
>Thanks,
>Marc
>