running debugging tool

Question

Hi,

I am having a problem to connect from visual studio 2017 to a server that has SQL 2019.
When try to run a test query with debugger like: select * from mytable get this error:

I mad sure that firewall on both servers is off and run the visual studio 2017 (SSDT) as Administrator account and this administrator account has also sysadmin right on the remote SQL server and also the SQL service on the remote SQL server also running as this Administrator account.

What I missing here?

Answer 1

Hi @Shahin Mortazave ,

Try to connect with localhost server name. If it does not work, try to use ip address instead.
See this to get more details: https://learn.microsoft.com/en-us/visualstudio/debugger/unable-to-connect-to-the-microsoft-visual-studio-remote-debugging-monitor?view=vs-2019#dns
This document also provides information about other errors that may be encountered and how to resolve them.
Hope these will give you help.

Best regards,
Seeya

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
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

I don't know exactly about the debugger in Visual Studio, but the old debugger in SSMS needed to have permissions on your local RPC port.

Myself, I stopped using SQL debuggers soon twenty years ago. I found that I spent more time on getting it work than I gained in productivity. PRINT and SELECT works very well for me.

Answer 3

Is the user account is part of Local administrator's group in the SQL Server machine?

refer: https://learn.microsoft.com/en-us/archive/blogs/ajaykumarks/unable-to-do-remote-sql-stored-procedure-debugging-from-vs2010?WT.mc_id=DT-MVP-4015686