cant debug sql sprocs in visual studio pro 2005

• winston Smith

  SSCoach

  Points: 19500

  More actions

  March 23, 2006 at 11:00 am

  #171011

  im trying to step into sprocs so as to debug them. im running visual studio pro 2005, and sql server 2005.i have checked"allow

  sql/ clr debugging" and i am sure that i am admin on my machine and on the DB server. this is the error i get. has anyone

  come up against this and how did you solve it?

  the error i get is:

  Unable to start T-SQL Debugging. Could not attach to SQL Server process on <servername>.The rpc server is unavailable

• Steve Eckhart

  SSCommitted

  Points: 1880

  More actions

  March 24, 2006 at 8:23 am

  #628640

  Check this page: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q224370. I'm not sure if it's the answer or not, but RPC may not be running on your machine.

  ---

  Steve Eckhart