Jump to content

How is remote debugging allowed on Microsoft SQL Management studio?


Recommended Posts

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
 

Quote

 

only members of the sysadmin fixed server role are allowed to debug in SQL Server

Firewall port 135 should be open on both machines

https://msdn.microsoft.com/en-us/library/vstudio/s0fk6z6e(v=vs.100).aspx?f=255&MSPPError=-2147217396

https://msdn.microsoft.com/en-us/library/cc646024.aspx

 


 

Quote

 

Have you Configure the Transact-SQL Debugger ?

If not then :

https://msdn.microsoft.com/en-us/library/cc646024.aspx

After that test the following steps :

Test 1: When you locally connect to the same instance the issue is not reproduced

Test 2: Check if TCP 139, TCP 445, UDP 137 and UDP 138 are open from both side (server and client) (e.g.: Configuring the Transact-SQL Debugger )

Test 3: Check if SQL management Studio is lauched with "Run an administrator..."

Test 4: Check if SQL service account can connect to the client machine. When you are using T-SQL debugging, SQL service account will communicate with the machine host Management Studio.It's an additional reason to set up SQL service with domain account

Test 5: Check if SSMS and SQL server service are in the same domain. if not, set up the same account and password that SQL server is using.

Test 6: Check if your domain account is sysadmin.

Test 7: Check if Kerberos is enable correctly and SPN are ok for your instance. - The SQL Network Interface library was unable to register SPN - SQL Server 2008 connectivity issue : cannot generate SSPI context

Test 8: Check from server side that the service below are started - TCP/IP NetBIOS Helper - Remote Registry - RPC Service .Details

 


This link:
https://docs.microsoft.com/en-us/previous-versions/visualstudio/visual-studio-2010/s0fk6z6e(v=vs.100)?redirectedfrom=MSDNshows this:
 

Quote

 

To prepare Windows Firewall for remote debugging (when SQL Server is running on a different computer)

  1.     On the computer running Visual Studio you must add the following to the Windows Firewall exception list:
  •    The Visual Studio program, Devenv.exe.
  •         TCP port 135
  1.     On the computer running the instance of SQL Server, you must add the following to the Windows Firewall exception list:
  •         The SQL Server program, sqlservr.exe. By default, sqlservr.exe is installed in C:\Program Files\Microsoft SQL Server\MSSQL10.InstanceName\MSSQL\Binn, where InstanceName is MSSQLSERVER for the default instance, and the instance name for any named instance.
  •         TCP port 135

 

 

     If your domain policy requires network communication to be done through IPSec, you must also open the UDP 4500 and UDP 500 ports.

 

 

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?
 

01.png

02.png

03.png

04.png

Link to post
Share on other sites

It tells you what ports to unblock. You can easily google this

https://www.google.com/search?q=setup+sql+server+remote+debug&ie=UTF-8&oe=UTF-8&hl=en-us&client=safari

 

It’s not up to you to set those rules those have to be set by that person’s administration in their system

Edited by Earthshine

My resources are limited. You must ask the right questions

 

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...