SQL Server Debugger

  • 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

     

  • 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. 

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply