Debugger does not work after install xp service pack 2

Urgent. can't debug while we could before the "upgarde". WE waited a year
waiting for Microsoft to get all the bugs out. Well, guess the bugs aren't
out yet.
Anyone know how to solve problem. Using Windows 2000 Server, XP Pro
workstations and sQl Server 2000 with svpk 3a.
I get this message:"Server: Msg 504, Level 16, State 1, Procedure
sp_sdidebug, Line 1
[Microsoft][ODBC SQL Server Driver][SQL Server]Unable to connect to debugger
on FPFSPM49 (Error = 0x800706ba). Ensure that client-side components, such a
s
SQLDBREG.EXE, are installed and registered on EDW5840003M6Y. Debugging
disabled for connection 61.
"
I followed the instructions in Books online best as possible. However, "you
cannot register sqldbreg as they say to as it is not a dll or ocx"
It worked fine, before this install of xp sv pack 2.
--
Matthew MarkHi
There are many posts regarding this and there is a hotfix to it:
http://support.microsoft.com/kb/839280
This will also be included in SQL Server Pack 4.
John
"matthewmark" <matthewmark@.discussions.microsoft.com> wrote in message
news:64B85E46-5B86-4491-BCCD-6E9FA3A9F80C@.microsoft.com...
> Urgent. can't debug while we could before the "upgarde". WE waited a year
> waiting for Microsoft to get all the bugs out. Well, guess the bugs aren't
> out yet.
> Anyone know how to solve problem. Using Windows 2000 Server, XP Pro
> workstations and sQl Server 2000 with svpk 3a.
> I get this message:"Server: Msg 504, Level 16, State 1, Procedure
> sp_sdidebug, Line 1
> [Microsoft][ODBC SQL Server Driver][SQL Server]Unable to connect to
> debugger
> on FPFSPM49 (Error = 0x800706ba). Ensure that client-side components, such
> as
> SQLDBREG.EXE, are installed and registered on EDW5840003M6Y. Debugging
> disabled for connection 61.
> "
> I followed the instructions in Books online best as possible. However,
> "you
> cannot register sqldbreg as they say to as it is not a dll or ocx"
> It worked fine, before this install of xp sv pack 2.
> --
> Matthew Mark