This is working with Sql Server version 2008 R2
Here are the other versions of software that might be helpful:
https://www.sqlservercentral.com/wp-content/uploads/hm_bbpui/3924844/dtrwhu4y2axnms3w5lvemj1q0byz1z42.png
How is remote debugging allowed on Microsoft SQL Management studio?
This question might be misunderstood. I am not sitting at the computer where Microsoft SQL Management studio resides and I am attempting to debug a remote database. That is not the issue I am having at all. Instead, I have remoted into a client's server by their request and also I am trying to debug an issue they are having. You see, this is how things are evolving in our world. More and more there are situations where a developer is working from home and has to remote into a client's system do get some work done.
When I open up their studio software on their side, if I try to debug or execute a command, I get this error message:
https://i.stack.imgur.com/5kprj.png
I want to be able to instruct them, on their side, what they need to do to make this problem go away. Please advise.
This link is of interest:
https://social.msdn.microsoft.com/Forums/office/en-US/f57e3d70-9084-43de-9847-d69a3aa80ed9/enable-remote-debug-tsql-in-sqlserver?forum=sqlgetstarted
This link: https://docs.microsoft.com/en-us/previous-versions/visualstudio/visual-studio-2010/s0fk6z6e(v=vs.100)?redirectedfrom=MSDNshows this:
So, I gather from this is that perhaps it is up to me to add to the Windows Firewall exception list:
"The Visual Studio program, Devenv.exe" and "TCP port 135" albeit I am not running Visual Studio. But I am assuming it can't hurt if I do this.
So, the question is: How do I do this?
I am not experienced with working with firewalls. I do not know how to add firewall exceptions. When I look for applicable system programs, a number of thems seem available. Can anyone guide me?
This is working with Sql Server version 2008 R2 Here are the other versions of software that might be helpful: https://www.sqlservercentral.com/wp-content/uploads/hm_bbpui/3924844/dtrwhu4y2axnms3w5lvemj1q0byz1z42.png How is remote debugging allowed on Microsoft SQL Management studio? This question might be misunderstood. I am not sitting at the computer where Microsoft SQL Management studio resides and I am attempting to debug a remote database. That is not the issue I am having at all. Instead, I have remoted into a client's server by their request and also I am trying to debug an issue they are having. You see, this is how things are evolving in our world. More and more there are situations where a developer is working from home and has to remote into a client's system do get some work done. When I open up their studio software on their side, if I try to debug or execute a command, I get this error message: https://i.stack.imgur.com/5kprj.png I want to be able to instruct them, on their side, what they need to do to make this problem go away. Please advise. This link is of interest: https://social.msdn.microsoft.com/Forums/office/en-US/f57e3d70-9084-43de-9847-d69a3aa80ed9/enable-remote-debug-tsql-in-sqlserver?forum=sqlgetstarted This link: https://docs.microsoft.com/en-us/previous-versions/visualstudio/visual-studio-2010/s0fk6z6e(v=vs.100)?redirectedfrom=MSDNshows this: So, I gather from this is that perhaps it is up to me to add to the Windows Firewall exception list: "The Visual Studio program, Devenv.exe" and "TCP port 135" albeit I am not running Visual Studio. But I am assuming it can't hurt if I do this. So, the question is: How do I do this? I am not experienced with working with firewalls. I do not know how to add firewall exceptions. When I look for applicable system programs, a number of thems seem available. Can anyone guide me?
