Cannot debug TSQL-SP from a ASP.Net or C# application with VS.NET 2005 SP1 on SQL-Server 2005
I have enabled SQL Server debugging on the Solution-Properties and set the
Application debugging property on my Data Connection.
System:
OS: Windows 2003 Enterprise edition SP1,
IDE: VISUAL STUDIO 2005 With SP1 Beta,
DB: SQL Server 2005 Developer Editon
Over the Server Explorer and my Connection I opened my Stored Procedure and
set a breakpoint.
When I step over my command calling the Stored procedure the Debugger didn’t
step into it. And the breakpoint on the procedure was disabled width the
following tooltip:
The Breakpoint will not currently be hit, Unable to bind SQL breakpoint at
this time, Object Containing the breakpoint not Loaded
It’s strange that I am able to debug stored procedure using step into. But I
have to debug the procedures from a ASP.NET C# application.
——————————————————————————–
I lost 3 day to solve this problem.
Solution:
The user you are using in your connection string must be a SysAdmin account.
I changed my Connection String Property.
By default I used Trusted Connection SSPI security.
I changed it on standard security user SA and debugger works fine
Leave a Reply