Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
The default port for T-SQL Debugger is 135, it is possible to change this port ? In my company this port is on special list of banned ports, therefore we need to open that service on another port number.
I am following this article:
Transact-SQL Debugger for SQL Server 2008 – Part 2 by Bill Ramos
I don't think it's possible to change the TCP port used by T-SQL Debugger. You can use an application such as RelayTCP and port forwarding rules on your router to achieve what you want. It's difficult to give specific recommendations without knowing more about your network topology.
It may be easier to set up a VPN to your site and then run T-SQL Debugger over VPN (I assume that LAN-local connections to TCP 135 will not be blocked).
