How is remote debugging allowed on Microsoft SQL Management studio?

[xarzu]

This is working with Sql Server version 2008 R2

 

Here are the other versions of software that might be helpful:

 

 

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:

 

 

I want to be able to instruct them, on their side, what they need to do to make this problem go away. Please advise.

[Bedders]

Check the Windows Firewall on the SQL Server and ensure that the listed ports (TCP 135, and UDP ports 500 and 4500) are allowed to the IP address of the remote computer that is running SQL Server Management Studio.

I had to follow something like this https://knowledgebase.apexsql.com/configure-remote-access-connect-remote-sql-server-instance-apexsql-tools/v when setting up our SQL 2019 server in order to allow other devices to access it, so I'd check there too.