SQL Server Performance Forum – Threads Archive
SQL SP Debugger problems
Having recently switched to a new client machine I am now unable to get the SQL Debugger working. I have followed the suggestions from the Books Online under the "Troubleshooting the Transact-SQL Debugger" (checking the DCOM settings on the server, manually registering the dlls on the client) and this still doesn’t work. My previous machine managed to connect and use the SQL Debugger fine, so it shouldn’t be a problem related to the server. The new (client) machine has had the client tools updated to the same patch as the server (SQL 2000 SP3a – 8.00.760). The error returning when attempting to use the SQL Debugger isServer: Msg 504, Level 16, State 1, Procedure sp_sdidebug, Line 1
[Microsoft][ODBC SQL Server Driver][SQL Server]Unable to connect to debugger on EROS (Error = 0x800706ba). Ensure that client-side components, such as SQLDBREG.EXE, are installed and registered on [ClientMachineName]. Debugging disabled for connection 157.
Does anyone have any other suggestions on how to get this working?
(I’m dubious of removing and reinstalling the client tools as I’d install the same way I’ve already done so, so I can’t imagine that making any odds).
oh, and I forgot to say, I do have rights to the sp_sdidebug SP as I am using my account which has system administrator rights within SQL
See, if this helps:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;310650
———————–
–Frank
http://www.insidesql.de
———————–
]]>