SQL Server Debugger

• shabhana

  Grasshopper

  Points: 17

  More actions

  September 22, 2005 at 4:46 am

  #187814

  I'm having problems debugging a stored procedure on a remote server.

  i keep getting 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 remote_servername (Error = 0x80070005). Ensure that client-side components, such as SQLDBREG.EXE, are installed and registered on mymachine. Debugging disabled for connection connectionnumber.

  i was trying to debug the stored procedure on the server using service pack 3 but it didn't work. i installed service pack 4 locally and still no luck.

  the following files appear their respective directories and have been registered :

  sqldbg.dll  + sqldbreg.exe (program files\common files\microsoft shared\sql debugging)

  When others (running on SP 3) try debugging it works fine.

  any help is appreciated.

  regards,

  shabhana

   

• barsuk

  SSChampion

  Points: 12280

  More actions

  September 26, 2005 at 12:15 pm

  #593103

  Apply SQL Hotfix 944 on Server.

  Turn off your Firewall. Or add exception (add ports) to it which are related to your machine/remote machine using Stored Proc.

  Also in the Firewall Settings exclude the program C:\Program

  Files\Common Files\Microsoft Shared\SQL Debugging\sqldbreg2.exe and Port 135. Make sure it works when Firewall off.