Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Transact-SQL (2000)  Stored Procedure Debugging Problem

Author  Topic  cwsrad Starting Member 4 Posts Posted - 2005-09-22 : 08:08:41 I am trying to debug a stored procedure from my desktop machine and where the actual stored procedure resides on a Windows 2000 Server on our LAN. However, I get the following error: 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 SIS2SERVER (Error = 0x80070005). Ensure that client-side components, such as SQLDBREG.EXE, are installed and registered on SIS2XPTEST. Debugging disabled for connection 58. For my desktop, I am using XP Professional SP2 and the database is SQL Server 2000 SP1 Any help would be greatly appreciated!