locked
unable to start t-sql debugging (could not attach to sql process) RRS feed

  • Question

  • Hi All

    I read the threads regarding this issue in this forum.

    Non of them suggested the possebility of 2008 R2 client debugging on 2008 R1 server.

    Can this be the reason to such an error (unable to start t-sql debugging etc).

    TIA

    Rea

    Thursday, November 1, 2012 2:59 PM

Answers

All replies

  • How exactly you're connecting? Can you connect using the server name? 

    For every expert, there is an equal and opposite expert. - Becker's Law


    My blog

    Thursday, November 1, 2012 3:01 PM
  • Rea, Please refer http://sqltrends.blogspot.com/2011/02/unable-to-start-t-sql-debugging-could.html

    Thanks
    Manish

    Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

    • Marked as answer by Kalman Toth Sunday, November 11, 2012 6:54 PM
    Thursday, November 1, 2012 3:08 PM
  • Hi Naomi

    I am connecting through management studio with sql server's name and a sql server authenticated user that has sysadmin server role.

    Connection is fine i can do every thing else including write t-sql procedure but when i want to debug it the above error happens.

    Thanks

    Sunday, November 4, 2012 7:56 AM
  • as i replayed to Naomi my user has sysadmin role.

    Its probably a remote access network related issue after all

    Sunday, November 4, 2012 8:14 AM
  • are you getting this error every time or on random basis?

    Have you notice something in windows event long for the same?


    Regards,
    Rohit Garg
    (My Blog)
    This posting is provided with no warranties and confers no rights.
    Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread.

    Sunday, November 4, 2012 9:40 AM
  • I know I had this error when I was connecting using Windows authentication and (local) as server name. Using the actual server name solved the problem for me. Your case seems to be different.

    For every expert, there is an equal and opposite expert. - Becker's Law


    My blog

    • Marked as answer by Kalman Toth Sunday, November 11, 2012 6:54 PM
    Sunday, November 4, 2012 3:30 PM