Debugger not work propertly

• Zoran Kovacevic-410237

  SSC Veteran

  Points: 223

  More actions

  March 4, 2007 at 3:20 am

  #116616

  When I try to debug stored procedure in SQL Server 2000 Query Analyzer I got error message

  SP debugging may not work propertly if you log as 'Local system account' while SQL Server is configured to run as service. You can open Event Viwer to see details ...

  After this msgbox I press F5 to start and got error

  Server: Msg 508, Level 16, State 1, Procedure sp_sdidebug, Line 1

  [Microsoft][ODBC SQL Server Driver][SQL Server]Unable to connect to debugger on COMPAQ-NX6325\PRERADA_MESA (Error = 0x800401f3). Ensure that client-side components, such as SQLLE.DLL, are installed and registered on COMPAQ-NX6325. Debugging disabled for connection 55.

  What I have to do to work with debuger

• Anoop-352305

  SSC Enthusiast

  Points: 102

  More actions

  March 6, 2007 at 12:17 am

  #693257

  execute this script on query analyzer and see if it works.

  "exec sp_sdidebug 'legacy_on'"