CODEWITHSUNDEEP
debuggingstored-proceduresremote-debuggingsqlclr
Pouyan
Pouyan

Reputation: 2949

Unable to debug .Net Code. Could not attach to process. SQL CLR Remote Debugging

I'm trying to debug a CLR based StoredProcedure in Visual Studio 2012 RTM. I have a Sql Database Project. When I try to debug my script file using RightClick -> Execute with debugger it pop ups a warning about harmfulness of attaching a process and when I accept it just say that :

Unable to debug .Net Code. Could not attach to SQL Server process on 'Devserver'.

I've done many different things :

But it still says it cannot attach the process and there is not Source Code that can be debugged.

Do You have any idea ? what do I forget ?

thanks in advance

Upvotes: 0

Views: 7945

Answers (1)

Vinod W. B.
Vinod W. B.

Reputation: 254

Hi after a long time searching over internet, Your Question has Given me Answer of Our Question. Please understand following very carefully,

  1. Start Visual Studio 2012 with Elevated permissions of Administrator
  2. Create SQL Server Project
  3. In Project Settings/Debug Pane, Provide Connection String for Database Connection
  4. From View Menu, Open SQL Server Object Explorer, If your connection string provided in Project doesn't create Instance of Server, then Recreate connection here...
  5. Right click on Instance and Select Allow SQL CLR Debugging, it will show some warning accept everything but read warnings carefully.
  6. Save Project and perform Rebuild, and test a Publish of project by Generated Publish Script.
  7. Now Create a non-deployment script in project, put a break point press ALT+F5 to execute script with Debug option, when clr-procedure will occur and try to go inside it, it will ask for process to attach with windows, Please allow to Attach

above step worked for me, and here a screen shot of it; "https://i.sstatic.net/GQwlt.png"

For more information you can also contact me on; Vinod W. B. @ [email protected]

Upvotes: 16

Related Questions