SQL Server 2019 & T-SQL Debugging using Visual Studio

Question

Has anybody been successful in configuring SQL Server 2019, Visual Studio, and SSDT to enable T-SQL debugging? I have verified that all ports are open on our firewall but I still get this error: "Unable to start T-SQL debugging, Could not connect to computer <hostname>,1987. The debugger cannot connect to the remote computer. The debugger was unable to resolve the specified computer name." I should note that we are using a non-standard port for SQL Server - 1987. I also installed Visual Studio on the server with SQL Server, and I get the same results. I appreciate any help you can offer on what my problem is or how I can further troubleshoot. Thank you in advance!

Answer 1

Hi @mh53j_fe ,

SSMS needs to be able to find your SQL Server by DNS. When you connect to the DB in SSMS, you can use (local), but (local) does not resolve on your network so the debug program can not find it. Try connecting to localhost or your computer's name on the "Connect to Server" screen. You should not have to run as administrator. Quoted in Unable to start T-SQL Debugging. Could not connect to computer (“*****”)

Best regards,
Carrin

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi @mh53j_fe ,

Try below steps. For the details, please refer to Unable to Connect to the Microsoft Visual Studio Remote Debugging Monitor

Best regards,
Carrin

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 3

I had the same issue and it was solved by using the default 1433 port on the instance. The problem arises when you use a custom port for SQL Server. Not optimal for us as we want to use custom ports, so if anyone have a solution please share.