Debugging Stored Procedure from Visual Studio 2005

• payal27778

  Grasshopper

  Points: 13

  More actions

  March 3, 2008 at 1:24 pm

  #378980

  Hi ,

  I am using Visual studio 2005 with sql server 2005. I want to debug my stored procedure, which is situated on the server on the network(accessible through network share). I followed the following URL:

  http://aspnet.4guysfromrolla.com/articles/051607-1.aspx

  I have used Direct database debugging : When I right click my stored procedure and click 'step into stored procedure', I get the following error:

  "Unable to start T-SQL debugging. could not attach to SQL server process on 'sql_server_name'. The remote procedure call failed and did not execute"

  I am a sysadmin in SQL server. I am using windows authentication to login to sql server

  Any help?

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  March 3, 2008 at 8:00 pm

  #784749

  Is the Windows Firewall enabled on both machines? If so, you will need to create an exception for the debugger.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question