Unable to hit breakpoint Mixed language SQL C# debugging

[Ash]

Hi all,
I have a C# web application which calls a number of stored procedures.
I wish to step into the stored procedures while debugging i.e "Mix-mode
debugging":

I have completed the following steps:

Configured DCOM
Connected to database via Server Manager (I can see the SQL server and the
stored procedure)
Enabled SQL Debugging in the project properties

The Debugging components are installed and I think they are working because
I can right click the stored procedure from the server manager and "Step
Into Stored procedure" successfully!

The problem is that I set my breakpoint within the stored procedure run the
project then a

?
appears in the breakpoint when I hover over it I get this message:

"The breakpoint will not currently be hit. Unable to bind SQL breakpoint at
this time. Object containing the breakpoint not loaded."

Ive tried everything I can find can you please help me out !

Thanks in advance

Best Regards
Ashley Rajaratnam

[Morten Wennevik]

Have no idea, but maybe you need to add the sql server to debug processes

Under tools->debug processes, highlight SQL server (sqlmangr.exe?) and
click attach

--
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/

[Ash]

Thanks for the reply Morten

However still no luck tried attaching all of the debuggers to

sqldbreg2.exe
sqlmangr.exe
sqlserver.exe

Any other thoughts?

Thanks Ash

"Morten Wennevik" <Mo************@hotmail.com> wrote in message
news:oprxhvydvzhntkfz@localhost...
Have no idea, but maybe you need to add the sql server to debug processes

Under tools->debug processes, highlight SQL server (sqlmangr.exe?) and
click attach

--
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/

[Peter Koen]

"Ash" <N_******@hotmail.com> wrote in news:#EWt$oXmDHA.1884
@TK2MSFTNGP09.phx.gbl:

Thanks for the reply Morten

However still no luck tried attaching all of the debuggers to

sqldbreg2.exe
sqlmangr.exe
sqlserver.exe

Any other thoughts?

You need to have your sql server running under your user account to be able
to attach without problems. if it's running under the system account you
won't get permission to attach to that process.

--
best regards

Peter Koen
-----------------------------------
MCAD, CAI/R, CAI/S, CASE/RS, CAT/RS
http://www.kema.at