I am trying to debug the store procedure in SQL server 2005 . I have windows 7 64-Bit on my client computer and server is running SQL server 2005 standard edition. I am trying to debug store procedures in visual studio 2005 . I followed the below
I have followed all the articales however still i am unable to debug the store proc in my application . I did the following.
1: My local machnice user has administrator rights on my local machine and in SQL server it has sys admin rights.
2: On my client machine i am running windwos 7 64-bit version , database server is on windows Server 2003 64-bit edition.
3: I configured the remote debugger on windows server then i start the remote debugger 64 bit .
Now when i try to debug the store procedure i got the following error message.
Unable to start T-SQL Debugging. Could not connect to computer eicsrv01 . The Microsoft visual studio Remote Debugging
Monitor on the remote computer cannot connect to the local computer . A firewall may be preventing communication via