I can not get the debugger to work in Query Analyzer. I am running SQL and VS all on the same machine.
When I open Query Analyzer and right click on a Stored Procedure and click "Debug" I get a message saying:
SP Debugging may not work properly if yo log on as 'Local System account' while SQL Server is configured to run as a service. You can open Event Viewer to see details. Do you wish to continue?
When I chose YES to continue and then try to debug I get this 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 DICA2ESITE42239 (Error = 0x800401f3). Ensure that client-side components, such as SQLLE.DLL, are installed and registered on DICA2ESITE42239. Debugging disabled for connection 55.
I am pretty new to this so would someone please let me know what I am doing wrong.