T-SQL Debugging with VS.NET 2003

• Bent

  SSC Enthusiast

  Points: 116

  More actions

  August 28, 2003 at 6:03 am

  #65096

  Hi,

  I'm trying to get the SQL remote debugging to work from within Visual Studio.NET 2003. Even though I followed the MSDN instructions for Enabling and Setting Up SQL Debugging I still get the error message "Unable to start SQL debug session. Ensure sqldbreg2.exe and proxy/stub DLL sqldbg.dll are registered on this machine.". The MSDN trouble shooting section doesn't help 'cause I did everything they suggest on their pages.

  I already granted Read & Execute permission to the SQLDebugger user account on the following folders:

  C:\Program Files\Common Files\Microsoft Shared\SQL Debugging

  C:\WINNT\system32

  And I still get the error message...

  What might help is the system log error event on my machine which I get every time I try to start debugging. It says

  10004 DCOM got error "Overlapped I/O operation is in progress. " and was unable to logon .\SQLDebugger in order to run the server:

  {C36729C6-65AB-4A6F-8B96-53FF94E3A8D2}

  Can anyone help?

  Thank you for your suggestions

  Bent

• September 2, 2003 at 8:00 am

  This was removed by the editor as SPAM

• Ɖiamond ǤeezeƦ

  SSC Eights!

  Points: 905

  More actions

  September 19, 2003 at 4:29 am

  #475000

  Are these the instructions that you followed?

  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vsdebug/html/vctskInstallingRemoteDebugMonitor.asp

  If not, then this page might provide some clues to what is causing the error.

  Can you debug stored procedures on the remote machine using Query Analyser?

  Hope this is of some help.

  Keith

• Ɖiamond ǤeezeƦ

  SSC Eights!

  Points: 905

  More actions

  September 19, 2003 at 4:48 am

  #475001

  If the remote machine you are attempting to debug is in another domain, this article might also be helpful:

  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vsdebug/html/vxtskremotedebuggingacrossdomains.asp

  Keith