T-SQL Debugger – How to Change Default Port for T-SQL Debugger

configurationdebuggingsql serversql-server-2008-r2

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

Best Answer

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).